lira lira at source.lon-capa.org
Sun Jan 3 00:05:31 EST 2016

lira		Sun Jan  3 05:05:31 2016 EDT

Modified files:
Log:
fix formatting.

@@ -3,7 +3,7 @@
\textbf{Cells}

Cells may be specified by simply writing their name enclosed in either single quotes or double quotes.
-For instance, \texttt{'A17'} and \texttt{"A17"} will be
+For instance, \texttt{A17'} and \texttt{"A17"} will be
replaced with the value in row $A$ column 17 before the Perl command is evaluated.

\noindent
@@ -15,21 +15,22 @@

\begin{itemize}

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

\end{itemize}

-Many functions accept ranges, see \ref{Spreadsheet_Functions}. For example, \texttt{\&SUM('d*')} will add up all cells in column $d$.
+Many functions accept ranges, see \textbf{Special Functions} (\ref{Spreadsheet_Functions}). For example, \texttt{\&SUM(d*')} will add up all cells in column $d$.
+

\noindent
\textbf{Special References}

There is an additional means of referencing cells most used in the
-By using a '\#' in the place of a row number
+By using a \#' in the place of a row number
the spreadsheet will replace the \# with the current row number.  For example
-\texttt{'B\#'} will be replaced with the contents of cell $B7$ in the row 7 and
+\texttt{B\#'} will be replaced with the contents of cell $B7$ in the row 7 and
the contents of $B8$ in row 8.
Using the \#'' notation to specify rows is recommended.  See
`