Annotation of loncom/html/adm/help/tex/Spreadsheet_Referencing_Cells.tex, revision 1.5
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.
! 6: For instance, \texttt{'A17'} and \texttt{"A17"} will be
! 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.5 ! riegler 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.5 ! riegler 25: Many functions accept ranges, see \ref{Spreadsheet_Functions}. For example, \texttt{\&SUM('d*')} will add up all cells in column $d$.
1.1 matthew 26:
1.5 ! riegler 27: \noindent
1.1 matthew 28: \textbf{Special References}
29:
30: There is an additional means of referencing cells most used in the
31: \textbf{template row} (\ref{Spreadsheet_Template_Row}).
1.5 ! riegler 32: By using a '\#' in the place of a row number
1.3 www 33: the spreadsheet will replace the \# with the current row number. For example
1.5 ! riegler 34: \texttt{'B\#'} will be replaced with the contents of cell $B7$ in the row 7 and
! 35: the contents of $B8$ in row 8.
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>