[Libreoffice-bugs] [Bug 134724] UI - Find in Calc fails when a formula refers to a cell in another sheet's pivot table

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=134724

--- Comment #4 from Carl Pearson <librebugs at osxtra.dev> ---
Sure thing.

Try doing a regular Edit/Find for any value seen in the "Report" tab.

The issue seems to be that regular Edit/Find cannot "see" the result of
formulas which are themselves references to cells in another tab.

Searching via Edit/Find and Replace *does* work, if you change "Search In" from
"Formulas" to "Values".

Unfortunately, there is no way to switch between "Formulas" and "Values" in the
regular Edit/Find window, or in the find toolbar at the bottom, nor is there
(to my knowledge) a way to default Calc to search by values.

If it wouldn't break things, allowing regular Find to search both formulas
-and- values would seem to solve this issue.  Not sure what that would do to
performance though, as it may end up effectively searching twice.  Though
either way is pretty quick already, so that may not be too much of a hit.

Please advise if there's anything else you need.  Thanks for reaching out!
-- 
Carl

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200827/77d6abb8/attachment.htm>