Issue 97873 - Improve DataPilot import from OOXML/OOBIN
Summary: Improve DataPilot import from OOXML/OOBIN
Status: CLOSED FIXED
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 3.0
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: oc
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-01-08 14:22 UTC by daniel.rentz
Modified: 2017-05-20 11:41 UTC (History)
1 user (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description daniel.rentz 2009-01-08 14:22:19 UTC 
- improve OOXML import filters for pivot tables aka DataPilots.
- add OOBIN import filters.

based on test documents available on http://sc.openoffice.org/testdocs/index.html
Comment 1 daniel.rentz 2009-01-08 14:24:06 UTC 
added support for pivot tables based on
- defined names in the own document
- built-in defined names in the own document (e.g. print ranges or auto filter
ranges)
- explicit cell ranges in external documents: A dummy sheet will be created that
contains the source data from the external document.
Comment 2 daniel.rentz 2009-01-08 14:48:18 UTC 
- added import of field order in row/column dimension
- added API property to set a sequence of field subtotals
(com.sun.star.sheet.DataPilotField.Subtotals) and import subtotals
- added import of row/col field layout settings
(com.sun.star.sheet.DataPilotField.LayoutInfo)
- added import of data field function (com.sun.star.sheet.DataPilotField.Function)
- added import of data field result reference
(com.sun.star.sheet.DataPilotField.Reference)
- added API to access data layout field
(com.sun.star.sheet.DataPilotField.XDataPilotDataLayoutFieldSupplier) and import
position of data layout field
Comment 3 daniel.rentz 2009-01-16 14:11:22 UTC 
Added import of AutoShow settings:
- supported: show top/bottom n items of a data field
- not supported: show top/bottom n percent of items, show top/bottom items where
the sum of their values does not exceed n.
AutoShow is saved differently by Excel 2003 and Excel 2007, import filter has
been extended for both formats.

Added import of field item settings:
- items hidden/visible
- items expanded/collapsed
Comment 4 daniel.rentz 2009-02-09 12:28:14 UTC 
Added import of grouping settings
- items grouped by name (discrete grouping), also nested group fields
- value range grouping (start/end/step count)
- date grouping, also nested group fields

Improved, or better repaired API for date grouping
(com.sun.star.sheet.XDataPilotFieldGrouping.createDateGroup)
Comment 5 daniel.rentz 2009-02-16 14:57:35 UTC 
Added import of autosort settings (sorting mode of items in a field)
(com.sun.star.sheet.DataPilotField.SortInfo)
- manual item order (moved by hand)
- ascending/descending by own item names
- ascending/descending by values of a data field
Comment 6 daniel.rentz 2009-02-16 15:21:38 UTC 
done.
Comment 7 daniel.rentz 2009-03-12 14:24:31 UTC 
back to QA
Comment 8 daniel.rentz 2009-03-12 14:35:25 UTC 
correct target
Comment 9 oc 2009-04-14 10:55:46 UTC 
verified in internal build cws_dr67