Created attachment 120080 [details] Sample spreadsheet with rows of different font sizes When you use a smallish (<10pt) font for a row in Calc, the optimal row height is not shrunk accordingly, but stays fixed at the default. For larger font sizes this works fine. Worse, existing spreadsheets with correct row heights change back to the larger size when you enter/change cell values. I have attached a simple spreadsheet exhibiting this problem. Note: OpenOffice works fine in this case.
Bodhi 3.x LibreOffice 5.0.2.2 release - if you can test older versions and report back that would be great (http://downloadarchive.documentfoundation.org/libreoffice/old/) Setting to: NEW Minor - can slow down but won't prevent high quality work; Low - easy workaround (manually set) It's a little unclear if the second thing mentioned is a separate issue - if it is it should be reported separately. In the future please don't report bugs against master without testing a stable release first as "version" is oldest version the bug is on so master should only contain regressions.
Hi Joel, thanks for looking into this. (In reply to Joel Madero from comment #1) > Bodhi 3.x > LibreOffice 5.0.2.2 release - if you can test older versions and report back > that would be great > (http://downloadarchive.documentfoundation.org/libreoffice/old/) I downloaded and tested this against the 4.4.6.3 release just now too and it exhibits the same behaviour. If you want, I can easily test other versions too. > Setting to: > NEW > Minor - can slow down but won't prevent high quality work; > Low - easy workaround (manually set) (though it becomes quiet cumbersome to do this for hundreds of rows…) > It's a little unclear if the second thing mentioned is a separate issue - if > it is it should be reported separately. I'm sure this is actually one and the same issue, updating a cell just triggers libre office to re-evaluate the optimal row height. > In the future please don't report bugs against master without testing a > stable release first as "version" is oldest version the bug is on so master > should only contain regressions. Oops, I selected the wrong version; I was using the latest stable version (5.0.2.2) Hope this is an easy thing to fix as most of my spreadsheets have these smaller font size rows (to cram more info on them)…
I tested some more versions: v3.3.0 Fully OK (row height shown correctly) v3.6.7.2 Half working OK. Initially the spreadsheet is shown with the rows too high. Manually setting the optimal row height via the context menu/double clicking works correctly though. v4.0.0.1 Same bad behaviour as in 5.0.2.2 v4.4.6.3 Same bad behaviour as in 5.0.2.2
I had to skip a couple commits because of other issues so it's not perfect but hopefully it gives some guidance. Also upping to Medium because it's a regression. There are only 'skip'ped commits left to test. The first bad commit could be any of: c9046ea7e069426d10e071d0bcb01c64685844c6 2d8ee8e5bf8901874460df1b36b3faceae1cb931 We cannot bisect more! # bad: [423a84c4f7068853974887d98442bc2a2d0cc91b] source-hash-c15927f20d4727c3b8de68497b6949e72f9e6e9e # good: [65fd30f5cb4cdd37995a33420ed8273c0a29bf00] source-hash-d6cde02dbce8c28c6af836e2dc1120f8a6ef9932 git bisect start 'latest' 'oldest' # good: [e02439a3d6297a1f5334fa558ddec5ef4212c574] source-hash-6b8393474974d2af7a2cb3c47b3d5c081b550bdb git bisect good e02439a3d6297a1f5334fa558ddec5ef4212c574 # good: [4850941efe43ae800be5c76e1102ab80ac2c085d] source-hash-980a6e552502f02f12c15bfb1c9f8e6269499f4b git bisect good 4850941efe43ae800be5c76e1102ab80ac2c085d # skip: [a900e72b6357882284c5955bdf939bf14269f5fb] source-hash-dd1050b182260a26a1d0ba6d0ef3a6fecc3f4e07 git bisect skip a900e72b6357882284c5955bdf939bf14269f5fb # skip: [3dda83fc3a43afc6af7f5c0ffd029e610ec1b9a3] source-hash-c59b3d6c5c8096486730007d9b9b053793b90b1e git bisect skip 3dda83fc3a43afc6af7f5c0ffd029e610ec1b9a3 # bad: [4f705a8cfb1998b09f2062510b207d35a33647d8] source-hash-1eeb20f3958666ec6ba6e0fcf52e92e5eb447a14 git bisect bad 4f705a8cfb1998b09f2062510b207d35a33647d8 # bad: [3c72d6d27e2a0c420f74941355400b0834c550bb] source-hash-c30677731c55688c764a669ecea1b1c4d17ae57d git bisect bad 3c72d6d27e2a0c420f74941355400b0834c550bb # good: [92457a48f3715b1233ea025387627280dae681b0] source-hash-c1503da35d8879366da13258837cf0084a536809 git bisect good 92457a48f3715b1233ea025387627280dae681b0 # bad: [206506b5a81e183bfab960d6abe62489c8438daf] source-hash-47811d4cf17688b2db5910e2cd500143137fd6f1 git bisect bad 206506b5a81e183bfab960d6abe62489c8438daf # good: [65883fecdd4e5ccd4091d0089742690dccafdbfa] source-hash-8d8a2f2be58529d70f4783d5d1e91fca350f119f git bisect good 65883fecdd4e5ccd4091d0089742690dccafdbfa # skip: [c9046ea7e069426d10e071d0bcb01c64685844c6] source-hash-f5115e33e4c5e49e9b79ed32fccc193a99c3dc30 git bisect skip c9046ea7e069426d10e071d0bcb01c64685844c6 # good: [e2ef0c10eb06304986b8503584b44f02561ce4b5] source-hash-1b4aadebeb1898686313ff30ef47ddc4336a7444 git bisect good e2ef0c10eb06304986b8503584b44f02561ce4b5 # bad: [2d8ee8e5bf8901874460df1b36b3faceae1cb931] source-hash-777e3930a1e85b9bc97c1852b09802fc389c5e2d git bisect bad 2d8ee8e5bf8901874460df1b36b3faceae1cb931 # only skipped commits left to test # possible first bad commit: [2d8ee8e5bf8901874460df1b36b3faceae1cb931] source-hash-777e3930a1e85b9bc97c1852b09802fc389c5e2d # possible first bad commit: [c9046ea7e069426d10e071d0bcb01c64685844c6] source-hash-f5115e33e4c5e49e9b79ed32fccc193a99c3dc30
** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present on a currently supported version of LibreOffice (5.1.6 or 5.2.3 https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to "inherited from OOo"; 4b. If the bug was not present in 3.3 - add "regression" to keyword Feel free to come ask questions or to say hello in our QA chat: http://webchat.freenode.net/?channels=libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug-20170103
The behaviour as described is still present in the latest (5.2.3.3) version of LibreOffice (Mac OS 10.11.6).
Regression introduced in range https://cgit.freedesktop.org/libreoffice/core/log/?qt=range&q=1b4aadebeb1898686313ff30ef47ddc4336a7444..777e3930a1e85b9bc97c1852b09802fc389c5e2d
** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
Just confirmed: This problem is still present in version 6.1.1.2
*** Bug 126490 has been marked as a duplicate of this bug. ***
I don't know why bug 83568 was just See Also, when it seems to be the same. If you can explain the difference, set New again. All CC folks, please go to other bug. *** This bug has been marked as a duplicate of bug 83568 ***