Issue 97873

Summary:	Improve DataPilot import from OOXML/OOBIN
Product:	Calc	Reporter:	daniel.rentz
Component:	open-import	Assignee:	oc
Status:	CLOSED FIXED	QA Contact:	issues@sc <issues>
Severity:	Trivial
Priority:	P3	CC:	issues
Version:	OOo 3.0
Target Milestone:	---
Hardware:	All
OS:	All
Issue Type:	ENHANCEMENT	Latest Confirmation in:	---
Developer Difficulty:	---

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