search

handsontable / hyperformula

HyperFormula is an open-source headless spreadsheet for business web apps. It comes with over 400 formulas, CRUD operations, undo-redo, clipboard support, and sorting.
https://hyperformula.handsontable.com/
Other
1.9k stars 108 forks source link

get affected formula addresses #1330

Closed richcanvas closed 7 months ago

richcanvas commented 8 months ago

data=[ [1,2], ['=sum(A1:A2)',''] ] after call hfInstance.addRows(0,[0,1]), how to get all affected formula addresses?

adrianszymanski89 commented 8 months ago

Hi @richcanvas

Thank you for contacting us. The addRows method won't return the formula addresses. Its behavior is very well described here: https://github.com/handsontable/hyperformula/issues/845

The functionality you're looking for isn't implemented yet, but it is already requested here: https://github.com/handsontable/hyperformula/issues/1156

richcanvas commented 8 months ago

thanks for reply.

richcanvas commented 8 months ago

hi, what's the ETA of this feature?

adrianszymanski89 commented 8 months ago

Hi @richcanvas

It's not on our roadmap yet. We will update this topic once it gets there.

sequba commented 8 months ago

@richcanvas Do you mind describing your application and the scenario in which you need to get the formulas affected by an operation? It will help us design the solution.

sequba commented 7 months ago

Closing this issue due to inactivity.

@richcanvas, please use issue https://github.com/handsontable/hyperformula/issues/1156 to provide more information about the requested feature.