Uploaded image for project: 'Keikai'
  1. Keikai
  2. KEIKAI-528

modify an existing custom formula, but it shows the formula not the result

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Normal
    • 5.10.0
    • 5.8.1
    • None
    • Security Level: Jimmy
    • None

    Description

      Steps to Reproduce

      1. load a blank file
      2. enter =SUM(2,2) at A1
      3. modify it to =SUM(1,3)

      Current Result

      A1 shows the formula itself in cell not the value

      Expected Result

      show 4

      Debug Information

      • for ZSS-1164, keikai writes user input text into cell DOM to show user input immediately without waiting the server response, especially under slow network. But when updating a cell with server data, cell widget doesn't change the cell DOM text when the result text doesn't change (after fixing KEIKAI-470). Hence, if I edit a formula but it still produces the same result, cell widget doesn't change its text in DOM, so it keeps showing the entered formula.

      Workaround

      keikai-528.js

      • For a cell with a formula, don't write formula text into DOM, since formula is not a result. That case is useful when user input a text or a number.

      Attachments

        1. formula.jpg
          formula.jpg
          6 kB
        2. keikai-528.js
          0.8 kB

        Issue Links

          Activity

            People

              jumperchen jumperchen
              hawk hawk
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: