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: