Difference between revisions of "Template:Grid"
Wirecadadmin (Talk | contribs) |
Wirecadadmin (Talk | contribs) (→Grid Basics) |
||
| (11 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
==Grid Basics== | ==Grid Basics== | ||
| − | Every grid in WireCAD has the same basic functionality. | + | Every grid in WireCAD has the same basic functionality. Some functionality is disabled in some grids.<br> |
| − | + | * Not all grids display the filter pane. | |
| − | + | * Not all grids display the Add New pane. | |
| − | + | * Not all grids display the Group panel. | |
| − | + | * Not all grids display the Ripple List. | |
| − | + | ||
| − | + | ||
| − | == | + | ==Exporting Data== |
| + | Any grid can export data to the following formats: | ||
| + | * Excel | ||
| + | * XML | ||
| + | * HTML | ||
| + | * Text | ||
| − | + | Data is exported with the current column display order, grouping and sorting applied. | |
| − | == | + | ==Definitions== |
| + | [[File:GridEx2.png|thumb|500px|Overview]] | ||
| + | '''Column Header:''' The caption at the top of the grid column.<br> | ||
| + | '''Row:''' Grid row.<br> | ||
| + | '''Active Row:''' The current row that may or may not be editing.<br> | ||
| + | '''Active Cell:''' The current cell that is involved in an edit. It has focus.<br> | ||
| + | '''Selection:''' Highlighted array of cells upon which an action may be performed.<br> | ||
| − | |||
| − | ===Filtering Data== | + | |
| + | ==Sorting== | ||
| + | [[File:GridExSort.png|thumb|500px|Sorting]] | ||
| + | Clicking any column header will sort by that column. Clicking it again will change the sort direction. | ||
| + | |||
| + | |||
| + | |||
| + | ==Grouping== | ||
| + | [[File:GridExGrouped.png|thumb|500px|Grouping]] | ||
| + | Dragging any column header and dropping it onto the Group Panel groups the grid by that column. | ||
| + | |||
| + | |||
| + | |||
| + | ==Reordering Columns== | ||
| + | [[File:GridReorder.png|thumb|500px|Reorder Columns]] | ||
| + | Dragging any column header and dropping in on another column header moves that column. | ||
| + | |||
| + | |||
| + | |||
| + | ==Display/Hide Columns== | ||
| + | [[File:GridExColChooser.png|thumb|500px|Choose Columns]] | ||
| + | # Right-click any column header. | ||
| + | # Select [Choose Columns]. | ||
| + | # Drag existing column headers to the dialog to hide them. | ||
| + | # Drag columns from the dialog to the grid to show them. | ||
| + | |||
| + | |||
| + | |||
| + | |||
| + | |||
| + | |||
| + | |||
| + | |||
| + | |||
| + | |||
| + | |||
| + | |||
| + | ==Filtering Data== | ||
| + | [[File:GridExFilter1.png|frame|Using the Filter Pane (if visible)]] | ||
| + | [[File:GridExFilter3.png|frame|Filter on existing item]] | ||
| + | [[File:GridExFilter2.png|frame|Filter Editor]] | ||
Latest revision as of 12:07, 21 January 2011
Contents
Grid Basics
Every grid in WireCAD has the same basic functionality. Some functionality is disabled in some grids.
- Not all grids display the filter pane.
- Not all grids display the Add New pane.
- Not all grids display the Group panel.
- Not all grids display the Ripple List.
Exporting Data
Any grid can export data to the following formats:
- Excel
- XML
- HTML
- Text
Data is exported with the current column display order, grouping and sorting applied.
Definitions
Column Header: The caption at the top of the grid column.
Row: Grid row.
Active Row: The current row that may or may not be editing.
Active Cell: The current cell that is involved in an edit. It has focus.
Selection: Highlighted array of cells upon which an action may be performed.
Sorting
Clicking any column header will sort by that column. Clicking it again will change the sort direction.
Grouping
Dragging any column header and dropping it onto the Group Panel groups the grid by that column.
Reordering Columns
Dragging any column header and dropping in on another column header moves that column.
Display/Hide Columns
- Right-click any column header.
- Select [Choose Columns].
- Drag existing column headers to the dialog to hide them.
- Drag columns from the dialog to the grid to show them.
Filtering Data
