Overview

This sample shows grouping columns.


 IDCompany NameNameTitleAddressCityRegionPostalCodeCountryPhoneFax
1ALFKIAlfreds FutterkisteMaria AndersSales RepresentativeObere Str. 57Berlin 12209Germany030-0074321030-0076545
2ANATRAna Trujillo Emparedados y heladosAna TrujilloOwnerAvda. de la Constitución 2222México D.F. 05021Mexico(5) 555-4729(5) 555-3745
3ANTONAntonio Moreno TaqueríaAntonio MorenoOwnerMataderos 2312México D.F. 05023Mexico(5) 555-3932 
4AROUTAround the HornThomas HardySales Representative120 Hanover Sq.London WA1 1DPUK(171) 555-7788(171) 555-6750
5BERGSBerglunds snabbköpChristina BerglundOrder AdministratorBerguvsvägen 8Luleå S-958 22Sweden0921-12 34 650921-12 34 67
6BLAUSBlauer See DelikatessenHanna MoosSales RepresentativeForsterstr. 57Mannheim 68306Germany0621-084600621-08924
7BLONPBlondel père et filsFrédérique CiteauxMarketing Manager24, place KléberStrasbourg 67000France88.60.15.3188.60.15.32
8BOLIDBólido Comidas preparadasMartín SommerOwnerC/ Araquil, 67Madrid 28023Spain(91) 555 22 82(91) 555 91 99
9BONAPBon app'Laurence LebihanOwner12, rue des BouchersMarseille 13008France91.24.45.4091.24.45.41
10BOTTMBottom-Dollar MarketsElizabeth LincolnAccounting Manager23 Tsawassen Blvd.TsawassenBCT2F 8M4Canada(604) 555-4729(604) 555-3745
   

You can set the display of the spreadsheet component to allow rows to be grouped according to the column headers. You can customize the user experience for grouping data on a sheet. With grouping, you can allow the user to group rows of data according to the column headers that are dragged into the group bar. Special group headings are displayed above the grouped rows.

Documentation