[BACK]Return to Spreadsheet_HowTo.tex CVS log [TXT] [DIR] Up to [LON-CAPA] / loncom / html / adm / help / tex
File:  [LON-CAPA] / loncom / html / adm / help / tex / Spreadsheet_HowTo.tex
Revision 1.3: download - view: text, annotated - select for diffs
Tue Aug 8 17:47:27 2006 UTC (17 years, 10 months ago) by webbsuza
Branches: MAIN
CVS tags: version_2_9_X, version_2_9_99_0, version_2_9_1, version_2_9_0, version_2_8_X, version_2_8_99_1, version_2_8_99_0, version_2_8_2, version_2_8_1, version_2_8_0, version_2_7_X, version_2_7_99_1, version_2_7_99_0, version_2_7_1, version_2_7_0, version_2_6_X, version_2_6_99_1, version_2_6_99_0, version_2_6_3, version_2_6_2, version_2_6_1, version_2_6_0, version_2_5_X, version_2_5_99_1, version_2_5_99_0, version_2_5_2, version_2_5_1, version_2_5_0, version_2_4_X, version_2_4_99_0, version_2_4_2, version_2_4_1, version_2_4_0, version_2_3_X, version_2_3_99_0, version_2_3_2, version_2_3_1, version_2_3_0, version_2_2_X, version_2_2_99_1, version_2_2_99_0, version_2_2_2, version_2_2_1, version_2_2_0, version_2_1_99_3, bz6209-base, bz6209, bz5969, bz2851, PRINT_INCOMPLETE_base, PRINT_INCOMPLETE, HEAD, GCI_3, GCI_2, GCI_1, BZ5971-printing-apage, BZ5434-fox
reworded, changing from passivve to active voice, added commas, fixed a few typos.CVS: ----------------------------------------------------------------------

\label{Spreadsheet_HowTo}

\textbf{Summing up columns}

To take the sum of column ``M'', for example, use \texttt{\&SUM(``M*'')}\index{SUM}

\textbf{Spreadsheet Lists}
When you have a list of numbers in a cell, how it is displayed depends
on how you separate the numbers and how Perl interprets the results.

\textbf{35 45 12} will not generate any result because this is an
invalid Perl statement.

\textbf{35,45,12} will have a result of 12 because Perl has a comma
operator similar to the comma operator\index{comma operator} in C.

The comma operator is binary and returns the value on its right. Thus
\texttt{\$variable = 15, 26;} assigns \texttt{\$variable} the value
26.  If you need the values to all be displayed, enclose the entire
cell contents in quote marks.
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>