Bug 40645

Summary: FORMATTING: Calc looses row height on reopening the file
Product: LibreOffice Reporter: Olivier Hallot <olivier.hallot>
Component: CalcAssignee: Kohei Yoshida <kohei>
Status: RESOLVED DUPLICATE    
Severity: normal CC: LibreOffice, send_me_spam22
Priority: medium    
Version: 3.3.3 release   
Hardware: Other   
OS: All   
Whiteboard:
Crash report or crash signature: Regression By:
Attachments: sample file with issue
sample document, see Comment 3
flawed row height
corrected row height
Reproduced with nearly identical text.

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

@Olivier:
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
@Rainer

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
@Kohei:
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:
https://www.libreoffice.org/bugzilla/show_bug.cgi?id=49255

Thanks.
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..
Thanks

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 3.5.5.1  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 ***