Return to Spreadsheet_Authoring.tex CVS log

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

Annotation of loncom/html/adm/help/tex/Spreadsheet_Authoring.tex, revision 1.1

1.1     ! lira        1: \label{Spreadsheet_Authoring}
        !             2: 
        !             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:
        !             4:  
        !             5: \begin{verbatim} 
        !             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> 
        !            10: \end{verbatim}
        !            11: 
        !            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.