Annotation of loncom/html/adm/help/tex/Spreadsheet_Calculation.tex, revision 1.1
1.1 ! matthew 1: \label{Spreadsheet_Completely_Recalc}
! 2: The total number of sheets in course can be tremendous, since it is
! 3: the number of students times the number of assessments. LON-CAPA
! 4: caches these sheets and only selectively invalidates those cache
! 5: copies if potentially relevant data changes. \textbf{Completely
! 6: Recalc} forces LON-CAPA to invalidate all cache copies.
! 7: \index{Completely Recalc}
! 8:
! 9: For instance, this is necessary to get the most up-to-date
! 10: calculations if the sheet itself contains direct access to the system
! 11: clock (making it ``out-of-date'' the moment it is calculated), or if
! 12: an assessment is edited in a way that would retroactively change
! 13: grading. The automatic spreadsheet devalidation catches student
! 14: submissions, \textbf{PAR}a\textbf{M}eter changes, and spreadsheet
! 15: changes, but not re-publication of a problem resource. \label{Spreadsheet_Max_Depth_Exceeded}
! 16: The ``Maximum Calculation Depth Exceeded''\index{Maximum Calculation
! 17: Depth Exceeded error} error can occur when you reference other cells in
! 18: calculations. For example, if you have:
! 19:
! 20: \texttt{G0 = Some\_complicated\_expression\\
! 21: X0 = G0>2?1:0}
! 22:
! 23: Try replacing \texttt{X0}'s contents with \texttt{[
! 24: (Some\_complicated\_expression) > 2]?1:0}. In other words, replace the
! 25: reference to \texttt{G0} with the actual contents of \texttt{G0}. That
! 26: might fix your error by removing one level of indirection that
! 27: LON-CAPA must process in order to compute the result.
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>