Annotation of loncom/html/adm/help/tex/Spreadsheet_Referencing_Cells.tex, revision 1.1
1.1 ! matthew 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>