I would like to suspend wincalc calculations and show values which are stored in the cells.
When I reload grid with suspended calculations all cells with formulas are blank.
is there a way to show cell value when calculation is suspended?
Hello Arthur,
I`m not sure that I understand well your scenario, but maybe one possible approach could be if you apply your Formula at a lates stage. For example: I have column (the column`s name is Formula 5 -please take a look at the attached video file) which display the values from my datasource. When I press the button, I set Formula to that column and call the methods:
- ultraCalcManager1.DirtyAllFormulas();
- ultraCalcManager1.ReCalc();
By this way I get the new values (diffrent from the values in dataSource). Please take a look at the attached video file and let me know if you think that I misunderstand your questions
Regards
My scenario as a bit different:
1 all formulas are created in designer and attached to certain columns.
2 user opens window, first I load values from datasource, then during calculations values that are changes are highlighted
3 user can now save or cancel changes
4 when cancelling I would like to suspend calculations and show previous values (stored in datasource)
5 On cell change, calculations are resumed and all changed values are displayed, goto point 3
So far I managed to suspend calculations when user pressed cancel and resume on cell change. During that time all calculated fields are empty, which is confusing.
I could dynamically create formulas and attach them on form load, detach on cancel and attach again on cell change....
Any idea on easier solution to show values from datasource when calculations are suspended?