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 18.104.22.168.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