Annotation of loncom/html/adm/help/tex/Spreadsheet_HowTo.tex, revision 1.2
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:
1.2 ! www 7: \textbf{Spreadsheet Lists}
1.1 matthew 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.
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>