| Summary: | FILEOPEN/FILESAVE XLSX Excel table is incorrectly imported/exported | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | NISZ LibreOffice Team <libreoffice> |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED DUPLICATE | ||
| Severity: | normal | CC: | 79045_79045, aron.budea, kelemeng, nemeth |
| Priority: | medium | Keywords: | filter:xlsx |
| Version: | 5.4.0.0.alpha0+ | ||
| Hardware: | All | ||
| OS: | All | ||
| Whiteboard: | |||
| Crash report or crash signature: | Regression By: | ||
| Attachments: |
Screenshot of the original document side by side in Excel and Calc.
Screenshot of the original and exported document side by side in Excel. Example file from Excel with an Excel table. The original file saved by Calc. |
||
Created attachment 148581 [details]
Screenshot of the original document side by side in Excel and Calc.
Created attachment 148582 [details]
Screenshot of the original and exported document side by side in Excel.
Created attachment 148583 [details]
Example file from Excel with an Excel table.
Created attachment 148584 [details]
The original file saved by Calc.
Excel functional "Format as table" is missed in LibreOffice. *** This bug has been marked as a duplicate of bug 112371 *** |
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: