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

1.2     ! bowersj2    1: \label{Spreadsheet_Ranges}
1.1       bowersj2    2: Ranges specify rectangles of various shapes in the spreadsheet, just
                      3: as ranges do in traditional spreadsheets. Exmples of legitimate
                      4: ranges: 
                      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.