Problem description: When applying an autofilter to a column and filtering all column items by a single entry, the result is not only all rows containing the selected entry but also some empty rows with very high row index (i.e. 1048576) Steps to reproduce: 1. Insert the text "show me" in the cell B2 2. Insert the text "don't show me" in the cell B3 3. Insert the text "show me" in the cell B4 4. Apply an autofilter to the column B and select "show me" Current behavior: Calc shows row 2 and row 4 with the text "show me" but also the row 1048576 with no text in cell B1048576. When the Autofilter-option is set to "All" and then the option "show me" is reselected, Calc shows also the empty row 1048573. Repeating this steps Calc continue to show more and more empty rows. Expected behavior: The empty rows should remain invisible. Platform (if different than the browser): Browser: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_7_2) AppleWebKit/534.51.22 (KHTML, like Gecko) Version/5.1.1 Safari/534.51.22
*** Bug 41836 has been marked as a duplicate of this bug. ***
NOT reproducible with "LibreOffice 3.4.3 - WIN7 Home Premium (64bit) German UI [OOO340m1 (Build:302)]" @baldinirobert@yahoo.it Please attach a sample document!
(In reply to comment #2) > NOT reproducible with "LibreOffice 3.4.3 - WIN7 Home Premium (64bit) German UI > [OOO340m1 (Build:302)]" > Reproduce with LibreOffice 3.4.3 - Windows Vista. To reproduce this bug, select the entire column and apply Autofilter. The bug is not reproduce selecting only a part of the column.
OS due to Comment 3 [Reproducible] with attached sample document and "LibreOffice 3.4.3 - WIN7 Home Premium (64bit) German UI [OOO340m1 (Build:302)]" It seems that the filter data range "__Anonymous_Sheet_DB__" becomes smaller with every new filter action, what is the main problem. Rows behind the last filter data range will be shown randomly after filter action. @sumuthu: Please feel free to reassign (or reset Assignee to default) if it’s not your area or if provided information is not sufficient. Please set Status to ASSIGNED if you accept this Bug. - Reported with Bug Submission Assistant -
Created attachment 52703 [details] Sample Document, see Comment 4
Same problem in Lib 3.4.4 RC1 and master under Ubuntu (10.04 x86_64) I do not use very much filter feature, but perhaps thise bug should be added to the list of most annoying bugs for 3.4? Best regards. JBF
@rainer: Can you verify once with the master builds as well, please? I tried to reproduce the problem on master, but was not able to. Is it specific to 3.4, please?
Some anonymous db issues were fixed recently. Maybe this ones already fixed? I guess, this one is for kohei?
> @rainer: Can you verify once with the master builds Both not up to date with source code: [Reproducible] with Server installation of Master "LibO-dev 3.5.0 – WIN7 Home Premium (64bit) English UI [(Build ID: d3d1481-3f8994a-2ba0a9f)]" (110909) [Reproducible] with parallel installation of MinGW Master "LibO-dev 3.5.0 – WIN7 Home Premium (64bit) English UI [(Build ID: 2ba5d12-e8c71c5-41e7bcd-4b83b90)] (daily/MinGW_cross-compilation2011-10-25_00.12.09)"
related to bug 42286, might be related to our unnamed db data work @Kohei: let us see what Pierre achieves with in the other bug report, otherwise we can have a look at it again
Reproduce with LibreOffice 3.3.3 and 3.3.4 under Windows XP SP 3; reproduce with LibreOffice 3.4.3 and 3.4.4 under Windows 7 SP1. Bernard Ribot
Created attachment 53536 [details] example
Let's get to the bottom of this.
Hello, I tested with the same spreadsheet shown in my attachment. It's now Ok (LO350rc2). Bernard
Works fine with "LibreOffice 3.4.5 German UI [Build ID: OOO340m1 (Build:502)]" parallel Server installation on German WIN7 Home Premium (64bit). Very new fix, did not come automatically with new autofilter design. 3.5.0 Beta1 still showed the problem, no longer a problem with 3.5.0 Beta3 Also ok with "LOdev 3.6.0alpha0+ English UI/Locale [Build ID: aa7e105-b2dd236-9eed775-d06f752-4dba2d1 (libreoffice-3-5-branch-point)]" {Win-x86@9-Voreppe Win32 pull time 2012-01-13 18:31:30}. OS: German WIN7 Home Premium (64bit) So I close this Bug because I do not think that there is a plan to cherrypick the fix to 3.4.6?!