[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.2: download - view: text, annotated - select for diffs
Tue Oct 14 16:03:51 2003 UTC (20 years, 9 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!

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