Return to Spreadsheet_Calculation.tex CVS log

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

Annotation of loncom/html/adm/help/tex/Spreadsheet_Calculation.tex, revision 1.3

1.2       matthew     1: \label{Spreadsheet_Calculation}
                      2: 
                      3: The total number of spreadsheets in course can be tremendous, since it is
1.1       matthew     4: the number of students times the number of assessments. LON-CAPA
                      5: caches these sheets and only selectively invalidates those cache
1.2       matthew     6: copies if potentially relevant data changes. 
1.1       matthew     7: 
1.2       matthew     8: The automatic spreadsheet devalidation catches student
1.1       matthew     9: submissions, \textbf{PAR}a\textbf{M}eter changes, and spreadsheet
1.2       matthew    10: changes, but not re-publication of a problem resource.  
                     11: 
1.3     ! albertel   12: \textbf{Spreadsheet\_Max\_Depth\_Exceeded}
1.2       matthew    13: 
1.1       matthew    14: The ``Maximum Calculation Depth Exceeded''\index{Maximum Calculation
                     15: Depth Exceeded error} error can occur when you reference other cells in
                     16: calculations. For example, if you have: 
                     17: 
                     18: \texttt{G0 = Some\_complicated\_expression\\
                     19:  X0 = G0>2?1:0}
                     20: 
                     21: Try replacing \texttt{X0}'s contents with \texttt{[
                     22: (Some\_complicated\_expression) > 2]?1:0}. In other words, replace the
                     23: reference to \texttt{G0} with the actual contents of \texttt{G0}. That
                     24: might fix your error by removing one level of indirection that
                     25: LON-CAPA must process in order to compute the result.