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

Changing cell style doesn't trigger formula recalculation

    XMLWordPrintable

Details

    • New Feature
    • Resolution: Done
    • Normal
    • 3.8.0
    • 3.7.0
    • None
    • Security Level: Jimmy
    • None

    Description

      Requirement Description

      In current model design, no matter changing style or data, zss model will send a model event to notify spreadsheet about range of content change. It doesn't differentiate between data and style. (refer to ModelUpdateWrapper.doNotify() inside org.zkoss.zss.range.impl.RangeImpl) Therefore, CellOpertaionUtil.applyBorder() and range.setCellStyle() both trigger a model event.

      If users have custom formulas that retrieve data from a database, and they might not be re-evaluated all the time. The re-evaluation triggered by changing a style will cause a problem. Hence, The benefits of changing style doesn't trigger recalculation of a formula:

      • avoid formula calculation effort for a style change

      Attachments

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: