Creating Filters

»Spread for ASP.NET » Product Tour » Filtering

jump to:

Filtering

You can customize the user experience for filtering data on a sheet. With row filtering, you can allow the user to filter the data in columns on a sheet and display only the rows of data which meet criteria from a drop-down list or change the appearance of rows based on that filtering. You can use the basic default filtering or you can customize practically every aspect of the filtering.

	ID	LastName	FirstName	Phone	Address	City	State	Zip	Contract
1	1723221176	White	Johnson	408 496-7223	10932 Bigge Rd.	Menlo Park	CA	94025	true
2	2135468915	Green	Marjorie	415 986-7020	309 63rd St. #411	Oakland	CA	94618	true
3	2389547766	Carson	Cheryl	415 548-7723	589 Darwin Ln.	Berkeley	CA	94705	true
4	2674172394	O'Leary	Michael	408 286-2428	22 Cleveland Av. #14	San Jose	CA	95128	true
5	2744809391	Straight	Dean	415 834-2919	5420 College Av.	Oakland	CA	94609	true
6	3418221782	Smith	Meander	913 843-0462	10 Mississippi Dr.	Lawrence	KS	66044	false
7	4092567008	Bennet	Abraham	415 658-9932	6223 Bateman St.	Berkeley	CA	94705	true
8	4271172319	Dull	Ann	415 836-7128	3410 Blonde St.	Palo Alto	CA	94301	true
9	4722762349	Gringlesby	Burt	707 938-6445	PO Box 792	Covelo	CA	95428	true
10	4862961786	Locksley	Charlene	415 585-4620	18 Broadway Av.	San Francisco	CA	94130	true