About Formula Support

Tags: #<Tag:0x00007fa98d92d338>

Hello,

For Handsontable Formula Support, I see the documentation page says
()
https://handsontable.com/docs/7.3.0/demo-formula-support.html
‘‘This plugin is marked as ALPHA version and its API is not stable yet’’
What does this mean?
Our product will be heavily use the formula support for many ‘Dynamic calculated fields’
Are we able to do it?

Thx

Hey Marius,

we are working on a new formula engine that will replace the one that we have now.

The plugin has been marked as experimental as it does not cooperate well with other plugins. Here https://github.com/handsontable/handsontable/issues?q=is%3Aopen+is%3Aissue+label%3AFormulas is a list of issues for formulas. As you can see there are some issues if we pair it with

  • merge cells
  • column sorting
  • moving
  • nested rows

But there are also a couple of issue that relate to its core functionality

  • it does not update for some cells
  • it does not show a result for some cells

That is why we do not recommend to use them on the production.

Hello

Thanks for your answer.
We do plan to release it on Production but with a more stable version of it.
As you metioned that you are working on a new formula engine, do you have a timeline for the new engine about when the new engine will be released and stable?

Best,
Terry

We’re planning to make the new engine public in Q1, 2020. But there’s no precise date yet.

Hello,
Do you know when you will be able to provide a date?
Thank you,
Sue

After we release another beta for 8.0.0 we should get more time for the formula engine and then I should be able to provide more information. Another 8.0.0 if not in January will be published at the beginning of February. There are still some issues that have to be covered but I stay optymistic.

Hi Aleksandra,

Please confirm if Formula Support is included in the scope of the 8.0.0 release.
If not, please confirm that you will address this issues with Formula Support after the release of version 8.0.0 (which is targeted for release at the beginning of February).

Please provide the list of enhancements and/or bug fixes expected to be included in the 8.0.0. release.

Another question related to Formula support:
We are using functionality called “discard updates” that allows the user to cancel changes and restore the data back in the HOT. In the implementation, we set the data attribute of HOT to the old data object causing a table data reload to accomplish a “discard updates” behavior. The discard of data works as expected but the recalculation of the formula cell does not work. Is this a known bug?

Thank you,
Terry

Hey Terry,

Please confirm if Formula Support is included in the scope of the 8.0.0 release.

The formula Support new engine is a completely new project. It is already in progress but after 8.0.0 will have more time and human-resources to speed the process up. Firstly, the engine would be a self-working project, then it will be added as a plugin to Handsontable.

Please provide the list of enhancements and/or bug fixes expected to be included in the 8.0.0. release.

Some of them are epics so they might be closed or not, but surely will relate to fixed issue list

The discard of data works as expected but the recalculation of the formula cell does not work. Is this a known bug?

There’s one issues reported on the formulas not recalculating for some cells or some operations.
Can you share more information about the changes? Do you get back to the source you’ve loaded at the begining or only discard one change? An example would be helpful, maybe there is another way to accomplish the same goal.

Thank you for your response.
Regarding the Formula Support project, typically how long does it take before the self-working project is added as a plugin?

Regarding the discard of channges, it could be one change or multiple changes as the user has the ability to discard all updates made to data in the table. For example, within the HOT table, the user can update multiple cell in one or more rows. After update, the user must select Save to save the updates. On click of Save, the user is prompted to Continue (to save all updates to the database) or is able to Cancel (to save updates to the database). On Cancel, the the table is refreshes with incorrect numbers (totals) in the cells with formulas.

There is no typically yet :slight_smile: That is the first time we create such a complex side project that is planned to get merged to Handsontable.

Regarding the discard of changes, it could be one change or multiple changes

Please share some examples. We’ll be able to build a logic based on them and then analyze if there’s anything more to add.

I guess that we can close the topic as there are no updates but feel free @marius.editoiu to open a new one when needed.