File:
[LON-CAPA] /
loncom /
html /
adm /
help /
tex /
Spreadsheet_Referencing_Cells.tex
Revision
1.4:
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: ----------------------------------------------------------------------
\label{Spreadsheet_Referencing_Cells}
\textbf{Cells}
Cells may be specified by simply writing their name. \texttt{A17} will be
replaced with the value in row A column 17 before the Perl is evaluated.
\textbf{Ranges}
Ranges \index{ranges, spreadsheet} specify rectangles of various shapes
in the spreadsheet, just as ranges do in traditional spreadsheets.
Ranges must be enclosed in quotes. Examples of legitimate ranges:
\begin{itemize}
\item \textbf{``*''} - all rows, all columns
\item \textbf{``B*''} - all rows in column B
\item \textbf{``*5''} - all columns in row 5
\item \textbf{``C5''..``F25''} - all cells in the rectangle between C5 and F25
\end{itemize}
Many functions accept ranges. For example, \&SUM(``d*'') will add
up all cells in column d.
\textbf{Special References}
There is an additional means of referencing cells most used in the
\textbf{template row} (\ref{Spreadsheet_Template_Row}).
By using a ``\#'' in the place of a row number
the spreadsheet will replace the \# with the current row number. For example
\texttt{B\#} will be replaced with the contents of cell B7 in the row 7 and
the contents of B8 in row 8.
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>