Apache OpenOffice (AOO) Bugzilla – Issue 108087
Find may not find hits in rows hidden by filter
Last modified: 2014-04-15 04:11:16 UTC
If you have a quick filter and selected something (quick filter is activ) and then you want to look up somethink (CTRL +F), you got find results also from hidden cells (don´t fit into filter). This is a big bug, because, if I see line 1,2,3 and 500,501,502 and find is looking also into 2xx, 3xx, 4xx and I see nothing. Only I know, that he is there. Calc should look up only in cells, that are SHOWN !
Actually I have a patch for this in Go-OO, and would be happy to upstream it if there is interest.
@kohei hopefully your suggested patch will not affect seaching via API (oSheet.createSearchDescritpor) ? i could imagine adding a new search option, for example "ignore hidden cells"
So, what's the use case for searching values in hidden cells, even from the API?
> even from the API? just a simple example: a sheet contains data organized like a database (each row is an entry). a macro will now search & replace all "XXX" with "YYY". But if a user has applied an autofilter before, the macro will fail to change all values now. a new search option will help to avoid this problem...
Will this bug or new find options be included in new release of OpenOffice 3.2 ? For me is this very high priority issue, because I need it for my work. Thanks
That makes sense. Perhaps I can add that option for the API.
>Will this bug or new find options be included in new release of OpenOffice 3.2 ? Not in the official version of OOo since we are waaaaaay past the feature freeze, but Go-OO 3.2 will have this enhancement.
Perhaps I can try this for 3.3.
re-priorizing this issue from P1 to P3
Ok. I forgot about this. Setting target to 3.4.
Created attachment 70126 [details] patch from ooo-build master
Created attachment 70127 [details] patch from ooo-build master
Created attachment 70128 [details] patch from ooo-build master (for the API portion)
Created attachment 70129 [details] patch from ooo-build master (for the API portion)
set target to 3.x since not release relevant for 3.4.
Reset assignee on issues not touched by assignee in more than 1000 days.
*** Issue 90901 has been marked as a duplicate of this issue. ***
*** Issue 92707 has been marked as a duplicate of this issue. ***
My patience is evanishing, I will no longer accept this bug in my daily work office suite knowing that alternative LibreOffice does not have this problem.
I don't think that this one depends on "Issue 49380 - enable find and replace buttons when 'Search For' box is empty" This one is not a trivial Enhancement, but a bug what makes Calc unusable (at least it's one of the reasons why I don't use it).