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.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.