Apache OpenOffice (AOO) Bugzilla – Issue 59229
Autofilter does not recognize added entries
Last modified: 2013-08-07 15:12:27 UTC
In a table, I added a couple of lines. When I select 'P' in the first column using Autofilter, it shows also Elements of type 'K'. I tried setting and removing printing areas etc, which didnt make any difference. Tried on SuSE 10.0 (SuSE 2.0-build) and Windoze XP (OO 2.0 build)
Created attachment 32300 [details] eample spreadhseet
If i load your testcase.ods, the Autofilter doesn't working correct. But if i: (a) copy & paste the content of your spreadsheet into a new spreadsheet (b) and create a Autofilter over columns 'A' until 'K', the Autofilter is working correct. Can you verify that? I'm using OO 2.0-dev.
Yes. even easier: removing autofilter and reapplying it. Expected bahaviour: Recognize immediately without bowing three times to east
But if i create a new spreadsheet with some elements (nearly the same like your sample sheet) and sort them with the Autofilter, the error doesn't occur. Can you write a step-by-step instruction for creating a "defect Autofilter" testcase?
Hm...I was wondering whether this is an issue that just comes up when converting an older sxc into ods Format. A quick test showed that it is not the case new spread, A1= Typ A2 = Test fill in column 1 the values A and B and '-' (minus). Fill column 2 with anything you like. Apply Auto-filter -> select for A (I think at this point I saved the sheet) now add some more rows (while selection is applied) -> Select 'All' then 'A' in Autofilter -> the new rows are not filtered Thats how it worked for me.
Hi, this is not a bug but logical. An autofilter has a defined Autofilter Database range. This range will be extended if you insert some rows above the last row of the autofilter. If you add additional lines after the last line of the filter range there is no way for the autofilter to know that you want it extended. So I close this Issue as invalid. Frank
closed invalid
Frank, I disagree with your opinion. It might be logical from a programmers point of view, but not from a user point of view. When I select 'All' in the autofilter it should work like a 'reset'. Means, when I next select 'A' it should take *all* rows into account. There is no reason to ommit the new ones. BTW, another well-known office package works exactly that way. So any user coming from this office package will state that OO 'does not work correctly'. IMHO, I dont think that this will increase OO's reputation. Please fix this bug. Thanks Axel
Not a defect as Calc needs it for now. But the enhancement is : Check for other possible solutions to use an Autofilter and the extension of it to cells added at the end of the old filterrange. Something for the requirements team. Frank
*** Issue 65857 has been marked as a duplicate of this issue. ***
Why the filter should have an end limit ??? Start point should be from the line immediately below the filter cell to end of the column, that's all. Why do you need to set a range ? I do use this feature at least 10 times an hour at work. This is really a showstopper.
Am I right if I guess that issue #85305 holds the path for this one?
Cor: although 85305 is more recent, it holds a patch and does target related problems. So I set this one as dup. *** This issue has been marked as a duplicate of 85305 ***
duplicate -< closed