Performance Tips

The RadSpreadsheet control is optimized to bring a great performance, but this can be improved even further by keeping in mind the following tips and tricks.

• The RadSpreadsheet control uses the document model of RadSpreadProcesing. Check the Performance Tips and Tricks article of the library to see how to optimize the document model.

• Use the NoXaml Telerik dlls. This will improve the initial loading performance.

• The usability of the control can be improved also by preloading the view that will display the RadSpreadsheet. This won't boost the general performance, but will move the WPF resources loading behavior before the view is displayed, thus improving the later interactions with the application. To preload the control, you should add it (but hidden) to the visual tree of the application at some point around startup. The exact place will depend on the specific application setup. The following KB article shows one way to do this.

• If using RadSpreadsheetRibbon, remove the tabs or other elements that are not necessary in the application. To do this, you can use the ChildrenOfType extension method, or you can modify the ControlTemplate of RadSpreadsheetRibbon.

  Using the ChildrenOfType method to remove the first tab from the ribbon control

      this.spreadsheetRibbon.ChildrenOfType<RadRibbonView>().FirstOrDefault().Items.RemoveAt(0);   
  

• If using RadSpreadsheetRibbon, set its IsMinimized property to true.

  Minimizing the ribbon control

      <telerik:RadSpreadsheetRibbon IsMinimized="True" /> 
  

• Use .NET 8 or later, instead of .NET Framework, because the general WPF performance there is improved.

See Also

• UI Virtualization