Created attachment 192808 [details]
LibreOffice Calc does not respect spreadsheet's defaults

If the bug is not clear or anything else is required feel free to ask.

Thank you for this great application !

With all due respect, volunteers here would be forced to read and fully understand the report at:
 <https://github.com/PHPOffice/PhpSpreadsheet/issues/3918> 
in order to attempt to reproduce it.

We need clear steps to reproduce, what is the actual result, what is the expected result, and version information (LO menu help > about; click on the icon to copy to the clipboard).

From the pieces I gathered, apparently PHPOffice/PhpSpreadsheet generates an XLSX file with something like:
 <c r="A1" t="s">

and LO parses it in some "unexpected" way (according to 
 <https://github.com/PHPOffice/PhpSpreadsheet/issues/3918#issuecomment-1964743922> 
in terms of the resulting cell alignment, whereas for XLS (no last 'X'), the resulting alignment is "as expected".

Additionally, when the generated XLSX file includes an 's' parameter too:
 <c r="A1" t="s" s="0">
then apparently the resulting alignment recognized/parsed by LO Calc is "as expected".

I am not sure I understood this correctly, but maybe (and hopefully) this helps other users.

> We need clear steps to reproduce, what is the actual result, what is the expected result

I may not have been clear enough. The file I uploaded "alignment.xslx" should display with "horizontal center / vertical center / wrap", because those are the sheet's defaults. But the cell "A1" (in the file) is displaying "horizontal left / vertical bottom / no-wrap".

> and version information (LO menu help > about; click on the icon to copy to the clipboard).

The version is the one I pasted / selected in the dropdown: 24.2.0.3 (windows), and I just re-checked my version on linux which is 7.3.7.2 (linux) ant it exhibits the same behavior.

> From the pieces I gathered, apparently PHPOffice/PhpSpreadsheet generates an XLSX file with something like:
>  <c r="A1" t="s">
> and LO parses it in some "unexpected" way (according to 
>  <https://github.com/PHPOffice/PhpSpreadsheet/issues/3918#issuecomment-1964743922> 
> in terms of the resulting cell alignment

I did not want to introduce too much bias in case this was not the root issue. But in fact it looks like the default style for alignment is not applied with `<c r="A1" t="s">` while it is applied with `<c r="A1" t="s" s="0">`. Also the default "bold" style seems to be applied with `<c r="A1" t="s">` (without `s="0"`).
This kind on file is "correctly" displayed on Microsoft Excel (from the above GitHub issue) and as they are the only "source of truth" for this kind of file we have to believe this should be the correct behavior.

> whereas for XLS (no last 'X'), the resulting alignment is "as expected"

From my understanding this is an entirely different file format so it may not be fully comparable to xslx.

(In reply to guillaume.alabre from comment #4)

> I may not have been clear enough. The file I uploaded "alignment.xslx"
> should display with "horizontal center / vertical center / wrap", because
> those are the sheet's defaults. But the cell "A1" (in the file) is
> displaying "horizontal left / vertical bottom / no-wrap".

What do you mean with "those are the sheet's defaults"? The default for which software? FWIW, automatic wrap is not the default in LO Calc (and AFAICR, neither in Excel).

(As a side note, there are bugs in LO 24.2.0.3 regarding automatic wrap text, so this particular setting should rather not be checked against LO 24.2.0.3 in order to solve some potential incompatibility with the files generated by PHPOffice/PhpSpreadsheet.)

> What do you mean with "those are the sheet's defaults"? The default for which software? FWIW, automatic wrap is not the default in LO Calc (and AFAICR, neither in Excel).

I am not familiar with xlsx file format.

If I open the "alignment.xslx" file as zip and read the file in "xl/styles.xml" I can read the following:
```
<xf xfId="0" fontId="0" numFmtId="0" fillId="0" borderId="0" applyFont="0" applyNumberFormat="0" applyFill="0" applyBorder="0" applyAlignment="1"><alignment horizontal="center" vertical="center" textRotation="0" wrapText="true" shrinkToFit="false"/></xf>
```

So I guess this declares the default style for the spreadsheet.

> (As a side note, there are bugs in LO 24.2.0.3 regarding automatic wrap text, so this particular setting should rather not be checked against LO 24.2.0.3 in order to solve some potential incompatibility with the files generated by PHPOffice/PhpSpreadsheet.)

There is the same bug in LO 7.3.7.2 and it wraps correctly with "xls" format, so I'm not sure this is the same bug. I think that LO just don't apply spreadsheet's style by default.

(In reply to guillaume.alabre from comment #4)

> The file I uploaded "alignment.xslx"
> should display with "horizontal center / vertical center / wrap", because
> those are the sheet's defaults. But the cell "A1" (in the file) is
> displaying "horizontal left / vertical bottom / no-wrap".

Opening attachment 192808 [details] with 2 other spreadsheet tools, I indeed see "horizontal center / vertical center / wrap".

OTOH, with LO Calc (since 3.3 up to recent 24.8 alpha) and with AOO 4.1.15, I see "horizontal _default_ (so, "left" for the particular case with cell A1 containing text), vertical _bottom_, _no_ wrap text".

Setting this as inherited. Whether this should be considered a bug report or an enhancement request, I am not sure.

Created attachment 192986 [details]
xls files are correctly displayed

Here is an XLS version of the previous XSLX file, exported with the same tool.

Note that with this version the defaults (vertical_center, horizontal_center, wrap_text) are correctly applied.

This makes me think that the issue is more in how defaults are handled than a rendering issue.