Return to Spreadsheet_Referencing_Cells.tex CVS log

Up to [LON-CAPA] / loncom / html / adm / help / tex

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.