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.
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>