Hi, when using filter, only the rows which match the filter are shown. Correct. But if I use the auto height feature (optimal row height) by double clicking on the column which contains the rows number (on the left), some of the filter-out rows are shown again. This is not correct. In the attached file there are four data rows and one header row. If I add a filter on the first column (Type) to select the rows which contains the value "A", the filter hide the row 4 which contains the value "B". The row with "B" is show again if I double click on the row dividers, even if the filter is in place !
Created attachment 45800 [details] ODS file to show the bug
[Reproducible] with reporter's sample document and "LibreOffice 3.3.2 – WIN7 Home Premium (64bit) German UI [OOO330m19 (Build:202 / tag 3.3.2.2)]". Also reproducible with my own documents. Steps to reproduce: 0. open sample document document 1. Click autofilter filter pulldown in 'B1' 2. Select filter for "AA" At least row 4 will disappear (additional rows depend on your search and filter settings) 3. Click common Row / Column Heading field to select all (or press <cntrl>+<a> 4. Right click on row heading "2" context menu appears 5. Click 'Optimal row height' expected: nothing than row height will change actual: invisible rows will become visible. The corresponding OOo issue is "Changing row height shows filtered rows" <http://openoffice.org/bugzilla/show_bug.cgi?id=35581> @Muthu: Your area?
Hi, I've found that the Microsoft Excel 2007 shows the same behaviour as the one reported in this bug. So may be Calc programmers have decided here to emulate Excel. In any case, it looks to me a very strange behaviour.
Yes, seems like it is done on purpose (as described in the OOo bugzilla/issuezilla). Maybe wait for more suggestions?
Old issue, also visible in OOo 3.1.1, 1.1.4 I really would be glad if LibO would stop to emulate EXCEL bugs ;-) Any Idea what for what the current should be useful? Why will row height be modified for rows hidden by filter, but modification of background, number format and others will not touch hidden rows? To me the current behavior seems to be without any logic. I can't read in OOo issues that the observed behavior might be intended.
@Rainer: Really no idea :) Maybe somebody else might know a better reason? Kohei or Eike maybe?
@kohei: Needinfo! Thank you :)
This bug hasn't seen any action. Switching ASSIGNED to NEW Muthu if you are still working on this, please re-assign yourself.
** 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 (4.4.2 or later) 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 your help! -- The LibreOffice QA Team This NEW Message was generated on: 2015-05-02
I confirm the bug (tested again on LO 4.4.2.2 on Windows 7) No changes in the behaviour.
*** Bug 74510 has been marked as a duplicate of this bug. ***
** 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-20161108
Still repro. Version: 6.0.0.0.alpha0+ Build ID: 5ea1b4c336d1cad92dc18e7cf7e4b381396f448b CPU threads: 4; OS: Linux 4.10; UI render: default; VCL: gtk3; Locale: de-DE (de_DE.UTF-8); Calc: group moggi's auto updater build, 2017-10-18
still repro in lo 6.1.0.2
repro in 7.0, is the filtration realized graphically? Version: 7.0.0.0.alpha1+ (homebrew) Build ID: 49fc4913ba7fc4a0be2e32407205edd8f31b3172 CPU threads: 8; OS: Linux 4.19; UI render: default; VCL: gtk3; Locale: de-DE (en_US.UTF-8); UI: en-US Calc:
Tünde Tóth committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/3678e0efcb8bedc58dd329a430da0ac3b1572df8 tdf#36383 sc AutoFilter: fix changing row height It will be available in 7.2.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Verified in: Version: 7.2.0.0.alpha0+ (x64) / LibreOffice Community Build ID: ea4fb1559f7b99a0bfaf18f26cb3b6972c9cde1c CPU threads: 4; OS: Windows 10.0 Build 17134; UI render: default; VCL: win Locale: hu-HU (hu_HU); UI: hu-HU Calc: threaded
Xisco Fauli committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/9e7f07dc1378354a5228898e339f8336bbbb41f3 tdf#144155: Revert "tdf#36383 sc AutoFilter: fix changing row height" It will be available in 7.3.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Xisco Fauli committed a patch related to this issue. It has been pushed to "libreoffice-7-2": https://git.libreoffice.org/core/commit/91eb9e16cd73df2249a24f949ea8bef62bbe2d09 tdf#144155: Revert "tdf#36383 sc AutoFilter: fix changing row height" It will be available in 7.2.2. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Xisco Fauli committed a patch related to this issue. It has been pushed to "libreoffice-7-2-1": https://git.libreoffice.org/core/commit/98a3abe58f13c875505fded61b4a39840600b3a3 tdf#144155: Revert "tdf#36383 sc AutoFilter: fix changing row height" It will be available in 7.2.1. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
See my comment for how to avoid the performance bottleneck at https://gerrit.libreoffice.org/c/core/+/112006/comment/772718de_430d7c4f/
Andreas Heinisch committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/3394e8746c505a8dae112f555cb2bb3e4596cbba tdf#36383 - sc AutoFilter: fix changing row height It will be available in 7.5.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Credits to Eike Rathke for his comments and help getting this patch merged.