GrapeCity Spread Silverlight CTP, Part 14 – Row Filter

Spread CTP - Script 14: Row Filter

If you are interested in downloading the Spread CTP2 with a go live license, please email labs@grapecity.com .

This is the 14th in a series of Spread CTP Blogs and is a continuation of:

Part 1 : Create an app from scratch
Part 2 : AutoFit
Part 3 : Borders and Grid Lines
Part 4 : Cell Format
Part 5 : Cell Overflow
Part 6 : Cell Span
Part 7 : Clipboard Operation
Part 8 : Conditional Formatting
Part 9 : CSV Import and Export
Part 10: Data Binding
Part 11: Drag and Move
Part 12: Drag and Fill
Part 13: Edit Mode and Frozen Columns

You can hide filtered rows. A filter button is displayed in the column header for a column that allows filtering. The user can click on the button and select the item they wish to filter by and they can sort the list of items.

The following image displays the filter dialog.

The user can use the mouse or various keyboard keys to interact with the filter dialog. The ESC key can be used to cancel the dialog. The TAB key can be used to move to different sections and the up and down arrow keys can be used to move in the list of items. The SPACEBAR can be used to change the checked status.

The following image shows the list sorted in ascending order.

Using Code

CS

GrapeCity.Windows.SpreadSheet.Data.CellRange cellrange = new GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 2, 5, 1);
GrapeCity.Windows.SpreadSheet.Data.HideRowFilter hideRowFilter = new GrapeCity.Windows.SpreadSheet.Data.HideRowFilter(cellrange);
gcSpreadSheet1.Sheets[0].RowFilter = hideRowFilter;

VB.NET

Dim cellrange As New GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 2, 5, 1)
Dim hideRowFilter As New GrapeCity.Windows.SpreadSheet.Data.HideRowFilter(cellrange)
GcSpreadSheet1.Sheets(0).RowFilter = hideRowFilter
GcSpreadSheet1.Invalidate()

Spread, Excel, Silverlight, CTP, labs@grapecity.com , visual studio, AutoFit, borders and Grid lines, cell format, cell overflow, cell span, clipboard, clipboard operation, conditional formatting, CSV, CSV Import and Export, data binding, drag and move, drag and fill, edit mode, frozen columns and rows, row filter

tweetmeme_url = 'http://www.clubfarpoint.com/Forums/blogs/russells\_blog/archive/2012/04/26/grapecity-spread-silverlight-ctp-part-14-row-filter.aspx'; tweetmeme_source = '@russcamtv'; tweetmeme_hashtags = '#appdev';