-
Bug
-
Resolution: Fixed
-
Normal
-
3.0.0 RC
-
None
When using xls format and there are formulas referred to other sheets, reorder sheet's position causes these formulas's reference has been change.
It should not be modified and xlsx format won't get this issue.
reproduce steps:
- load attached xls file
- there are 5 sheets and every sheet has formulas referred to other four sheets
- move sheet "Sheet2" to right
- the order will be "Sheet1" "Sheet3" "Sheet2" "Sheet4" "Sheet5"
- switch to "Sheet3", "Sheet4" and "Sheet5", some of their formulas has been changed
- e.g Sheet3 D1 has been change to "=Sheet3!D1", origin is "=Sheet4!D1"