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 (18 years, 1 month 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: ----------------------------------------------------------------------
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 quote marks.
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>