Example of Number Formatting in ASP.NET MVC Spreadsheet Control

This sample demonstrates number formatting feature with a restaurant invoice.

DEMO

SOURCE

In this demo, number formatting is applied to specific cells by using the format property, and a range of cells by using the numberFormat method.

In the Amount column, we have used Custom number formatting to highlight the values less than 350 and greater than 350 with red and blue colors respectively.

More information about number formatting can be found in this documentation section.