Return to Authoring_Spreadsheet.tex CVS log

Up to [LON-CAPA] / loncom / html / adm / help / tex

Annotation of loncom/html/adm/help/tex/Authoring_Spreadsheet.tex, revision 1.4

1.1       felicia     1: \label{Authoring_Spreadsheet}
                      2: 
1.4     ! lira        3: 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:
1.3       lira        4:  
1.2       riegler     5: \begin{verbatim} 
1.3       lira        6: <field col=A row=0>`Available Points:'</field>
                      7: <field col=B row=0>&SUM(`X*')</field>
                      8: <field col=C row=0>`Awarded Points:'</field>
                      9: <field col=D row=0>&SUM(`Z*')</field> 
1.1       felicia    10: \end{verbatim}
                     11: 
1.4     ! lira       12: 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.