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

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #3 from SheetJS <dev at sheetjs.com> ---
A file generated from LibreOffice was attached.  The relevant segment is in the
`cols` xml block from the `xl/worksheets/sheet1.xml` entry within the file:

```xml
  <cols>
    <col collapsed="false" customWidth="false" hidden="false" outlineLevel="0"
max="1" min="1" style="0" width="11.52"/>
    <col collapsed="false" customWidth="true" hidden="false" outlineLevel="0"
max="2" min="2" style="0" width="2.65"/>
    <col collapsed="false" customWidth="false" hidden="false" outlineLevel="0"
max="1025" min="3" style="0" width="11.52"/>
  </cols>
```

The "max" field in the third col entry is "1025".  That column maps to the name
"AMK", which is beyond the AMJ max column that LibreOffice currently supports.

As far as Excel is concerned, the previous block is equivalent to

```
  <cols>
    <col collapsed="false" customWidth="false" hidden="false" outlineLevel="0"
max="1" min="1" style="0" width="11.52"/>
    <col collapsed="false" customWidth="true" hidden="false" outlineLevel="0"
max="2" min="2" style="0" width="2.65"/>
    <col collapsed="false" customWidth="false" hidden="false" outlineLevel="0"
max="1024" min="3" style="0" width="11.52"/>
    <col collapsed="false" customWidth="false" hidden="false" outlineLevel="0"
max="1025" min="1025" style="0" width="11.52"/>
  </cols>
```

But when you make that change (see second attachment) LibreOffice complains

-- 
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/20190604/e2793675/attachment.html>