Calc/Features/DataPilot custom display names

From Apache OpenOffice Wiki
< Calc‎ | Features
Jump to: navigation, search

DataPilot custom display names

Specification Status
Author Kohei Yoshida
Last Change See wiki history
Status In progress in CWS koheidatapilot03  


This feature enables the users to assign custom display names to fields, field members, subtotals (with some restrictions), and grand totals inside DataPilot tables. A custom display name is assigned to an item when the user types the alternative name into their respective cell that shows the original name.


Reference Document Check Location (URL)
Issue ID (required) available Issue 22029 Issue 81335
Test case specification (required) n/a


Role Name E-Mail Address
Developer Kohei Yoshida
Quality Assurance Oliver Craemer
Documentation up for grabs
User Experience up for grabs

Detailed Specification


This feature allows users to assign display names to fields, field members, subtotals, and grand totals in DataPilot tables. By assigning a display name, you can alter the output of the table without changing its source data. Assignment is done by directly typing in a new name to the cell that contains the original name of an item whose name you wish to change.

Field names

When assigning a display name to a field name, the name must not be identical to any of the original field names nor any of the existing display names already assigned to fields.

Field member names

When assigning a display name to a field member name, the name must not be identical to any of the existing field members names nor to any of the display names already used for that particular field. Note that names used in other fields are allowed.


You can assign a display name to subtotals only when the table has one data field, and the subtotal type of the corresponding field is Automatic. When assigning a display name to the subtotal of a field, Calc parses the name in order to detect the field member name and substitute it for the respective field member names of all subtotal outputs of the field. This process is illustrated in the following sequence of pictures.

Original subtotal texts (left). Overwriting the text of one of the three subtotal texts (center). The final result after the new text is entered (right).

First, you have the three original subtotal outputs (left). Then you overwrite the text B Result with Total Score for B directly in the output cell (center). When you hit Enter to commit the text, the texts for all three subtotal outputs change but their respective field member names are preserved (right).

Grand totals

Although each DataPilot table may display up to two grand totals (column and row grand totals), each table can assign only one display name for both grand totals. When assigning a display name to one of the two grand total outputs, the second output automatically gets updated with the display name entered to the first one.

Documentation note.png The file format change being proposed to the ODF TC allows assignments of different display names to the column and row grand totals. So, in future implementations we may allow assigning different display names to the column and row grand total outputs.

Layout dialog

When fields and/or field members have display names assigned, the display names will be used in the datapilot layout dialog and all its child dialogs instead of their original names. The term layout dialog refers to the dialog launched from the menu Data - DataPilot - Start... while the cell cursor is over an existing datapilot table.





File Format

This feature requires a file format change. A change in the ODF specification is being proposed here. Please refer to that proposal for the details of the proposed file format change for this feature.

Open Issues

Personal tools