Annotation of loncom/html/adm/help/tex/Spreadsheet_Referencing_Cells.tex, revision 1.6
1.1 matthew 1: \label{Spreadsheet_Referencing_Cells}
2:
3: \textbf{Cells}
4:
1.5 riegler 5: Cells may be specified by simply writing their name enclosed in either single quotes or double quotes.
1.6 ! lira 6: For instance, \texttt{`A17'} and \texttt{"A17"} will be
1.5 riegler 7: replaced with the value in row $A$ column 17 before the Perl command is evaluated.
1.1 matthew 8:
1.5 riegler 9: \noindent
1.1 matthew 10: \textbf{Ranges}
11:
12: Ranges \index{ranges, spreadsheet} specify rectangles of various shapes
13: in the spreadsheet, just as ranges do in traditional spreadsheets.
14: Ranges must be enclosed in quotes. Examples of legitimate ranges:
15:
16: \begin{itemize}
17:
1.6 ! lira 18: \item \texttt{`*'} - all rows, all columns
! 19: \item \texttt{`B*'} - all rows in column B
! 20: \item \texttt{`*5'} - all columns in row 5
! 21: \item \texttt{`C5'..`F25'} - all cells in the rectangle between C5 and F25
1.1 matthew 22:
23: \end{itemize}
24:
1.6 ! lira 25: Many functions accept ranges, see \textbf{Special Functions} (\ref{Spreadsheet_Functions}). For example, \texttt{\&SUM(`d*')} will add up all cells in column $d$.
! 26:
1.1 matthew 27:
1.5 riegler 28: \noindent
1.1 matthew 29: \textbf{Special References}
30:
31: There is an additional means of referencing cells most used in the
32: \textbf{template row} (\ref{Spreadsheet_Template_Row}).
1.6 ! lira 33: By using a `\#' in the place of a row number
1.3 www 34: the spreadsheet will replace the \# with the current row number. For example
1.6 ! lira 35: \texttt{`B\#'} will be replaced with the contents of cell $B7$ in the row 7 and
1.5 riegler 36: the contents of $B8$ in row 8.
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>