Hooks "beforeParse"

Tags: #<Tag:0x00007efc699e1b70>
#1

Is there any hooks which can be called before handsontable parser to change the value passed to it?

Example:

Cell value: =SUM(A:A)
What I want to pass to the parser: =SUM(A1:A999999)

#2

Hi @nathalia.pissuti

Is the formula added/changed by the user of when the change should happen?

#3

The formula was added by the user, but I don’t want to change it directly, because the user can download the file and edit in excel and might not work as expected

#4

The current formula plugin does not allow injecting changes to the formula as follows.

The formula plugin is planned to support rewriting formulas with custom logic. However, it is still in preparation. Here’s the progress on the new plugin https://github.com/handsontable/handsontable/projects/2

#5

Okay, thanks for the support!

#6