GrapeCity Spread Silverlight CTP, Part 13 – Edit Mode and Frozen Columns and Rows

Spread CTP - Script 13: Edit Mode and Frozen Columns and Rows

If you are interested in downloading the Spread CTP, please email labs@grapecity.com .

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

Part 1 : Create an app from scratchPart 2 : AutoFitPart 3 : Borders and Grid LinesPart 4 : Cell FormatPart 5 : Cell OverflowPart 6 : Cell SpanPart 7 : Clipboard OperationPart 8 : Conditional FormattingPart 9 : CSV Import and ExportPart 10: Data Binding
Part 11: Drag and Move
Part 12: Drag and Fill

Edit Mode AlwaysIf you are interested in downloading the Spread CTP 2 with a go live license, please email labs@grapecity.com .

You can set the cell to always be in edit mode when the user clicks on it. Normally the user types or double-clicks before the cell goes into edit mode.

Set the StartCellEditing method in the EnterCell event to cause the cell to go into edit mode as soon as the user clicks on or uses tab or enter to move to the cell.

Frozen Columns and Rows Feature

You can specify whether you want frozen rows or columns or both in a sheet. Frozen columns and rows do not scroll. You can also specify whether to have frozen trailing rows or columns. A line is displayed below frozen rows (or above frozen trailing rows) and to the right of frozen columns (or to the left of frozen trailing columns).

Frozen rows stay at the top of the sheet and frozen columns stay on the left of the sheet. Frozen trailing rows stay at the bottom of the sheet and frozen trailing columns stay on the right of the sheet.

Using Code

CS

gcSpreadSheet1.Sheets[0].RowCount = 10;
gcSpreadSheet1.Sheets[0].ColumnCount = 8;
gcSpreadSheet1.Sheets[0].FrozenColumnCount = 1;
gcSpreadSheet1.Sheets[0].FrozenRowCount = 1;
gcSpreadSheet1.Sheets[0].FrozenTrailingColumnCount = 1;
gcSpreadSheet1.Sheets[0].FrozenTrailingRowCount = 1;
gcSpreadSheet1.Invalidate();

VB.NET

Copy Code

GcSpreadSheet1.Sheets(0).RowCount = 10
GcSpreadSheet1.Sheets(0).ColumnCount = 8
GcSpreadSheet1.Sheets(0).FrozenColumnCount = 1
GcSpreadSheet1.Sheets(0).FrozenRowCount = 1
GcSpreadSheet1.Sheets(0).FrozenTrailingColumnCount = 1
GcSpreadSheet1.Sheets(0).FrozenTrailingRowCount = 1
GcSpreadSheet1.Invalidate()

Technorati Tags: 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

Part 14 – Row Filter

tweetmeme_url = 'http://www.clubfarpoint.com/Forums/blogs/russells\_blog/archive/2012/04/27/grapecity-spread-silverlight-ctp-part-13-edit-mode-and-frozen-columns-and-rows.aspx'; tweetmeme_source = '@russcamtv'; tweetmeme_hashtags = '#appdev';