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.
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>