[BACK]Return to Spreadsheet_Referencing_Cells.tex CVS log [TXT] [DIR] Up to [LON-CAPA] / loncom / html / adm / help / tex
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, 8 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_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>