Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing
|Summary:||Imported MS Excel 2007 Pivot Table and Pivot Graph are not displayed correctly|
|Component:||open-import||Assignee:||AOO issues mailing list <issues>|
|Status:||CONFIRMED ---||QA Contact:|
|Priority:||P3||CC:||daniel.rentz, frank, issues, kpalagin|
|Issue Type:||DEFECT||Latest Confirmation in:||---|
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 3 stefan.baltzer 2008-11-11 12:42:13 UTC
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.