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

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

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Normal
    • Resolution: Won't Do
    • Affects Version/s: 3.9.6
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None

      Description

      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

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                Created:
                Updated:
                Resolved: