hyperformula icon indicating copy to clipboard operation
hyperformula copied to clipboard

Pass back ExportedCellChange in sheetRenamed Listener

Open BrianHung opened this issue 2 years ago • 3 comments

Description

https://github.com/handsontable/hyperformula/discussions/918#discussioncomment-2365097

When a sheet is renamed, a list of ExportedCellChange should be passed back in the sheetRenamed Listener. This would allow for the dependent cell values in the original data source to be kept up to date upon a sheet rename event.

BrianHung avatar Mar 15 '22 19:03 BrianHung

I was thinking about a method getSheetDependents(sheetId) similar to getCellDependents that returns a list of all the cells (in sheets other then sheetId) that contain a reference to sheetId. Will that work for you?

Details have been discussed in #918

sequba avatar Mar 16 '22 09:03 sequba

@sequba That would also work!

BrianHung avatar Mar 16 '22 22:03 BrianHung

(in sheets other then sheetId)

Think it might be useful to also include cells in sheetId if for some reason, a cell references another cell in the same sheet using SheetName! cell notation.

BrianHung avatar Mar 17 '22 02:03 BrianHung