Bug 88750 - FORMATTING: new "minimum row height" feature is regression causing too high row height for fonts less than 10 pts
Summary: FORMATTING: new "minimum row height" feature is regression causing too high r...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.2.8.2 release
Hardware: x86 (IA32) All
: medium major
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Calc-Images
  Show dependency treegraph
 
Reported: 2015-01-23 15:00 UTC by nbv
Modified: 2020-05-21 14:25 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
ods-example made with LibreOffice 4.1.6 (18.45 KB, application/vnd.oasis.opendocument.spreadsheet)
2015-01-23 15:00 UTC, nbv
Details
pdf-file of the described ods-file (64.51 KB, application/pdf)
2015-01-23 15:03 UTC, nbv
Details
ods-example made with LibreOffice 4.1.6 (similar to example 1) (116 bytes, text/plain)
2015-01-23 15:25 UTC, nbv
Details
ods-example made with LibreOffice 4.1.6 (see also pdf-file) (18.45 KB, application/vnd.oasis.opendocument.spreadsheet)
2015-01-23 15:42 UTC, nbv
Details

Note You need to log in before you can comment on or make changes to this bug.
Description nbv 2015-01-23 15:00:36 UTC
Created attachment 112723 [details]
ods-example made with LibreOffice 4.1.6

Hello

As attachment you can find two files: an ods-example-file made with LO 4.1.6 and a pdf-file made of this ods-file (to preserve the formatting).

[maybe it is not possible to add the pdf-file to]

When you open this ods-file with LO 4.2.8 and when you use the function "optimal-row-height" (in German: Optimale Zeilenhöhe), you will see that the row-hight of some lines will increase.

Regina explained me already very clear the reason for it: New condition "minimal-row-hight" came with LO 4.2.x:

http://ask.libreoffice.org/de/question/45083/libreoffice-428-calc-optimale-zeilenhoehe-zu-gross/

My (quite urgent) request: Is it possible to remove this condition (or to reduce the minimal row-hight to a mesure that works with small Fonts of 4 points for example)?

Thanks a lot for your efforts.

Eibe.
Comment 1 nbv 2015-01-23 15:03:02 UTC
Created attachment 112724 [details]
pdf-file of the described ods-file
Comment 2 nbv 2015-01-23 15:25:41 UTC
Created attachment 112725 [details]
ods-example made with LibreOffice 4.1.6 (similar to example 1)
Comment 3 nbv 2015-01-23 15:42:04 UTC
Created attachment 112728 [details]
ods-example made with LibreOffice 4.1.6 (see also pdf-file)
Comment 4 nbv 2015-01-23 15:58:29 UTC
> 
> Hello
> 
> As attachment you can find two files: an ods-example-file made with LO 4.1.6
> and a pdf-file made of this ods-file (to preserve the formatting).
> 
> When you open this ods-file with LO 4.2.8 and when you use the function
> "optimal-row-height" (in German: Optimale Zeilenhöhe), you will see that the
> row-hight of some lines will increase.
> 
> Regina explained me already very clear the reason for it: New condition
> "minimal-row-hight" came with LO 4.2.x:
> 
> http://ask.libreoffice.org/de/question/45083/libreoffice-428-calc-optimale-
> zeilenhoehe-zu-gross/
> 
> My (quite urgent) request: Is it possible to remove this condition (or to
> reduce the minimal row-hight to a mesure that works with small Fonts of 4
> points for example)?
> 
> Thanks a lot for your efforts.
> 
> Eibe.
Comment 5 Buovjaga 2015-01-29 19:11:38 UTC
Reproduced.

Not "high" & "major", though: https://wiki.documentfoundation.org/images/0/06/Prioritizing_Bugs_Flowchart.jpg

Win 7 Pro 64-bit Version: 4.5.0.0.alpha0+
Build ID: 784d069cc1d9f1d6e6a4e543a278376ab483d1eb
TinderBox: Win-x86@62-TDF, Branch:MASTER, Time: 2015-01-25_23:07:36
Comment 6 andréb 2015-02-25 04:03:07 UTC
This "minimal row height" change is absolutely insane.
It makes working with larger spreadsheets more difficult, for no advantage.
For 7 or 8 ppp rows, it increases the height from 3,6mm to 4,5mm, which is 25%.
What it does could be accomplished by other methods, and if it were wanted to have a minimum row height (I can't imagine why), it should be optional or configurable, so as to not impact those who don't want it.

Whoever did this change must be trying to sabotage libreoffice.

According to the flowchart referred to in comment 5, this is a major bug, since it reduces the viewed area by 20%, which is significant, and is very easily fixed, thus should have the default priority.
Comment 7 andréb 2015-04-09 21:29:26 UTC
Changed title to reflect cause.
Changed to affect all OS's.
(It affects Linux as well as Ms-windows, no reason to suspect it is OS dependent.)
Comment 8 nbv 2015-05-24 17:48:55 UTC
The importance is more than "medium minor": only because of this new minimal row hight a lot of users have to work with LO 4.1.6, the last version without the change.

So they can't benefit of all the important improvements since LO 4.1.6, including the elimination of SECURITY PROBLEMS.

So please fix this baseless "minimal row hight" for 10-point-letters.

See the documents in the attachment that show the crux of the matter.

Thanks a lot.
Comment 10 QA Administrators 2016-09-20 09:46:08 UTC Comment hidden (obsolete)
Comment 11 QA Administrators 2019-12-03 14:30:59 UTC Comment hidden (obsolete)
Comment 12 song_lyrics 2020-05-21 14:23:47 UTC Comment hidden (spam)