Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing
|Summary:||MSO .xlsx fails to import properly: Rows not colored, Missing Border, and Data Missing Err:509|
|Component:||open-import||Assignee:||AOO issues mailing list <issues>|
|Status:||CONFIRMED ---||QA Contact:|
|Issue Type:||DEFECT||Latest Confirmation in:||4.0.0|
Description slacka 2013-07-30 07:30:51 UTC
This bug was tested OpenOffice v4.0 running in windows 7 and XP. It appears that OpenOffice loses formatting when importing MS xlsx files. I have attached an example. Steps to reproduce the bug: 1. Open attachment 81201 [details] Demo-2012SummerOlympics.xlsx document in calc 2. Open attachment 81201 [details] Demo-2012SummerOlympics.xlsx document in Excel2010/Office 365 3. Compare the documents. From the attached screenshot, please note: Item #1 from the screenshot that the rows should alternate from white to blue. Item #2 in the screenshot that the border is missing from the row. Item #3 in the screenshot instead of showing the data, there is an err:509 I believe these 3 are all using Excel's Format As Table feature.
Comment 1 slacka 2013-07-30 07:31:27 UTC
Created attachment 81203 [details] Comparison of xlsx doc in Excel vs Calc 2
Comment 2 Edwin Sharp 2013-07-30 09:32:04 UTC
Confirmed with Excel 2007 and Calc Rev. 1507307 Win 7.
Comment 3 Oliver-Rainer Wittmann 2013-08-09 14:02:08 UTC
also reproduced in OOo 3.3.0 -> adjusting field Version accordingly