I'm using LibreOffice 3.4.2. Using Calc's search-and-replace (Ctrl+Alt+F) dialog it was always possible to search all sheets in the document by pressing "more options" and activating the checkmark on the bottom "search in all tables" (not sure about the exact title of the checkmark - German localization: "in allen Tabellen suchen")
For some reason, the checkmark on the bottom appears to be ignored. Whether checked or unchecked - the search is only performed on the currently active sheet.
Reproducing is easy:
1. Open a new document
2. Enter "asdf" in A1
3. Activate Sheet2
4. Try Find-and-replace (Ctrl+Alt+F) to search for "asdf"
Whether the checkbox "in allen Tabellen suchen" is activated or not: LibO Calc 3.4.2 never seems to find the text.
(BW: Another faulty behavior also occured to me: The search never seems to include the current cell. In the above example, the search won't find "asdf" if cell A1 in sheet1 is marked. But that bug has been reported already.)
Thanks to the developers for their continued work!
Greeting from Germany,
Reproducible only if you have previously used the FindBar, for me. Probably related to Bug 33593.
Analogous bug in OOo:
See comment 8.
(In reply to comment #1)
> Reproducible only if you have previously used the FindBar, for me.
Yes, I agree.
That might be a very helpful observation.
When the FindBar hasn't been used yet, the Dropdown field "Find in" (German localization: "Suchen in") is preset to someting, e.g. "values". Once the FindBar has been used, the "Find in" field is preset to empty. Maybe the change to "values" or "formulas" is ignored?
Confirmed for LibreOffice 3.4 340m1(Build:103) on OpenSuse Linux.
On the English version the option is "Search in All Sheets". The search does not work across all sheets, and after the search and replace, the box automatically disables.
Confirmed with LibreOffice 3.4.2 on Windows XP X64, italian translation.
When opened and not already used the search bar (CTRL+F), the search dialog (CTRL+ALT+F) works and search all sheets if checked the checkbox.
When used after the search bar, the search dialog works only in the current sheet even when the "Search in all sheets" checkbox is activated.
It seems fixed on 3.4.3 RC1, probably by the same fix of Bug 33593.
I mark this bug as work for me for now.
I tested with LibO 3.4.3RC2.
Like Vitriol discovered on RC1, it seems to be fixed in 3.4.3.
Thanks a lot to you all!
Zdeněk Crhonek committed a patch related to this issue.
It has been pushed to "master":
uitest for bug tdf#39959
It will be available in 6.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:
Affected users are encouraged to test the fix and report feedback.