[LON-CAPA-cvs] cvs: loncom /html/adm/help/tex Spreadsheet_Referencing_Cells.tex Spreadsheet_Template_Row.tex

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:              
    /loncom/html/adm/help/tex	Spreadsheet_Referencing_Cells.tex 
                             	Spreadsheet_Template_Row.tex 
  Log:
  fix formatting.
  
  
Index: loncom/html/adm/help/tex/Spreadsheet_Referencing_Cells.tex
diff -u loncom/html/adm/help/tex/Spreadsheet_Referencing_Cells.tex:1.5 loncom/html/adm/help/tex/Spreadsheet_Referencing_Cells.tex:1.6
--- loncom/html/adm/help/tex/Spreadsheet_Referencing_Cells.tex:1.5	Mon Aug 23 16:16:18 2010
+++ loncom/html/adm/help/tex/Spreadsheet_Referencing_Cells.tex	Sun Jan  3 05:05:31 2016
@@ -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 
 \textbf{template row} (\ref{Spreadsheet_Template_Row}).  
-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.
Index: loncom/html/adm/help/tex/Spreadsheet_Template_Row.tex
diff -u loncom/html/adm/help/tex/Spreadsheet_Template_Row.tex:1.8 loncom/html/adm/help/tex/Spreadsheet_Template_Row.tex:1.9
--- loncom/html/adm/help/tex/Spreadsheet_Template_Row.tex:1.8	Mon Aug 23 16:16:18 2010
+++ loncom/html/adm/help/tex/Spreadsheet_Template_Row.tex	Sun Jan  3 05:05:31 2016
@@ -7,5 +7,5 @@
 If a cell in the spreadsheet already has a value, that value will be preserved.
 
 Using the ``\#'' notation to specify rows is recommended.  See 
-Referencing Spreadsheet Cells (\ref{Spreadsheet_Referencing_Cells}) 
+\textbf{Referencing Spreadsheet Cells} (\ref{Spreadsheet_Referencing_Cells}) 
 for more information.




More information about the LON-CAPA-cvs mailing list