Calc/Features/DataPilot enhanced field popup window
Contents
DataPilot enhanced field popup window
Specification Status | |
Author | Kohei Yoshida |
Last Change | See wiki history |
Status | In progress in CWS koheidatapilot03 |
Abstract
This feature introduces a popup window for each field button inside DataPilot tables, to enable quick editing of field members visibility, and allow sorting of field members. Available sorting options are: 1) ascending, 2) descending, and 3) by custom sort order.
References
Reference Document | Check | Location (URL) |
Issue ID (required) | available | Issue 100619 |
Test case specification (required) | n/a |
Contacts
Role | Name | E-Mail Address |
Developer | Kohei Yoshida | kyoshida@novell.com |
Quality Assurance | Oliver Craemer | oliver.craemer@sun.com |
Documentation | up for grabs! | |
User Experience | up for grabs! |
Detailed Specification
Field popup window
Check list box for changing individual field members' visibility
This new field popup window allows the users to quickly edit visibility of field members. To activate the popup, you need to click on the arrow button on the right side of the field button. The popup window displays a list of field members associated with that field, and a check box is placed to the left of each field member name.
Toggling all field members' visibility at once
Immediately below the check list box are a tri-state check box labeled All for toggling all the field members' state at once. Clicking this check box on will turn on the states of all the field members, and vice versa.
Selecting or unselecting only a single field member
Two image buttons to the immediate right of the "toggle all" check box allow users to either
- only select the current field member while unselecting all the others by clicking the left image button, or
- select all field members except for the current field member by clicking the right image button.
Tool tips get displayed for these buttons. The texts for the tool tips are Show only the current item for the left button, and Hide only the current item for the right button, respectively.
Sorting of field members
Located in the top part of the window are menu items that allows you to sort the field members either in
- ascending order,
- descending order, or
- custom order via custom sort orders defined in the Options dialog.
To edit the custom sort lists, go to OpenOffice.org Calc - Sort Lists in the Options dialog.
As mentioned in the previous section, the popup arrow is located on the right side of the field button. The arrow is normally black, but when the field contains one or more hidden members, the arrow turns its color to blue, and displays a tiny square at its lower-right corner to provide visual hint to the users for the presence of hidden members.
Refer to the attached screenshot to the right to see how the button state changes with or without hidden field members. Be noted that the background color may be different depending on the current desktop theme.
Other changes
Autofilter button
Autofilter button has changed to match the launch button of the datapilot popup. The new autofilter buttons are as follows:
For fields (or columns) that are filter-active, the color of the triangle becomes blue, with a small square box at the lower-right corner. This is consistent with the way datapilot field buttons change their arrows depending upon whether or not they have hidden members.
Migration
There is no migration issues for this feature.
Configuration
N/A
File Format
No file format change is necessary since the popup window only exposes existing field attributes. Sorted field members are stored as manually ordered field members.