Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Critical
-
Resolution: Fixed
-
Affects Version/s: 5.4.0
-
Fix Version/s: 5.6.0
-
Component/s: None
-
Security Level: Jimmy
-
Labels:None
Description
Steps to Reproduce
1. import the attached file
Current Result
it takes over 90 seconds and still can't render a result
Expected Result
render its content
Debug Information
- When evaluating payment!A8, keikai evaluates it as ErrorEval.CIRCULAR_REF_ERROR
set a breakpoint at org.zkoss.poi.ss.formula.WorkbookEvaluatorprivate ValueEval evaluateAny(EvaluationCell srcCell, int sheetIndex, int rowIndex, int columnIndex, EvaluationTracker tracker, Object ref, int[] offset) { //ZSS-1142 ... if (cce.getValue() == null) { if (!tracker.startEvaluate(cce)) { return ErrorEval.CIRCULAR_REF_ERROR; }
Workaround
not found
Attachments
Issue Links
- relates to
-
KEIKAI-479 SUMPRODUCT() in IF() doesn't return the expected result
-
- Closed
-