A formula is moved after switching to another sheet

XMLWordPrintable

    • Type: Bug
    • Resolution: Fixed
    • Priority: Major
    • 3.8.1
    • Affects Version/s: 3.8.0
    • Component/s: None
    • Security Level: Jean
    • None

      Steps to reproduce

      1. open a blank sheet with firefox
      2. enter an incorrect formula, =sum(1, at sheet1
      3. switch to sheet2
      4. zss pops up an error message, click OK to dismiss the error message
      5. enter ) to complete the formula

      Another steps

      1) Open a new sheet
      2) On Sheet 1, add =sum(1,2) to cell C4
      3) On Sheet 2, add =sum(3,4) to cell C4
      4) On Sheet 1, delete right parenthesis of the formula like =sum(1,2
      5) While still in edit mode, switch to Sheet 2 and you will see that your formula in C4 has now been replaced with the one from Sheet 1.

      Actual result

      now the formula is moved to sheet2. If the cell at sheet2 contains data, it will be overridden.

      Expected result

      Like it doesn in chrome, cannot switch to another sheet.

      Debug information

      • You can watch the 2nd part of attached video for reproducing.

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

              Created:
              Updated:
              Resolved: