Description: In the given file, selecting Optimal height for all rows fails for row below 12. (Selecting optimal height for rows 1-11 works as intended) Steps to Reproduce: 1. Open the attached ods file 2. Select all rows 3. Double-click on the row separator between 1 and 2 or Right-click on the Row numbers and select "Optimal height", and click Ok Actual Results: Below line 12 : Lines 1,2,6-11,12 that are empty or have one line of text, are correctly resized to one line height. Lines 3,4,5, that have more than one line of text, are resized to one line height. After line 12 : Lines 13 and 14, that have more than one line of text, are correctly resized so all the text is visible. Expected Results: All rows with more than one line of text should be resized correctly, so that all the text is visible. Reproducible: Always User Profile Reset: No Additional Info: I'm sorry having to said I didn't test on other versions. Package: libreoffice-calc Version: 1:6.0.3-0ubuntu1 Priority: optional Section: editors Source: libreoffice Origin: Ubuntu Maintainer: Ubuntu Developers <ubuntu-devel-discuss@lists.ubuntu.com> Original-Maintainer: Debian LibreOffice Maintainers <debian-openoffice@lists.debian.org> Bugs: https://bugs.launchpad.net/ubuntu/+filebug Installed-Size: 29,3 MB Depends: libreoffice-base-core (= 1:6.0.3-0ubuntu1), libreoffice-core (= 1:6.0.3-0ubuntu1), lp-solve (>= 5.5.0.13-5+b1), libc6 (>= 2.23), libetonyek-0.1-1, libgcc1 (>= 1:3.0), libicu60 (>= 60.1-1~), libmwaw-0.3-3, libodfgen-0.1-1, liborcus-0.13-0 (>= 0.13.3), librevenge-0.0-0, libstdc++6 (>= 5.2), libwps-0.4-4, libxml2 (>= 2.7.4), uno-libs3 (>= 5.3.0~alpha), ure Suggests: ocl-icd-libopencl1 Breaks: libreoffice-common (<< 1:5.4.1) Replaces: libreoffice-common (<< 1:5.4.1) Homepage: http://www.libreoffice.org Task: ubuntu-desktop, kubuntu-desktop, kubuntu-full, xubuntu-desktop, lubuntu-qt-desktop, ubuntustudio-desktop, ubuntukylin-desktop, ubuntu-mate-desktop, ubuntu-budgie-desktop Supported: 5y Download-Size: 7 049 kB APT-Manual-Installed: yes APT-Sources: http://fr.archive.ubuntu.com/ubuntu bionic/main amd64 Packages Version: 6.0.3.2 Build ID: 1:6.0.3-0ubuntu1 Threads CPU : 8; OS : Linux 4.15; UI Render : par défaut; VCL: gtk3; Locale : fr-FR (fr_FR.UTF-8); Calc: group
Created attachment 143750 [details] File that show the problem This file also contains, under "How to reproduce", various tests I made. Problem has happened on one file, I anonymised it and here it is, I'm not sure how to reproduce the problem from an empty file (there's something weird in the format of the 12th row, but I couldn't find what it is)
In a first view, from A to AMF the Alignment is Default-Top, from AMG to AMJ the Alignment is Default-Default. Restoring with Ctrl-M form AMG to AMG then seems optimal size for row works fine. But I don't know if it is really a bug or an incompatibility issue having styles with different options on the same row.
For the formatting it's possible, this file has been in other hands than mine ;) Note that just overwriting the cell A12 also solves the problem. Anyhow, if there are inconsistencies, LibreOffice should tell them to the user, shouldn't it ?
As Miguel thought this might not be a bug, I showed this to Eike. He says this works for him both with 6.0 and 6.1, so I am closing.