Example of Cell Formatting in ASP.NET MVC Spreadsheet Control

Spreadsheet
Formatting
Cell Formatting

This sample demonstrates the Spreadsheet cell formatting feature by applying different styles to a range of cells.

ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASAT
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
OrderIDCustomerNameOrderDateAddressCityPostalCodeCountryStatusFreight
10248Paul Henriot7/4/199659 rue de l AbbayeReims51100FranceDelivered$32.38
10249Karin Josephs7/5/1996Luisenstr. 48Münster44087GermanyDelivered$11.61
10250Mario Pontes7/8/1996Rua do Paço, 67Rio de Janeiro5454876BrazilShipped$65.83
10251Mary Saveley7/4/19962, rue du CommerceLyon69004FranceDelivered$41.34
10252Pascale Cartrain7/8/1996Boulevard Tirou, 255Charleroi6000BelgiumShipped$51.30
10253Carlos Hernández7/1/1996Rua do Paço, 67Rio de Janeiro5454876BrazilCancelled$58.17
10254Yang Wang7/18/1996Hauptstr. 31Bern3012SwitzerlandPending$22.98
10255Antonio Moreno7/7/1996Starenweg 5Genève1204SwitzerlandDelivered$148.33
10256Paula Parente7/10/1996Rua do Mercado, 12Resende8737363BrazilShipped$13.97
10257Michael Holz7/9/1996Carrera 22 con Ave. Carlos SoubletteSan Cristóbal5022VenezuelaDelivered$81.91
10258Roland Mendel7/3/1996Kirchgasse 6Graz8010AustriaCancelled$140.51
10259Francisco Chang7/22/1996Sierras de Granada 9993México D.F.5022MexicoPending$3.25
10260Henriette Pfalzheim7/12/1996Mehrheimerstr. 369Köln50739GermanyDelivered$55.09
10261Bernardo Batista7/15/1996Rua da Panificadora, 12Rio de Janeiro2389673BrazilShipped$3.05
10262Paula Wilson7/8/19962817 Milton Dr.Albuquerque87110USADelivered$48.29

Cell formatting allows you to highlight cell data that appears in the Spreadsheet. It can be enabled or disabled using the allowCellFormattingopens in a new tab property.

In this sample, gridlines are hidden using the showGridLines property and the styles are applied using the styleopens in a new tab property and cellFormatopens in a new tab method.

More information about cell formatting can be found in this documentation opens in a new tab section.

Transform your ASP.NET MVC web apps today with Syncfusion® ASP.NET MVC components
85+ high-performance and responsive UI components
Dedicated support
Hassle-free licensing
TRY IT FOR FREE
opens in a new tab