Created attachment 148870 [details]
Calc ignores horizontal alignment of this XLSX
I don't have full confidence wheather this is a bug or not because I don't have Microsoft Excel.
Anyway I've created a very simple XLSX file using Apache POI Java library. But LibreOffice Calc ignores horizontal alignment of cells.
It seems that this file completely conforms XLSX format. I checked its styles.xml and sheet1.xml file in the attached XLSX file.
I can confirm that result is different than in excel2010, althought I cannot reproduce it with file created in excel. So it's related to Apache POI Java library.
Build ID: 1ac54de7869d5809a312acad0a37d48028ad9d3b
CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3;
regression, in version Version 220.127.116.11.alpha0+ (Build ID: efca6f15609322f62a35619619a6d5fe5c9bd5a) is the result same as in excel.
Created attachment 148883 [details]
compare excel and LO 6.3
This seems to have begun at the below commit.
Adding Cc: to Noel Power ; Could you possibly take a look at this one?
7768846a5953a624076782f3cc0fbdcca5f5c160 is the first bad commit
Author: Matthew Francis <email@example.com>
Date: Sat Sep 5 17:55:40 2015 +0800
Author: Noel Power <firstname.lastname@example.org>
AuthorDate: Wed May 22 10:00:34 2013 +0100
Commit: Noel Power <email@example.com>
CommitDate: Wed May 22 10:03:26 2013 +0100
fix for bnc#819865 itemstate in parent style incorrectly reported as set
Problem occurs because attrs set with default values are reported as set when queried
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 18.104.22.168) 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:
<xf numFmtId="0" fontId="0" fillId="0" borderId="0" xfId="0" applyAlignment="1">