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

Support "update range" for better performance

XMLWordPrintable

    • Icon: New Feature New Feature
    • Resolution: Invalid
    • Icon: Major Major
    • 3.6.0
    • None
    • None
    • Security Level: Jimmy
    • None

      Currently need to update each cell via setValue API one by one, and this API will render lots of other command including text-align, color or font-size except just update their value (see screenshot.png attached).

      There should an API like

      Ranges.range(sheet, top_row, left_col, bottom_row, right_col).setValues(List<List<Object>>);
      

      or

      Ranges.range(sheet, top_row, left_col, bottom_row, right_col).setValues(Object[][]);
      

      Furthermore, the generated response should be much simpler,
      e.g.,

      {top: 0, left: 0, wd: 30, hgh: 50, values:[[...], [...]]} // update 30 cols x 50 rows with values, starts from 0, 0.
      

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

              Created:
              Updated:
              Resolved: