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.2

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: 
        !            12: \textbf{Spreadsheet_Max_Depth_Exceeded}
        !            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.