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

Changing cell style doesn't trigger formula recalculation

XMLWordPrintable

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

      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

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

              Created:
              Updated:
              Resolved: