Resolution: Won't Do
Affects Version/s: 3.9.6
Fix Version/s: None
1. load the attached offset.xlsx
2. change B1 to 2
C2 doesn't change to 2
C2 is 2
- 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.