taknb2nch
(Taknb2nch)
June 15, 2020, 2:38am
1
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.
taknb2nch
(Taknb2nch)
June 15, 2020, 10:52pm
3
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.
taknb2nch
(Taknb2nch)
June 30, 2020, 7:12am
5
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 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 GitHub · Where software is built along with the epic New formula plugin · Issue #6466 · handsontable/handsontable · GitHub
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.