edit cells referenced by OFFSET doesn't update the formula result

XMLWordPrintable

    • Type: Bug
    • Resolution: Won't Do
    • Priority: Normal
    • None
    • Affects Version/s: 3.9.6
    • Component/s: 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

        1. FormulaEngineExtend.java
          5 kB
        2. FormulaEngineInit.java
          0.3 kB
        3. offset.xlsx
          9 kB

            Assignee:
            Unassigned
            Reporter:
            hawk
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: