[Libreoffice-bugs] [Bug 120522] New: FILEOPEN XLSX Wrapped text looks different in Excel and Calc

[b***@bugs.documentfoundation.org]

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

Bug ID: 120522
Summary: FILEOPEN XLSX Wrapped text looks different in Excel
and Calc
Product: LibreOffice
Version: 6.1.0.3 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-***@lists.freedesktop.org
Reporter: ***@ubuntu.com

Created attachment 145619
--> https://bugs.documentfoundation.org/attachment.cgi?id=145619&action=edit
Example file from Excel with wrapped text.

Wrapped text looks different in Excel and Calc, when the row height of the cell
is default (15).

Steps to reproduce:

1. Create a new spreadsheet in Microsoft Excel 2010.
2. Write something in a cell.
3. Set the vertical alignment of the cell Middle or Bottom.
4. On the Home tab, in the Alignment group, click Wrap text.
5. On the Home tab, in the Cells group, click Format.
6. Under Cell Size, click Row Height.
7. In the Row Height box, write 15.
8. Save the file as XLSX.
9. Open the same file in LibreOffice Calc.

Actual results:
Microsoft Excel shows top of the text, but LibreOffice Calc shows middle or
bottom of the text.

Expected results:
LibreOffice Calc should show top of the text.


LibreOffice details:
Version: 6.2.0.0.alpha0+
Build ID: 94bf82a8ceba41c32cf3620529e6ce8ea94f18c0
CPU threads: 4; OS: Windows 6.1; UI render: default; VCL: win;
TinderBox: Win-***@42, Branch:master, Time: 2018-10-08_01:10:23
Locale: en-US (hu_HU); Calc: threaded

[b***@bugs.documentfoundation.org]

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

--- Comment #1 from Gabor Kelemen <***@ubuntu.com> ---
Created attachment 145620
--> https://bugs.documentfoundation.org/attachment.cgi?id=145620&action=edit
Screenshot of the original document side by side in Excel and Calc

[b***@bugs.documentfoundation.org]

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

Buovjaga <***@suomi24.fi> changed:

What |Removed |Added
----------------------------------------------------------------------------
Keywords| |bibisected, filter:xlsx,
| |regression
CC| |***@suomi24.fi
Status|UNCONFIRMED |NEW
Ever confirmed|0 |1
Version|6.1.0.3 release |3.6.0.4 release

--- Comment #2 from Buovjaga <***@suomi24.fi> ---
Bibisected on Ubuntu 14.04 with 43all repo to range
https://gerrit.libreoffice.org/plugins/gitiles/core/+log/cac1f33e839469d884730350e46a21d92fb442f2..9afb6e1e38c362a768e8e981f7b03cf8bcaf22cf

Probably
https://gerrit.libreoffice.org/plugins/gitiles/core/+/764752f5d85cb7c86ad21340dfdda4b62754790c%5E%21/

better import xlsx heights

don't call UpdateAllRowHeights when IsAdjustHeightEnabled property is set and
additionally set manual heights for *all* imported row heights ( same afaics
xls import does ) - certainly this improves import ( also see documents
attached in i#94028, i#93609 )

No other regression report found blaming the commit.

[b***@bugs.documentfoundation.org]

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

Roman Kuznetsov <***@mail.ru> changed:

What |Removed |Added
----------------------------------------------------------------------------
Blocks| |108897


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=108897
[Bug 108897] [META] XLSX (OOXML) bug tracker