Bug 40645 - FORMATTING: Calc looses row height on reopening the file
Summary: FORMATTING: Calc looses row height on reopening the file
Status: RESOLVED DUPLICATE of bug 49255
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
3.3.3 release
Hardware: Other All
: medium normal
Assignee: Kohei Yoshida
Depends on:
Reported: 2011-09-05 14:58 UTC by Olivier Hallot
Modified: 2012-09-07 18:24 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:
Regression By:

sample file with issue (7.67 KB, application/vnd.oasis.opendocument.spreadsheet)
2011-09-05 14:58 UTC, Olivier Hallot
sample document, see Comment 3 (9.41 KB, application/vnd.oasis.opendocument.spreadsheet)
2011-09-05 23:01 UTC, Rainer Bielefeld Retired
flawed row height (2.39 KB, image/png)
2012-06-07 07:01 UTC, Olivier Hallot
corrected row height (2.48 KB, image/png)
2012-06-07 07:01 UTC, Olivier Hallot
Reproduced with nearly identical text. (9.79 KB, application/vnd.oasis.opendocument.spreadsheet)
2012-06-17 13:19 UTC, Nick R

Note You need to log in before you can comment on or make changes to this bug.
Description Olivier Hallot 2011-09-05 14:58:10 UTC
Created attachment 50927 [details]
sample file with issue

This bug exist in 3.3.x and 3.4.x on all platforms

Steps to reproduce:

Open a new empty Calc sheet.

Pick a cell. Format the cell with "allow line break" in cell, under "Alignement" tab

Put any text to force cell height to increase.

Format cell height as "ideal" in the Format menu. Cell should display all the text

Save file

Open file again.

Result: cell height is smaller than before, 1 or 2 lines smaller.

See sample file attached
Comment 1 Rainer Bielefeld Retired 2011-09-05 23:01:08 UTC
Modified Version due to report

[Reproducible] with reporter's sample and "LibreOffice 3.4.3 RC2 - WIN7 Home Premium (64bit) German UI [OOO340m1 (Build:302)]".

Not reproducible with my own sample document. But I often suffer from that problem without knowing how to make it reproducible.

The problem is no longer visible with reporter's sample and Server installation of Master "LibO-dev 3.5.0 – WIN7 Home Premium (64bit) English UI [(Build ID:  3b32204-7f92fce-2ba0a9f)]", so my intention is to close this one as WRM target:3.5.0

Please contribute information concerning the OSs you tested.
Can you check "mytest3.ods" and may be find out why the problem did not appear during my tests?
Comment 2 Rainer Bielefeld Retired 2011-09-05 23:01:42 UTC
Created attachment 50932 [details]
sample document, see Comment 3
Comment 3 Olivier Hallot 2011-09-06 04:07:19 UTC

The issue was found in documents on version 3.3.2 for windows XP and on version 3.4.3 for Linux (Mandriva 2011 with Libo TDF builds).

The sample in comment #1 was created from scratch as indicated in Linux 3.4.3 (mandriva 2011 with Libo TDF builds)

The sample in comment #3 does *not* show the issue in Linux 3.4.3 (Mandriva 2011 with Libo TDF builds).

Recreating the issue in a 3.5 master build (built last week) does *not* show the issue anymore.
Comment 4 Rainer Bielefeld Retired 2011-12-15 23:00:44 UTC
That might affect quite a lot documents created with older versions.
Please chekc after vacation and feel free to reassign (or reset Assignee to default) if it’s not your area or if provided information is not sufficient. Please set Status to ASSIGNED if you accept this Bug.
Comment 5 Daniel Chung 2012-04-28 15:26:22 UTC
Please also check:

Comment 6 Florian Reisinger 2012-05-19 10:42:08 UTC
Please do not use https://www.libreoffice.org/bugzilla/*, use https://bugs.freedesktop.org/* URLs instead..

Florian R.
Comment 7 Kohei Yoshida 2012-06-01 11:54:42 UTC
Olivier, I take this you can no longer reproduce this using the latest build?  I'll close this.  If you can still reproduce this, please re-open.
Comment 8 Olivier Hallot 2012-06-07 07:00:42 UTC
Sorry, but I continue to have the same issue.

Linux Kubuntu/64 with TDF build (3.5.4).

Seems that optimal height attribute is not preserved when reloading the file.

I have attached 2 images: the 1st shows flawed row height, and a small red triangle shows the cell content is truncated.

The second shows row height corrected from #1, applying optimal row height.

Kind regards.
Comment 9 Olivier Hallot 2012-06-07 07:01:23 UTC
Created attachment 62719 [details]
flawed row height
Comment 10 Olivier Hallot 2012-06-07 07:01:55 UTC
Created attachment 62720 [details]
corrected row height
Comment 11 Nick R 2012-06-17 13:19:15 UTC
Created attachment 63147 [details]
Reproduced with nearly identical text.

Nearly identical text produces different row heights.
Comment 12 Nick R 2012-06-17 13:19:51 UTC
I am able to reproduce this in 3.5 on Ubuntu 12.04.  I attached a file.  

There are two cells populated.  Both rows have an incorrect height.  The only difference between the content of the two cells is one uses a regular ANSI hyphen '-' and the other uses U+2013 (En Dash) that is automatically substituted in certain situations.

The files look like they were saved fine and is probably a display issue when the file is first loaded.
Comment 13 Rainer Bielefeld Retired 2012-06-17 13:42:04 UTC
[Reproducible] with "LibreOffice  German UI/Locale [Build-ID: c9944f7-48b7ff5-0507789-54a4c8a-8b242a8] on German WIN7 Home Premium (64bit) 

I open document, apply optimum row height for rows 1,2, result hight 8,48mm.
Save, close, reopen, both rows 12,52mm
Comment 14 Rainer Bielefeld Retired 2012-06-17 13:43:36 UTC
[Reproducible] with Master " 3.7.0alpha0+  – WIN7 Home Premium (64bit) ENGLISH UI [Build ID: 5af60dc]" (tinderbox: Win-x86@6-fast, pull time 2012-06-14 22:09:53)
Comment 15 Olivier Hallot 2012-09-07 18:24:35 UTC
Seems to be fixed by bug 49255

*** This bug has been marked as a duplicate of bug 49255 ***