Return to Spreadsheet_Ranges.tex CVS log

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

Annotation of loncom/html/adm/help/tex/Spreadsheet_Ranges.tex, revision 1.3

1.2       bowersj2    1: \label{Spreadsheet_Ranges}
1.3     ! bowersj2    2: Ranges\index{ranges, spreadsheet} specify rectangles of various shapes
        !             3: in the spreadsheet, just as ranges do in traditional
        !             4: spreadsheets. Exmples of legitimate ranges: 
1.1       bowersj2    5: 
                      6: \begin{itemize}
                      7: 
                      8: \item \textbf{*} - all rows, all columns 
                      9: \item \textbf{B*} - all rows in column B 
                     10: \item \textbf{*5} - all columns in row 5 
                     11: \item \textbf{C5..F25} - all cells in the rectangle between C5 and F25
                     12: 
                     13: \end{itemize}
                     14: 
                     15: Many functions accept ranges. For example, \&SUM(``d*'') will add 
                     16: up all cells in column d.