Issue 32989 - Pivotcache / datasource information is lost when opening Excel Spreadsheets including Pivot Tables, i.e. data cells are copied as ordinary data without any reference.
Summary: Pivotcache / datasource information is lost when opening Excel Spreadsheets i...
Status: CLOSED DUPLICATE of issue 70650
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 1.1.2
Hardware: All All
: P3 Trivial with 1 vote (vote)
Target Milestone: ---
Assignee: requirements
QA Contact: issues@sc
URL:
Keywords: ms_interoperability, rfe_eval_ok
: 61694 (view as issue list)
Depends on:
Blocks:
 
Reported: 2004-08-14 01:24 UTC by skarre
Modified: 2013-08-07 15:12 UTC (History)
2 users (show)

See Also:
Issue Type: FEATURE
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 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