Example of Cell Formatting in ASP.NET Core Spreadsheet Control
This sample demonstrates the Spreadsheet cell formatting feature by applying different styles to a range of cells.
Cell formatting allows you to highlight cell data that appears in the Spreadsheet. It can be enabled or disabled using the allowCellFormatting property.
In this sample, gridlines are hidden using the showGridLines property and the styles are applied using the style property and cellFormat method.
Additionally, rich text formatting like subscript and superscript are applied to emphasize parts of the data, improving readability and presentation.
To improve performance, suspendRefresh method is invoked before applying formatting, which temporarily pauses UI rendering while updates are made. After all formatting is completed, resumeRefresh method is invoked to render all changes at once, ensuring smoother performance.
More information about cell formatting can be found in this documentation section.