Try double clicking in column C and E multiple times. It automatically changes value to some undesired values.
[GL #99] Not working appropriately with complex formulas
Thank you for sharing. I got a result where formulas are switched to a string and values have changed. It is definitely a bug
By when can I expect a fix for this ?
Formulas in an alpha plugin. We are not planning to release a stable version in this quarter (maybe in the last month). It all depends on the current tasks.
Hey we recently got a pro license and were testing the formula features and were running into the same issue, but for even simple formulas such as AVERAGE. This working correctly is very important for our usecase. Do you have an updated timeline on when this will be fixed and is this the right place for pro support?
Hi @Coursera
yes, currently the forum is the right place to share all issues related to PRO features.
The Formula Support plugin is still in an alpha stage and we do not recommend using it on the production. The update is planned for 2018, however, I do not know the exact date.
You can track update on our Trello for more precise information https://trello.com/b/PztR4hpj/handsontable-roadmap-2017-login-to-vote
ps. can you share a demo that shows the issue with the AVERAGE formula? Maybe I will find a way to find a workaround for it before we will be able to share a stable version.
Yeah here is an example fiddle
As you click on the bottom three cells, the top cell (with the formula) changes. Interestingly this only occurs with certain formulas, SUM for example works as expected.
Oh yes, that’s the issue that has been affecting the plugin from the beginning and has been reported in our Gitlab account some time ago.
It’ll surely be fixed in the next plugin stage, however, there is no precise date planned yet.
Cool I just put in a PR for a fix here so hopefully this can solve the problem for us and @hitesh.gupta
Thank you very much for sharing the pull request.