[Bug 159916] Spreadsheet default alignment is not honored for xlsx format

[bugzilla-daemon]

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

--- Comment #8 from guillaume.ala...@gmail.com ---
Created attachment 192986
  --> https://bugs.documentfoundation.org/attachment.cgi?id=192986=edit
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.

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Bug 159916] Spreadsheet default alignment is not honored for xlsx format

[bugzilla-daemon]

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

ady  changed:

   What|Removed |Added

 Blocks||108252


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=108252
[Bug 108252] [META] Cell-related bugs and enhancements (including formatting)
-- 
You are receiving this mail because:
You are the assignee for the bug.

[Bug 159916] Spreadsheet default alignment is not honored for xlsx format

[bugzilla-daemon]

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

ady  changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEW
Version|24.2.0.3 release|Inherited From OOo
 Ever confirmed|0   |1

--- Comment #7 from ady  ---
(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 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.

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Bug 159916] Spreadsheet default alignment is not honored for xlsx format

[bugzilla-daemon]

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

--- Comment #6 from guillaume.ala...@gmail.com ---
> 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:
```

```

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.

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Bug 159916] Spreadsheet default alignment is not honored for xlsx format

[bugzilla-daemon]

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

--- Comment #5 from ady  ---
(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.)

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Bug 159916] Spreadsheet default alignment is not honored for xlsx format

[bugzilla-daemon]

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

--- Comment #4 from guillaume.ala...@gmail.com ---
> 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:
>  
> and LO parses it in some "unexpected" way (according to 
>  
> 
>  
> 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
`` while it is applied with ``. Also the
default "bold" style seems to be applied with `` (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.

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Bug 159916] Spreadsheet default alignment is not honored for xlsx format

[bugzilla-daemon]

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

Julien Nabet  changed:

   What|Removed |Added

Summary|Spreadhseet default |Spreadsheet default
   |alignment is not honored|alignment is not honored
   |for Xlsx format |for xlsx format

-- 
You are receiving this mail because:
You are the assignee for the bug.