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.1

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