This sample lets you test-drive various features of Essential Grid. The menu Items of the grid pad are used to customize the grid settings, and control the user interface aspects of the grid.
Given below is a sample image.
Print - The Print dialog box can be opened by opening the File menu and clicking Print.
Print Preview - Open the File menu and click PrintPreview to generate a preview of the grid to be printed.
Printer Setup - On the File menu, click PrinterSetup to open the PageSetUp dialog box. This provides options to set the PageSize, PageSource, PageMargins and Orientation.
New - On the File menu, click NewGrid and select the frames needed to work with.
Save - A new document can be saved by clicking Save item in File menu.
Save As - An already saved document can be saved with a new name or new location by clicking SaveAs in the File menu. It supports Binary and SOAP formats.
Open - A saved document can be opened by clicking Open in the File menu.
Clipboard - Select cells and Copy by pressing CTRL+C keys, CTRL+INSERT keys or open the Edit menu and click Copy.
Select cells and Cut by pressing CTRL+X keys, SHIFT+DELETE keys or Open the Edit menu and click Cut.
Move the current cell and Paste by pressing the CTRL+V keys, SHIFT+INSERT keys or Open the Edit menu and click Paste.
You can copy or paste inside the grid or from another OLE Drag-and-Drop enabled application that understands the text format. Add support for your own custom data sources.
OLE Drag and Drop - Select the cells and drag inside the grid, or to or from other OLE Drag-and-Drop enabled applications.
A focus rectangle will mark the cells that have been pasted into the grid. Press the CTRL key to force a copy of the cells; otherwise, the cells will be moved. The grid will scroll when you move the mouse cursor to the edge of the scrollable area.
Property Grid - Select the cells, open the Format menu and click Cells.
It allows the formatting of multiple cells at once and gives feedback about equal options, and clears the options that differ among cells. Base styles can also be changed with the property grid by opening the Format menu and clicking StylesMap.
In the Drop-Down list mode, you cannot change the text in a cell. Pressing a character will select an item in the list.
In Edit mode, you can edit text in the cells. The text will be auto-filled with entries in the choice list, if they fit. When the list box is dropped down, the focus will remain on the text part of the cell.
The generic drop-down serves as a base for custom drop-down cell types, and makes it very easy to add any kind of drop-down.
The following drop-downs are implemented in this demo.
The drop-down grid opens a new view of the same grid. Any changes will be reflected in the parent grid. You can open the drop-down grid recursively when you click the drop-down button in the dropped down grid.
This displays a message box if the text entered into the current cell does not meet the validation criteria for a cell. When you are inside a splitter control, you cannot activate another pane before the current cell’s contents are successfully validated.
Cell formatting is implemented through a unique styles architecture that lets you to inherit attributes from parent styles easily. Any information that is not initialized specifically for a cell will be inherited from the standard style or any other style that is higher in the hierarchy. This will allow you to apply formatting to the whole table, rows, columns, group of cells, or individual cells.
Select the cells and change the alignment and font by using the Toolbar or Cells dialog box, which is opened by clicking Cells on the Format menu.
GridBaseStyleCollectionEditor - This is opened by clicking BaseStyles on the Format menu. It provides the following options to customize the base style.
Interior - This property can be set to None, Pattern, Gradient or Solid
Font - Sets the font for the text.
Orientation - Sets the orientation for the text.
HorizontalAlignment - The horizontal alignment for text can be set to Left, Right or Center.
VerticalAlignment - The vertical alignment for text can be set to Top, Bottom, or Middle.
Text Color - Sets the color for the text.
Borders - Specifies the border settings for cells.
WrapText - Wraps data to fit the column width.
AutoSize - Cells are autosized to fit text.
AllowEnter - Allows to edit the headers.
ReadOnly - Makes text uneditable.
CellType - Specifies the cell type.
CellValueType - Specifies type of cell value.
Format - Formats the value like date, numeric, or currency text.
Description - Specify text for push buttons and check boxes.
TriState - This property is used with check boxes.
FloatCell - This property allows the cell text to float into neighbouring cells.
FloodCell - This property allows the cell to be flooded by the previous cell.
ChoiceList for combo boxes.
You can add custom attributes to any cell.
The property grid will display the cell settings that are applied to a cell in bold; settings that are inherited from the base style will be displayed in regular font.
The splitter control allows dynamic splitting of the grid. This can be achieved by opening the File menu, clicking New Grid, and then clicking Inside Splitter Frame.
The workbook interface provides an Excel-like Tab Bar control. You can select pages that are in the Tab Bar, and change the order of the pages by dragging them with the mouse.
Worksheets also support dynamic splitting. This can be achieved by opening the File menu, clicking New Grid, and then clicing Inside Workbook Frame.
The Record Navigation control provides Access-like scrolling through the records. The user can scroll by pressing the arrow buttons or by manually entering the record number. To do this, open the File menu, click New Grid, and then click Inside Record Frame.
On Window menu, click New Window to open another view on the same grid data. When you have a workbook open, this will open another view on the workbook.
Arrow keys are used to move the current cell.
PAGEUP and PAGEDOWN keys are used to scroll the visible region up and down.
F2 is used to activate/deactivate a cell.
F4 and ALT+DOWN ARROW is used to show/close dropdown in a cell.
CTRL+ARROW keys is used to move to the first/last row/column.
SHIFT+ARROW keys is used to select cells.
DELETE key is used to delete cells.
CTRL+X, CTRL+V, CTRL+C, SHIFT+INSERT and SHIFT+DEL are used to perform clipboard operations.