-
Bug
-
Resolution: Won't Do
-
Normal
-
None
-
3.9.6
-
None
-
None
Steps to Reproduce
1. load the attached offset.xlsx
2. change B1 to 2
Current Result
C2 doesn't change to 2
Expected Result
C2 is 2
Debug Information
- offset.xlsx contains several test cases. Edit cells in column A and B in offset.xlsx, the formulas in column C should update themselves. check each formula to get the details.
- the cause is: FormulaEngineImpl doesn't add OFFSET result as a precedent. ZSS just adds the OFFSET's first parameter as a precedent.
Workaround
register a custom formula engine (FormulaEngineExtend.java ) by FormulaEngineInit.java
- relates to
-
KEIKAI-66 edit cells referenced by OFFSET doesn't update the formula result
- Closed