Version: 5.1.2.2 x86 Build ID: d3bf12ecb743fc0d20e0be0c58ca359301eb705f CPU Threads: 8; OS Version: Windows 6.1 x64; UI Render: default; Locale: de-DE (de_DE) A little bit complicate but with the attachement hopefully reproducable. Problem Statement: If you have in a Calc sheet a List Box as Form Control, which is anchored in a cell, and this cell is part of a group, which you can colapse and expand with the + and – icons on the left side, the hight of such a list box is not correctly expanded again (the hight is sero, so that it is displayed as a line) after colapsing and saving and reopening and expanding the group. This behaviour occurs reproducable, if the height of the listbox is less then the heigt of the cell (or precise of the row, because every cells of the row does have the height of the row). Steps to reproduce There are two files, one with a listbox with a height less than the cell height (TestGruppierungMITProblem) and one without the issue (TestGruppierumgOHNEProblem) because the height is a little bit higher than the cell height. 1. Open the file TestGruppierungMITProblem and see the sheet with grouped rows 6 to 14 but not collapsed and the listbox anchored in cell E11 with a height less than the cell. 2. Collapse the group with hitting on the – icon on the left. 3. Save the file. Close the file. 4. Reopen the file, expand the group with hitting on the +-icon 5. The listbox seems to be gone, but if you look for a line you can see that the listbox is still collapsed with the height 0 and appaers like a line. If you click on it in the Design mode you can verify and expand the heigt manually. Expected behaviour See the file TestGruppierumgOHNEProblem with the same listbox but with a height a little bit bigger than the row height, do the same actions like above, the listbox is correctly collapsed and expanded after the actions saving, closing, reopening, expanding as described above. Puuh, hopefully it is understandable, if not, give me a question in a comment.
Created attachment 124687 [details] calc with a listbox with the problem after reopening
Created attachment 124688 [details] Calc with a listbox without the problem because of the height
Repro with file. Has it always behaved like this? Btw. there are other reports with group collapsing weirdness. 64-bit, KDE Plasma 5 Build ID: 5.1.2.2 Arch Linux build-1 CPU Threads: 8; OS Version: Linux 4.5; UI Render: default; Locale: fi-FI (fi_FI.UTF-8) Arch Linux 64-bit, KDE Plasma 5 Version: 5.2.0.0.alpha1+ Build ID: 540fee2dc7553152914f7f1d8a41921e765087ef CPU Threads: 8; OS Version: Linux 4.5; UI Render: default; Locale: fi-FI (fi_FI.UTF-8) Built on April 30th 2016
** 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.2.7 or 5.3.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-20170522
Still present and confirmed for Version: 5.3.3.2 Build-ID: 3d9a8b4b4e538a85e0782bd6c2d430bafe583448 CPU-Threads: 8; BS-Version: Windows 6.1; UI-Render: Standard; Layout-Engine: neu; Gebietsschema: de-DE (de_DE); Calc: single
Dear riesslibo, 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
The error still exists in Version: 7.1.0.0.alpha0+ (x64) Build ID: 37081085fa989aa2fd07a7a0d063295819e185a0 CPU threads: 8; OS: Windows 10.0 Build 19041; UI render: Skia/Raster; VCL: win Locale: de-DE (en_US); UI: en-US Calc: threaded I'm working on a fix, but it will take same time. The solution requires larger changes in the code.
Should be fixed with https://cgit.freedesktop.org/libreoffice/core/commit/?id=1f0b3c7a40edfa81bbc7a58d123a6a2dfd83e4ca (The patch covers several bug reports, therefore no automatic notification.)
Verified Arch Linux 64-bit Version: 7.1.0.0.alpha1+ Build ID: 2764c334c3b9cf428e4e7ab0c28ce6a34036fa77 CPU threads: 8; OS: Linux 5.9; UI render: default; VCL: kf5 Locale: fi-FI (fi_FI.UTF-8); UI: en-US Calc: threaded Built on 2 November 2020