Spreadsheet changes a correct sum formula to an incorrect one

XMLWordPrintable

    • Type: Bug
    • Resolution: Fixed
    • Priority: Normal
    • 3.7.0
    • Affects Version/s: 3.6.0
    • Component/s: 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.

        1. changedFormula.png
          changedFormula.png
          4 kB
        2. sumFormula-Fixed.png
          sumFormula-Fixed.png
          3 kB

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

              Created:
              Updated:
              Resolved: