notify change doesn't work when spreadsheet is never rendered before

XMLWordPrintable

    • Type: Bug
    • Resolution: Fixed
    • Priority: Normal
    • 5.11.0
    • Affects Version/s: 5.10.0
    • Component/s: None
    • Security Level: Jimmy
    • None
    • None

      Steps to Reproduce

      1. click "Update and Show" button

      Current Result

      no values in cells

      Expected Result

      there should be 10 cells with 1

      Debug Information

      • Spreadsheet.update(), getActiveRangeHelper().containsSheet(sheet) return false, since the spreadsheet is never rendered in a browser, so there is no active range to render.
      • From the point of view of Keikai API users, they should not need to consider the internal state of a spreadsheet to call notifyChange(). The Spreadsheet should be responsible for taking care of the client rendering. For example, the spreadsheet should invalidate/render the whole sheet, when a spreadsheet is visible but has no active range (like rendering at the first time).

      Workaround

      • Ranges.range(ss.getSelectedSheet()).notifyChange();
      • spreadsheet.invalidate();

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

              Created:
              Updated:
              Resolved: