Uploaded image for project: 'ZK Spreadsheet'
  1. ZK Spreadsheet
  2. ZSS-1417

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

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Won't Do
    • Icon: Normal 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

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

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

              Created:
              Updated:
              Resolved: