Difference between revisions of "Calc/Features/DataPilot custom display names"
(→Field member names: added restrictions.) |
(→Subtotals: added initial description.) |
||
| Line 70: | Line 70: | ||
=== Subtotals === | === Subtotals === | ||
| + | You can assign a display name to subtotals ''only when'' the table has one data field, and the subtotal type is ''Automatic''. When assigning a display name to the subtotal of a field, Calc parses the name being input in order to detect the corresponding field member name associated with that particular subtotal output, and substitute it for the respective field member names of all subtotal outputs of the field. | ||
=== Grand totals === | === Grand totals === | ||
Revision as of 21:40, 31 August 2009
Contents
DataPilot custom display names
| Specification Status | |
| Author | Kohei Yoshida |
| Last Change | See wiki history |
| Status | In progress in CWS koheidatapilot03 |
Abstract
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.
References
| Reference Document | Check | Location (URL) |
| Issue ID (required) | available | Issue 22029 Issue 81335 |
| 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
Overview
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.
Subtotals
You can assign a display name to subtotals only when the table has one data field, and the subtotal type is Automatic. When assigning a display name to the subtotal of a field, Calc parses the name being input in order to detect the corresponding field member name associated with that particular subtotal output, and substitute it for the respective field member names of all subtotal outputs of the field.
Grand totals
Migration
N/A
Configuration
N/A
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.
