https://bugs.documentfoundation.org/show_bug.cgi?id=122917
Bug ID: 122917
Summary: FILEOPEN/FILESAVE XLSX Excel table is incorrectly
imported/exported
Product: LibreOffice
Version: 5.4.0.0.alpha0+
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Excel table is incorrect when the document is opened in Calc. Exported
spreadsheet with Excel table is incorrectly opened in Excel.
Steps to Reproduce:
1. Create a new spreadsheet in Microsoft Excel 2016.
2. Create an Excel table. (Insert→Table)
3. On the Table Tools > Design tab, in the Table Style Options group,
select: Header Row, Total Row, Banded Rows, First Column, Last Column, Banded
Columns.
4. Deselect: Filter Button.
5. Save the file as XLSX.
6. Open the same file in LibreOffice Calc.
Actual results:
Banded Rows, First Column, Last Column and Banded Columns settings disappear.
Filter controls are added to the table headers.
Expected results:
Excel table should have the same style as the original file opened in Microsoft
Word 2016.
7. Save the file as XLSX.
8. Open the same file in Microsoft Excel 2016.
Actual Results:
Error message: Excel found unreadable content in filename...
Excel was able to open the file by repairing or removing the unreadable
content.
Selected options: Header Row, Banded Rows, Filter Button.
Deselected options: Total Row, First Column, Last Column, Banded Columns.
Expected Results:
Spreadsheet should open correctly in Excel. Excel table should have the same
style as the original file opened in Microsoft Word 2016.
Reproducible: Always
User Profile Reset: No
Additional Info:
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
