[Libreoffice-bugs] [Bug 123139] Reading XLSX format ignores horizontal alignment (generated wit Apache POI Java library)

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #4 from SheetJS <dev at sheetjs.com> ---
Running into this issue with spreadsheets generated by SheetJS Pro.

In the <xf> records, Excel assumes that applyAlignment is true if an
<alignment> child is present.  You are expected to specify applyAlignment="0"
if alignment does not apply.

LibreOffice (including the latest version 6.4.1.2) assumes that applyAlignment
is false even if an <alignment> child is present.  The default behavior is
incorrect.

To verify this is the root cause, you can take the original sample file and add
the applyAlignment="1" attribute to the <cellXfs> <xf> tag:

```xml
    <xf numFmtId="0" fontId="0" fillId="0" borderId="0" xfId="0"
applyAlignment="1">
      <alignment horizontal="left"/>
    </xf>
```

-- 
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/20200228/3bf35a58/attachment.htm>