Maximum number of columns

Posted by: vsanjay1982 on 8 September 2017, 1:47 pm EST

  • Posted 8 September 2017, 1:47 pm EST

    Hi,


    What are the recomended maximum number of columns.


    If i have 200 Columns will i end up in performance issues w.r.to rendering of the grid on page?

  • Replied 8 September 2017, 1:47 pm EST

    It would depend more on how many cell spans, extra formatting, etc... that you do.  That many columns is not a lot in Spread for Windows Forms.  If you try to make the form wide enough to show them all at once, that could be a bit slower.
  • Replied 8 September 2017, 1:47 pm EST

    Performance is affected more by the layout and painting code than by the size of the spreadsheet.  If the layout for the control is very complicated (i.e. lots of split panes, cell spans, cell overflow, merged cells, lots of columns and/or rows visible due to small widths/heights or zoom factor) then it will take longer to compute the layout and paint the spreadsheet.  You could make a spreadsheet with millions of columns and rows, filled with lots of data, and it would paint very fast if the viewport is small (though it might take a while to fill it with all those columns and rows of data, depending on how you do it -- SheetView.SetArray would be very fast).
Need extra support?

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

Learn More

Forum Channels