Support add event listener for specific range value result changes

XMLWordPrintable

    • Type: New Feature
    • Resolution: Done
    • Priority: Normal
    • 6.2.0
    • Affects Version/s: None
    • Component/s: None
    • None
    • None

      Support attaching callback function to a specific range on range value change.
      (also with formula result change)
      Example ---------

      Consumer<CellRegion>

      Case: Direct value change

      Sheet#addCellRegionValueChangeListener(CellRegion cellRegion, Consumer<CellRegion> listener)
Sheet#removeCellRegionValueChangeListener(CellRegion cellRegion);
Sheet#removeCellRegionValueChangeListener(Consumer<CellRegion> listener)

sheet1.addCellRegionValueChangeListener((CellRegion cellRegion) -> {
  Ranges.range(sheet, cellRegion)...
)};

Ranges.range(sheet, cellRegion).setCellValue(99);
// Result: A1 -> 99
// receives only one event

            Assignee:
            DevChu
            Reporter:
            wenninghsu
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved: