Uploaded image for project: 'OASIS Open Document Format for Office Applications (OpenDocument) TC'
  1. OASIS Open Document Format for Office Applications (OpenDocument) TC
  2. OFFICE-3670

Add cache-index for DataPilot Field members

    XMLWordPrintable

    Details

    • Type: New Feature
    • Status: Closed
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: ODF 1.2
    • Fix Version/s: ODF 1.3
    • Component/s: Part 3 (Schema) [1.2: 1], Table
    • Labels:
      None
    • Proposal:
      Hide

      Propose the following changes:

      1. Add Cache index to <table:data-pilot-member>
      <table:data-pilot-member>
      The <table:data-pilot-member> element specifies what information is displayed for a member.
      element-table:data-pilot-member
      The <table:data-pilot-member> element is usable with the following element: <table:data-pilot-members> 8.7.10.
      The <table:data-pilot-member> element has the following attributes: table:display 17.620, table:name 17.676 , table:show-details 17.711 and table:cache-id.
      The <table:data-pilot-member> element has no child elements.

      2. Add Cache index to <table:data-pilot-group-member>
      <table:data-pilot-group-member>
      The <table:data-pilot-group-member> element specifies the name of a single group member.
      element-table:data-pilot-group-member
      The <table:data-pilot-group-member> element is usable with the following element: <table:data-pilot-group> 8.7.17.
      The <table:data-pilot-group-member> element has the following attribute: table:name 17.676 and table:cache-id.
      The <table:data-pilot-group-member> element has no child elements.

      3. Add Cache index to <table:data-pilot-field> to identify selected-page
      <table:data-pilot-field>
      The <table:data-pilot-field> element specifies a field for a data pilot table.
      element-table:data-pilot-field
      The <table:data-pilot-field> element is usable with the following element: <table:data-pilot-table> 8.7.3.
      The <table:data-pilot-field> element has the following attributes: table:function 17.646, table:is-data-layout-field 17.656, table:orientation 17.689, table:selected-page 17.710, table:selected-page-cache-id, table:source-field-name 17.716 and table:used-hierarchy 17.747.
      The <table:data-pilot-field> element has the following child elements: <table:data-pilot-field-reference> 8.7.15, <table:data-pilot-groups> 8.7.16 and <table:data-pilot-level> 8.7.7.

      4. Add Cache index to <table:data-pilot-field-reference>
      The <table:data-pilot-field-reference> element describes data which can be used to modify the displayed values of data fields.
      element-table:data-pilot-field-reference
      The <table:data-pilot-field-reference> element is usable with the following element: <table:data-pilot-field> 8.7.6.
      The <table:data-pilot-field-reference> element has the following attributes: table:field-name 17.639, table:member-name 17.671, table:member-cache-id, table:member-type 17.672 and table:type 17.737.
      The <table:data-pilot-field-reference> element has no child elements.

      Show
      Propose the following changes: 1. Add Cache index to <table:data-pilot-member> <table:data-pilot-member> The <table:data-pilot-member> element specifies what information is displayed for a member. element-table:data-pilot-member The <table:data-pilot-member> element is usable with the following element: <table:data-pilot-members> 8.7.10. The <table:data-pilot-member> element has the following attributes: table:display 17.620, table:name 17.676 , table:show-details 17.711 and table:cache-id. The <table:data-pilot-member> element has no child elements. 2. Add Cache index to <table:data-pilot-group-member> <table:data-pilot-group-member> The <table:data-pilot-group-member> element specifies the name of a single group member. element-table:data-pilot-group-member The <table:data-pilot-group-member> element is usable with the following element: <table:data-pilot-group> 8.7.17. The <table:data-pilot-group-member> element has the following attribute: table:name 17.676 and table:cache-id. The <table:data-pilot-group-member> element has no child elements. 3. Add Cache index to <table:data-pilot-field> to identify selected-page <table:data-pilot-field> The <table:data-pilot-field> element specifies a field for a data pilot table. element-table:data-pilot-field The <table:data-pilot-field> element is usable with the following element: <table:data-pilot-table> 8.7.3. The <table:data-pilot-field> element has the following attributes: table:function 17.646, table:is-data-layout-field 17.656, table:orientation 17.689, table:selected-page 17.710, table:selected-page-cache-id, table:source-field-name 17.716 and table:used-hierarchy 17.747. The <table:data-pilot-field> element has the following child elements: <table:data-pilot-field-reference> 8.7.15, <table:data-pilot-groups> 8.7.16 and <table:data-pilot-level> 8.7.7. 4. Add Cache index to <table:data-pilot-field-reference> The <table:data-pilot-field-reference> element describes data which can be used to modify the displayed values of data fields. element-table:data-pilot-field-reference The <table:data-pilot-field-reference> element is usable with the following element: <table:data-pilot-field> 8.7.6. The <table:data-pilot-field-reference> element has the following attributes: table:field-name 17.639, table:member-name 17.671, table:member-cache-id, table:member-type 17.672 and table:type 17.737. The <table:data-pilot-field-reference> element has no child elements.

      Description

      Requirement :

      Currently the properties of DataPilot Field member such as visibility, ShowDetailsMode are indexed by name. But sometimes different members can have the same name( 34.8 and 35.2 can both have the name of 35 if they are applied a number format with 0 Decimal places ), and the same member may has different name( such as "01/01/2011" may be named as "2011-01-01" or "Jan 01,2011" in another locale ). As a result, the properties belong to one member may be incorrectly applied to another member with the same name, and the properties also may be lost when the member name is changed( This may occur when we open a document saved in a differect locale ). In order to reslove problems like this, we suggest use Cache Index to identify the certain member likes what MS Excel does. With cache index, we can exactly identify the certain member whose properties should be applied to. The Cache Index of DataPilot Field member need to be stored into .ods files.

        Attachments

          Activity

            People

            • Assignee:
              jiamingf Mingfei Jia (Inactive)
              Reporter:
              jiamingf Mingfei Jia (Inactive)
            • Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: