Issue 96078 - Imported MS Excel 2007 Pivot Table and Pivot Graph are not displayed correctly
Summary: Imported MS Excel 2007 Pivot Table and Pivot Graph are not displayed correctly
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOO300m9
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-11-11 06:12 UTC by yuko
Modified: 2013-01-29 21:50 UTC (History)
4 users (show)

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

Attachments
screenshot (143.23 KB, image/png)
2008-11-11 06:14 UTC, yuko 		no flags Details
sample file (20.30 KB, application/vnd.ms-excel)
2008-11-11 06:14 UTC, yuko 		no flags Details
illustrating screenshot (213.40 KB, image/jpeg)
2009-07-19 10:57 UTC, kpalagin 		no flags Details
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 yuko 2008-11-11 06:12:47 UTC 
When opening MS Excel 2007 .xlsx file, Pivot Table and Pivot Graph are not
displayed correctly.
Please see the attached screenshot.
Comment 1 yuko 2008-11-11 06:14:01 UTC 
Created attachment 57859 [details]
screenshot
Comment 2 yuko 2008-11-11 06:14:45 UTC 
Created attachment 57860 [details]
sample file
Comment 3 stefan.baltzer 2008-11-11 12:42:13 UTC 
Reassigned.
Comment 4 pmike 2009-07-17 21:11:15 UTC 
WORKFORME, OOo-dev m52, Linux
Comment 5 kpalagin 2009-07-19 10:56:04 UTC 
Findings - OO3.1 does not import the chart well, but 3.2 dev (m52) imports it 
almost perfect (in some ways even better then MSO):
1. cell A2 - Excel has misspelled word "depertment", we somehow manage to show 
it spelled correctly.
2. on chart we group digits by 3, Excel does not.
3. on chart for Y axis we have "Month June" for June only, but not for 
everything else. Excel just specifies month names. 

So confirming issue for the points above - see attached screenshot.
Comment 6 kpalagin 2009-07-19 10:57:27 UTC 
Created attachment 63630 [details]
illustrating screenshot