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

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

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

              Dates

                Created:
                Updated:
                Resolved: