Changing cell style doesn't trigger formula recalculation

XMLWordPrintable

    • Type: New Feature
    • Resolution: Done
    • Priority: Normal
    • 3.8.0
    • Affects Version/s: 3.7.0
    • Component/s: 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

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

              Created:
              Updated:
              Resolved: