[Libreoffice-bugs] [Bug 122917] New: FILEOPEN/FILESAVE XLSX Excel table is incorrectly imported/exported

[bugzilla-daemon at bugs.documentfoundation.org]

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: libreoffice-bugs at lists.freedesktop.org
          Reporter: libreoffice at nisz.hu

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190124/ed9bae8a/attachment.html>