Issue 96078

Summary: Imported MS Excel 2007 Pivot Table and Pivot Graph are not displayed correctly
Product: Calc Reporter: yuko <yuko.ohsumi>
Component: open-importAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: daniel.rentz, frank, issues, kpalagin
Version: OOO300m9   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
screenshot
none
sample file
none
illustrating screenshot none

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