File:
[LON-CAPA] /
loncom /
html /
adm /
help /
tex /
Spreadsheet_Authoring.tex
Revision
1.1:
download - view:
text,
annotated -
select for diffs
Thu Dec 29 02:12:15 2016 UTC (7 years, 8 months ago) by
lira
Branches:
MAIN
CVS tags:
version_2_12_X,
version_2_11_X,
version_2_11_5_msu,
version_2_11_5,
version_2_11_4_uiuc,
version_2_11_4_msu,
version_2_11_4,
version_2_11_3_uiuc,
version_2_11_3_msu,
version_2_11_3,
version_2_11_2_uiuc,
version_2_11_2_msu,
version_2_11_2_educog,
version_2_11_2,
HEAD
improving spreadsheet documentation
\label{Spreadsheet_Authoring}
To use a spreadsheet in multiple courses, authors can create spreadsheet XML files in their authoring space. Published spreadsheets can be imported into courses. See \textbf{Loading a Spreadsheet Definition from a Published File} (\ref{Spreadsheet_Loading}). The spreadsheet syntax is illustrated by the following example demonstrating both text and formulas:
\begin{verbatim}
<field col=A row=0>`Available Points:'</field>
<field col=B row=0>&SUM(`X*')</field>
<field col=C row=0>`Awarded Points:'</field>
<field col=D row=0>&SUM(`Z*')</field>
\end{verbatim}
See \textbf{Modifying the Spreadsheet} (\ref{Spreadsheet_Editing}) for more information on programming cells. Very complex calculations can be performed in the cells. The file must be saved in authoring space with the extension .spreadsheet. Currently, a spreadsheet must be imported into authoring space as a .txt file and then renamed to a .spreadsheet. After it is published with the .spreadsheet extension, it can be imported into a course.
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>