File:
[LON-CAPA] /
loncom /
html /
adm /
help /
tex /
Spreadsheet_HowTo.tex
Revision
1.2:
download - view:
text,
annotated -
select for diffs
Tue Oct 14 16:03:51 2003 UTC (20 years, 11 months ago) by
www
Branches:
MAIN
CVS tags:
version_2_1_X,
version_2_1_99_2,
version_2_1_99_1,
version_2_1_99_0,
version_2_1_3,
version_2_1_2,
version_2_1_1,
version_2_1_0,
version_2_0_X,
version_2_0_99_1,
version_2_0_2,
version_2_0_1,
version_2_0_0,
version_1_99_3,
version_1_99_2,
version_1_99_1_tmcc,
version_1_99_1,
version_1_99_0_tmcc,
version_1_99_0,
version_1_3_X,
version_1_3_3,
version_1_3_2,
version_1_3_1,
version_1_3_0,
version_1_2_X,
version_1_2_99_1,
version_1_2_99_0,
version_1_2_1,
version_1_2_0,
version_1_1_X,
version_1_1_99_5,
version_1_1_99_4,
version_1_1_99_3,
version_1_1_99_2,
version_1_1_99_1,
version_1_1_99_0,
version_1_1_3,
version_1_1_2,
version_1_1_1,
version_1_1_0,
version_1_0_99_3,
version_1_0_99_2,
version_1_0_99_1,
version_1_0_99,
HEAD
Bug #2281: need to escape stuff!
\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 quotes.
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>