Issue 32989

Summary:	Pivotcache / datasource information is lost when opening Excel Spreadsheets including Pivot Tables, i.e. data cells are copied as ordinary data without any reference.
Product:	Calc	Reporter:	skarre <skarre>
Component:	open-import	Assignee:	requirements <requirements>
Status:	CLOSED DUPLICATE	QA Contact:	issues@sc <issues>
Severity:	Trivial
Priority:	P3	CC:	issues, utomo.prawiro
Version:	OOo 1.1.2	Keywords:	ms_interoperability, rfe_eval_ok
Target Milestone:	---
Hardware:	All
OS:	All
Issue Type:	FEATURE	Latest Confirmation in:	---
Developer Difficulty:	---

Description skarre 2004-08-14 01:24:30 UTC

When Excel spreadsheets that have pivot tables and charts in them are opened 
with OpenOffice, data cells are copied as ordinary data without any reference 
to the datasource and the graphs are all blank.

To reproduce this problem, follow the steps below:

1. Using Excel, create a Pivot Table and Pivot Chart using some Data source.

2. Save this Excel sheet.

3. Open the previously saved EXcel sheet in OpenOffice.

4. Examine that the data will be copied as ordinary data with no reference to 
the Datasource and graphs will be blank.

Comment 1 frank 2004-08-16 09:29:36 UTC

Hi Bettina,

the missing feature here is called pivotcache in Excel.

Frank

Comment 2 erwin.tenhumberg 2004-10-28 11:28:53 UTC

enhanced summary, set keywords and reassigned issue according to RFE process

Comment 3 lars 2006-02-07 21:39:47 UTC

*** Issue 61694 has been marked as a duplicate of this issue. ***

Comment 4 utomo99 2006-12-12 09:54:05 UTC

This missing features already reported more than 2 years, and the target still 
OOo later. I think it need to review the target. 
it is ms interopearibility problems
Thanks

Comment 5 frank 2006-12-12 10:30:18 UTC

This is a douvble to fixed Issue 70650.

*** This issue has been marked as a duplicate of 70650 ***

Comment 6 frank 2006-12-12 10:30:53 UTC

closed double