Rank 1
Hello. i m wishing to use in future telerik ui for asp.net core for my projects.
I use Telerik.UI.for.AspNet.Core and Telerik.Web.Spreadsheet packages for VS 2022.
Right now i'm testing in demo version realization of formulas. I made my formulas, it works good, makes the result that i want
But looks like it recalculates formula in ANY change on the sheet. .
Its a big optimization problem cause i need a big sheet with thousands cells with this formula
Any way to avoid it?
I need to recalculate formulas only if depended cells were changed just like base formulas works, but i don't see in documentation any way to make it
Looks like whole telerik formulas works like that. any change makes rerender of sheet and recalculation of any formulas
1 Answer, 1 is accepted
Hi Mansur,
Thank you for reaching out.
At this stage, I am afraid the Telerik UI for ASP.NET Core Spreadsheet does not provide the means to force stop formula recalculation upon change. I noticed that such a feature has not been requested thus far. As a consequence, I have created the following feedback item:
Unfortunately, I cannot think of any workaround that would allow you to achieve the desired.
For further bringing this to our attention, I have also updated your Telerik points as a token of appreciation.
Kind Regards,
Alexander
Progress Telerik
Do you have a stake in the designеr-developer collaboration process? If so, take our survey to share your perspective and become part of this global research. You’ll be among the first to know once the results are out.
-> Start The State of Designer-Developer Collaboration Survey 2024
Hi Mansur,
This thread was brought to the attention of my manage who is head of the MVC&Core components department. While there is no mechanism to force stop formula recalculation, the reported behavior sounds rather unorthodox.
In this regard, in order to further perform further investigations, would it be possible for you to try and provide some more evidence behind the following statement:
"But looks like it recalculates formula in ANY change on the sheet."
For example, sharing the Spreadsheet's configuration alongside a screen capture would be of great help to the case.
I look forward to hearing back from you.