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.
Banded Rows, First Column, Last Column and Banded Columns settings disappear. Filter controls are added to the table headers.
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.
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.
Spreadsheet should open correctly in Excel. Excel table should have the same style as the original file opened in Microsoft Word 2016.
User Profile Reset: No
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 ***
*** This bug has been marked as a duplicate of bug 66377 ***