OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.


Help: OASIS Mailing Lists Help | MarkMail Help

office message

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]

Subject: [OASIS Issue Tracker] (OFFICE-3884) Custom display names in data pilot tables

    [ https://issues.oasis-open.org/browse/OFFICE-3884?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=68916#comment-68916 ] 

Regina Henschel commented on OFFICE-3884:

Problems with part 18.x.2 <table:data-pilot-subtotal> (new) of the proposal in the Wiki.
"default subtotal text" is not defined. It is not clear, what text is displayed, if the table:function value is not "auto" or in case it is "auto", but attribute table:display-name does not exist.

It is not specified, what to do with the value of the table:display-name attribute, in case the value of the table:function name is not "auto". From the schema I guess, that the table:display-name does not exist in such cases.

It is not clear, how the display name is build at all. The UIs of LibreOffice and Excel allow, that the display name can be concatenated from the member name and a, for all members same, user given string, or can be the same user given string for all members. If you do not know, that the member name is represented by a ?, e.g. table:display-name="Gesamte ? Verkäufe", the second paragraph makes no sense.

Problems with 18.x.1 General (new)  in the Wiki
The description binds table:display-name to the existence of table:name. But such does not exist neither for the new <table:data-pilot-subtotal> nor for the new <table:data-pilot-grand-total> elements.

Problem with 8.7.x table:data-pilot-grand-total (new)  in the Wiki
There exists no specification for the "default name". 

Problem with field top-right in a tabular form pivot-table
Excel allows to enter a user string there, LibreOffice does not allow this but generates a string. Excel allows to use that string in function GETPIVOTDATA instead of the data field name. The current specification says nothing about this field and the new proposal neither.

Problem with function GETPIVOTDATA
The definitions of "name" need to become more precise in 6.14.4 GETPIVOTDATA in part 2. With an additional "display-name" it is not clear, which one has to be used. Excel allows both, member and member-display-name, LibreOffice allows only the value of table:name attribute of the member.

> Custom display names in data pilot tables
> -----------------------------------------
>                 Key: OFFICE-3884
>                 URL: https://issues.oasis-open.org/browse/OFFICE-3884
>             Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
>          Issue Type: New Feature
>          Components: Part 1 (Schema), Table
>            Reporter: Andras Timar
>            Assignee: Andras Timar
>             Fix For: ODF 1.3
> Support for custom display names in data pilot tables.

This message was sent by Atlassian JIRA

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]