Revision as of 17:05, 31 August 2009

DataPilot enhanced field popup window

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

Contacts

Detailed Specification

Field popup window

Screenshot of new 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.

Visual clue for fields with hidden members

Field button with all members visible (left), and one with one or more hidden members (right)

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

The appearance of autofilter button will change to match the launch button of the datapilot popup. The new autofilter buttons will look 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.

Page field button

Similar to the change with the autofilter buttons, the appearance of the datapilot page field buttons will also change to make them look consistent with the datapilot popup launch buttons and the new autofilter buttons. Unlike the autofilter buttons, the page field buttons will not visually indicate a filter-active state; however, this may change in future implementations.

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.

Open Issues

Data validity list box button

As of this change, the data validity arrow buttons still have the old look. Perhaps this button should also be updated to be consistent with the rest of the arrow buttons. There is also Issue 104372 which should probably be looked at when the update takes place.