Posted 8 September 2017, 1:58 pm EST
I am loading a datagrid with lots of columns ,rows and formulas
I load it cell by cell and after that I set the formulas for the columns
This takes a lot of time, I need to specify that I need to load it Cell by Cell
because I do not want to loose configurations and structure of the grid.
My question is if there is any different way to render the formula after the grid is loaded(today I have the feeling that every time we enter something into the cell it calculates the formula again)
and not in runtime, but when the user writes something in the cell I do want that these formulas will be calculated.
Or is there any other way to prevent the long grid load time