[BACK]Return to Spreadsheet_Ranges.tex CVS log [TXT] [DIR] Up to [LON-CAPA] / loncom / html / adm / help / tex
File:  [LON-CAPA] / loncom / html / adm / help / tex / Attic / Spreadsheet_Ranges.tex
Revision 1.4: download - view: text, annotated - select for diffs
Wed Dec 11 19:04:47 2002 UTC (21 years, 7 months ago) by albertel
Branches: MAIN
CVS tags: version_1_0_0, version_0_99_5, version_0_99_4, version_0_99_3, version_0_99_2, version_0_99_1, version_0_99_0, version_0_6_2, version_0_6, conference_2003, HEAD
- spellchecked (BUG#1052)

\label{Spreadsheet_Ranges}
Ranges\index{ranges, spreadsheet} specify rectangles of various shapes
in the spreadsheet, just as ranges do in traditional
spreadsheets. Examples 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.
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>