https://bugs.documentfoundation.org/show_bug.cgi?id=159916
ady <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Summary|Spreadhseet default |Spreadhseet default |alignment is not honored |alignment is not honored |for Xslx format |for Xlsx format --- Comment #3 from ady <[email protected]> --- 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. -- You are receiving this mail because: You are the assignee for the bug.
