Return to Spreadsheet_Max_Depth_Exceeded.tex CVS log

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

Annotation of loncom/html/adm/help/tex/Spreadsheet_Max_Depth_Exceeded.tex, revision 1.4

1.2       bowersj2    1: \label{Spreadsheet_Max_Depth_Exceeded}
1.3       bowersj2    2: The ``Maximum Calculation Depth Exceeded''\index{Maximum Calculation
                      3: Depth Exceeded error} erro can occur when you reference other cells in
                      4: calculations. For example, if you have: 
1.1       bowersj2    5: 
1.4     ! bowersj2    6: \texttt{G0 = Some\_complicated\_expression\\
1.1       bowersj2    7:  X0 = G0>2?1:0}
                      8: 
                      9: Try replacing \texttt{X0}'s contents with \texttt{[
1.4     ! bowersj2   10: (Some\_complicated\_expression) > 2]?1:0}. In other words, replace the
1.1       bowersj2   11: reference to \texttt{G0} with the actual contents of \texttt{G0}. That
                     12: might fix your error by removing one level of indirection that
                     13: LON-CAPA must process in order to compute the result.