Return to Spreadsheet_Ranges.tex CVS log

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

Added index tags, fixed irrelevant bug in author.manual.texxml, created
spreadsheet.manual.texxml .

\label{Spreadsheet_Ranges}
Ranges\index{ranges, spreadsheet} specify rectangles of various shapes
in the spreadsheet, just as ranges do in traditional
spreadsheets. Exmples of legitimate ranges: 

\begin{itemize}

\item \textbf{*} - all rows, all columns 
\item \textbf{B*} - all rows in column B 
\item \textbf{*5} - all columns in row 5 
\item \textbf{C5..F25} - all cells in the rectangle between C5 and F25

\end{itemize}

Many functions accept ranges. For example, \&SUM(``d*'') will add 
up all cells in column d.