Load farpoint grid

Posted by: michal-fp on 8 September 2017, 1:58 pm EST

  • 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







  • Replied 8 September 2017, 1:58 pm EST


    In order to improve the performance of the Spread while keeping the formulas on,  then you can set AutoUpdateNotes to false to
    prevent the component from checking for sticky notes that need to be made
    visible or hidden or moved, If you are not using sticky notes. If you are using AllowCellOverflow, turning that off increases the performance of the layout calculations, because that feature requires lots of text width calculations on each change to the data in a cell. If you are using formulas, setting AutoCalculation to false before your updates and then setting it back to true and calling Recalculate afterwards eliminates redundant intermediate recalculations of your formulas.Some other things you could do would be to reduce the size of the control or show fewer columns and rows at once.

    In addition to the above you may also refer to the "Improving Performance by Suspending the Layout"  in the Spread documentation to further optimize the Spread performance.Thanks

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels