[Formulas] Are there any way to customize formulas

Tags: #<Tag:0x00007fa996165fc0> #<Tag:0x00007fa996165b10>

Hi

I use Formulas plugin. I want to replace calculation of some functions or add original functions.

in the formula-parser’s document, I can find feature ‘Custom functions/formulas’, but in the handsontable’s not.

I read #1987, but no answer found clearly.

Are there any way to customize formulas at the hansontable?

Hi @taknb2nch

Formulas has been an experimental feature in Handsontable and it will be replaced by a home-made calculating engine in this quarter. We are in the phase of tests but I can let you know as soon as it gets online. Then we can test the custom formulas together.

Hi @aleksandra_budnik

I hope we can replace or customize original calculation logic.

I look forward to the next version!

thank you.

Hi @taknb2nch

I highly recommend checking out our new formula project called Hyper Formula - https://github.com/handsontable/hyperformula
It was released yesterday.

Hi @aleksandra_budnik

Congratulations on the release of Hyper Formula!

I checked a little. after checking more, I will ask you some questions.

Hi @aleksandra_budnik

I tried custom functions of Hyper Formula in simple typescript project.
Its behavior was good, I could define my custom function or replace built-in functions.

How do I replace formula-parser with Hyper Formula in Handsontable?
can I do it?

Or, should I take any other different approach?

Its behavior was good, I could define my custom function or replace built-in functions.

I’m very glad to hear that :slight_smile: it has been our first release so a couple of things are missing but we will add them as soon as possible.

How do I replace formula-parser with Hyper Formula in Handsontable?

Our developer is working on a plugin that replaces the formulas. Here’s a list of tasks we need to accomplish to merge the new logic into Handsontable https://github.com/handsontable/handsontable/issues?q=is%3Aopen+is%3Aissue+label%3AFormulas+HyperFormula along with the epic https://github.com/handsontable/handsontable/issues/6466

It will take a while to release as Plugin in Handsontable.

Until released it, I’ll think of other ways.

Thank you for your very kind and courteous response.