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

Spreadsheet changes a correct sum formula to an incorrect one

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Normal Normal
    • 3.7.0
    • 3.6.0
    • None
    • Security Level: Jimmy
    • None

      Steps to Reproduce

      1. visit zss demo site or load a blank xlsx
      2. enter a number, 1, at A1
      3. enter a number, 2, at B1
      4. enter a formula =(A1+B1) at C1
        parentheses must be kept.

      Actual Result

      • C1's value is #VALUE
      • Originally-entered formula, =(A1,B1), is changed to =(A1,B1)

      Expected Result

      If you do the same steps in Excel, you will get 3 at C1 and the formula will not be changed.

      Debug Information

      A formula =(A1+B1)*2 works correctly.

            Jenkins Jenkins
            hawk hawk
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: