Return to Spreadsheet_HowTo.tex CVS log

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

Annotation of loncom/html/adm/help/tex/Spreadsheet_HowTo.tex, revision 1.6

1.1       matthew     1: \label{Spreadsheet_HowTo}
                      2: 
                      3: \textbf{Summing up columns}
                      4: 
1.5       lira        5: To take the sum of column M, for example, use \texttt{\&SUM(`M*')}\index{SUM}
1.1       matthew     6: 
1.4       riegler     7: \noindent
1.2       www         8: \textbf{Spreadsheet Lists}
1.4       riegler     9: 
1.1       matthew    10: When you have a list of numbers in a cell, how it is displayed depends
                     11: on how you separate the numbers and how Perl interprets the results.
                     12: 
1.4       riegler    13: \texttt{35 45 12} will not generate any result because this is an
1.3       webbsuza   14: invalid Perl statement.
1.1       matthew    15: 
1.4       riegler    16: \texttt{35,45,12} will have a result of 12 because Perl has a comma
1.1       matthew    17: operator similar to the comma operator\index{comma operator} in C.
                     18: 
                     19: The comma operator is binary and returns the value on its right. Thus
                     20: \texttt{\$variable = 15, 26;} assigns \texttt{\$variable} the value
1.6     ! lira       21: 26.  If you need the values to all be displayed as a string, enclose the entire
1.3       webbsuza   22: cell contents in quote marks.