[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.4: download - view: text, annotated - select for diffs
Tue Aug 8 17:47:27 2006 UTC (18 years 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: ----------------------------------------------------------------------

    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>