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

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
1.4     ! webbsuza    6: replaced with the value in row A column 17 before the Perl is evaluated.
1.1       matthew     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 
1.2       matthew    19: \item \textbf{``C5''..``F25''} - all cells in the rectangle between C5 and F25
1.1       matthew    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}).  
1.3       www        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
1.1       matthew    33: the contents of B8 in row 8.