Printer friendly version 
 Square Dance Resource Net  (Home)ArticlesCallers and CuersClubsEventsResourcesChoreographyMusicLyricsCeder Chest Definition BooksCeder Square Dance System  (CSDS)Square Rotation Program  (SQROT)Vic Ceder - Square Dance CallerDefinitions of square dance calls and conceptsMore square dance DefinitionsLists of square dance calls and conceptsFrequently Asked QuestionsSquare dance linksLos Olivos Honey BeesBande DéssineesChocolate BarsBeanie BabiesPokémon Trading CardsSend us feedback
Square Rotation Program (SQROT)
 
Square Rotation Program (SQROT)
 
 SQROT Home  |  Online Purchase  |  Revision History  |  Help  |  FAQ  |  Documentation     
 Download -->  Rotation Card Sets  |  Program Upgrade 
 Sample screens -->  Main  |  Web App  |  Rotation  |  Tip Display  |  Preferences - Global  |  Preferences - this Rotation 
 Rotations (active online)  |  rotation administrator 
 CSDS2 and SQROT downloadable files 

All Programs
 
Send feedback about this page
 

Customize Grid

The Customize Grid dialog box is used in many places within the program. Almost every grid can be customized. Setttings to a particular gird are generally saved between invocations of the grid.

Span Available Width
When checked, all fields (i.e., columns) are shown within the width of the grid. If the grid width is too small, fields are compressed and may not be easily visible. If the grid width is too large, fields are padded with blank space.

Word Wrap
When checked, text data may be wrapped onto following lines within the grid row. This increases the height of the affected grid rows.

Best Fit - All Columns
Invokes the grid's autofit function to best fit the data within the grid.

Modify Columns
Invokes the Grid Column Editor to modify which fields are visible, their position within the grid, and their width.

Default All
Sets all fields to their default visibility, width, and position within the grid.

Show All
Makes all columns visible, even those that may be hidden and of internal use to the program.

Filter Editor
Allows a custom filter to be applied to the data in the grid. This is rarely used, and only necesary for large datasets in which a customized filter is desired.

Font Size
Specifies the fontsize for the text in the grid

Export...
Allows the grid to be exported in HTML, PDF, RTF, TXT, XLS, or XLSX format.

Clear Filters
Clears all filters currently applied to the grid. All grid rows will be shown.

Expand All
If the grid is grouped by one or more columns, all rows in all groups will be shown.

Collapse All
If the grid is grouped by one or more columns, all rows in all groups will be hidden. This allows viewing of the group structure of the data. Any specific group may be expanded by pressing the corresponding '+' button.

Clear
If the grid is grouped, all grouping is undone, and the grid returns to it's normal state.

Find
When checked, the Find Panel is shown above the grid. The Find Panel allows filtering to only show grid rows that contain the entered text.

If the text contains a space, and you want that specific text string to be found, place double quotes around the text. Otherwise the search results will be all rows that contain any of the text words.

Group By
When checked, the Group By Panel is shown above the grid. The Group By Panel initally has text that says 'Drag a column header here to group by that column'. One or more column headers may be dragged into the Group By Panel to group the grid to group by those columns. A column header may be dragged back on the grid header row to remove that column from grouping.

Column Filters
When checked, a green Column Filters row appears immedidately below the column headers. Text can be entered in any of the columns of the Column Filters row. This filters the grid to only display rows where that column contains the entered text.

Navigate
When checked, a row appears at the bottom of the grid, that shows the number of rows in the grid, and the index of the selected row. Also shown are small buttons that change the selected row to be the first, previous page, previous row, next row, previous page, or last row in the grid.

Displays Customize Grid - Find Panel - Help

Header Font Size
Changes the font size of the header row.

Group Row Font Size
Changes the font size of the group rows.

Close
Closes this dialog box.

last modified: 04-January-2022   Unique ID: 289

https://www.ceder.net/helpdb/viewsingle.php?who=sqrot&UniqueId=289
01-July-2022 22:46:47
Copyright © 2022 Vic Ceder.  All Rights Reserved.