File:
[LON-CAPA] /
loncom /
html /
adm /
help /
tex /
Spreadsheet_Referencing_Cells.tex
Revision
1.3:
download - view:
text,
annotated -
select for diffs
Tue Oct 14 16:03:51 2003 UTC (20 years, 10 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_Referencing_Cells}
2:
3: \textbf{Cells}
4:
5: Cells may be specified by simply writing their name. \texttt{A17} will be
6: replaced with the value in row A column 17 before the perl is evaluated.
7:
8: \textbf{Ranges}
9:
10: Ranges \index{ranges, spreadsheet} specify rectangles of various shapes
11: in the spreadsheet, just as ranges do in traditional spreadsheets.
12: Ranges must be enclosed in quotes. Examples of legitimate ranges:
13:
14: \begin{itemize}
15:
16: \item \textbf{``*''} - all rows, all columns
17: \item \textbf{``B*''} - all rows in column B
18: \item \textbf{``*5''} - all columns in row 5
19: \item \textbf{``C5''..``F25''} - all cells in the rectangle between C5 and F25
20:
21: \end{itemize}
22:
23: Many functions accept ranges. For example, \&SUM(``d*'') will add
24: up all cells in column d.
25:
26: \textbf{Special References}
27:
28: There is an additional means of referencing cells most used in the
29: \textbf{template row} (\ref{Spreadsheet_Template_Row}).
30: By using a ``\#'' in the place of a row number
31: the spreadsheet will replace the \# with the current row number. For example
32: \texttt{B\#} will be replaced with the contents of cell B7 in the row 7 and
33: the contents of B8 in row 8.
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>