Return to Spreadsheet_Referencing_Cells.tex CVS log

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

- Fix double quotes.

    1: \label{Spreadsheet_Referencing_Cells}
    2: 
    3: \textbf{Cells}
    4: 
    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.
    8: 
    9: \noindent
   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: 
   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
   22: 
   23: \end{itemize}
   24: 
   25: Many functions accept ranges, see \textbf{Special Functions} (\ref{Spreadsheet_Functions}). For example, \texttt{\&SUM(`d*')} will add up all cells in column $d$.
   26: 
   27: 
   28: \noindent
   29: \textbf{Special References}
   30: 
   31: There is an additional means of referencing cells most used in the 
   32: \textbf{template row} (\ref{Spreadsheet_Template_Row}).  
   33: By using a `\#' in the place of a row number
   34: the spreadsheet will replace the \# with the current row number.  For example
   35: \texttt{`B\#'} will be replaced with the contents of cell $B7$ in the row 7 and
   36: the contents of $B8$ in row 8.