Last week's gridtalk was pretty boring if you are already an expert in Excel. If all you know is WatFile, then it was probably very enlightening.
So let's look at the grid functionality at the cellular level.
Data Entry
Sorry, these reporting grids do not support data entry. Lookie no changie.
Text Truncation
Sometimes the text in a cell exceeds the width of a cell/column. Right-mouse click that cell and a popup message will give you the full text. This is useful in these long textual string situations:
- PlayerAwardsEntry (award commentary is verbose and probably full of crap)
- RosterMovementReport (many players are involved in a movement or the customized reason for a roster movement is an epic)
- AuditChallengesReport (default column width hides part of a character string like a date)
Dates and numeric columns are rarely truncated. But if they were, this approach will work for them also.
Another way to make a column wider --- just like Microsoft Excel, use your left mouse button to grab the right edge of a header cell and drag/drop it to the right.
Toolbars Buttons That Navigate To A Report
Many toolbar buttons need some key data from a grid. For example, a player name or a game number. Prior to clicking the toolbar button, you only have to highlight the row ... not the cell. The software is smart enough to find the cell that it needs - you don't need to point it out.
Toolbar Buttons That Act On A Grid As A Whole
Click the PRINT toolbar button and the entire grid will be export to CSV. And as a bonus, Microsoft Excel is launched to display it right away. The formatting sucks but that's CSV for ya.
Click the FIND toolbar button and the subsequent locater window will help you customize a search. Give it a try, particularly on a grid with many rows.
Click the FILTER toolbar button (aka Reporting Control) to filter the selected rows in the grid.
