[Libreoffice-bugs] [Bug 124741] New: Cell width/height changes when exported to XLSX

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 124741
           Summary: Cell width/height changes when exported to XLSX
           Product: LibreOffice
           Version: 5.3.0.3 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Keywords: bibisected, bisected, regression
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: baron at caesar.elte.hu
                CC: gang65 at poczta.onet.pl
            Blocks: 108897

Created attachment 150753
  --> https://bugs.documentfoundation.org/attachment.cgi?id=150753&action=edit
Sample ODS

The attached spreadsheet table was copied from bug 123421's sample, just
without pivot table content. The sample is using Calibri font, which is
installed on the system.

Save it as XLSX and reopen.

=> The width of the most columns and height of empty rows change.

Original 1st and 2nd column widths: 2.26 cm & 2.76 cm.
XLSX 1st and 2nd column widths: 1.7 cm & 2.76 cm.

Height of 2nd and other empty rows also changes from 0.56 cm to 0.45 cm.

Observed using LO 6.3.0.0.alpha0+ (2e3b0c5d42d60d46cd9f8b8eda9424b095c63418) &
5.3.0.3 / Windows 7.
Looks better in 5.2.0.4.
=> somewhat of a regression

In 5.2.0.4 the column widths in the exported XLSX are 2.22 and 2.73 cm
respectively. The row height is still 0.45 cm.

Bibisected the 5.2 -> 5.3 difference to the following commit using repo
bibisect-linux-64-5.3. Adding Cc: to Bartosz Kosiorek.

https://cgit.freedesktop.org/libreoffice/core/commit/?id=40d892a2db4d750aaf0562c63004e693c028273c
author          Bartosz Kosiorek <gang65 at poczta.onet.pl>        2016-07-19
00:26:54 +0200
committer       Markus Mohrhard <markus.mohrhard at googlemail.com>       
2016-07-28 23:23:49 +0200

tdf#100946 Fix width calculation and add customWidth support (.xlsx)


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=108897
[Bug 108897] [META] XLSX (OOXML) bug tracker
-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190415/035c4f63/attachment.html>