[Libreoffice-bugs] [Bug 125380] New: FILESAVE XLSX write includes col record incompatible with LibreOffice

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=125380

            Bug ID: 125380
           Summary: FILESAVE XLSX write includes col record incompatible
                    with LibreOffice
           Product: LibreOffice
           Version: 6.2.3.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: dev at sheetjs.com

Description:
When saving a new file to the XLSX file format, LO writes the following column
record:

    <col collapsed="false" customWidth="false" hidden="false" outlineLevel="0"
max="1025" min="1" style="0" width="11.52"/>

"min" and "max" are 1-indexed and inclusive, so this describes columns A:AMK. 
LO currently supports 1024 columns so that column AMK is technically outside of
the valid range.

The following two records are equivalent to the one LO writes:

    <col collapsed="false" customWidth="false" hidden="false" outlineLevel="0"
max="1024" min="1" style="0" width="11.52"/>
    <col collapsed="false" customWidth="false" hidden="false" outlineLevel="0"
max="1025" min="1025" style="0" width="11.52"/>

However, due to the column restriction, the latter elicits a warning.

The fix is to write that col record with range up to 1024:

    <col collapsed="false" customWidth="false" hidden="false" outlineLevel="0"
max="1024" min="1" style="0" width="11.52"/>


Actual Results:
LO-generated XLSX references column 1025

Expected Results:
LO-generated XLSX should not reference unsupported columns


Reproducible: Always


User Profile Reset: Yes



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/20190520/ce4154f4/attachment-0001.html>