<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEEDINFO " title="NEEDINFO - UI - Find in Calc fails when a formula refers to a cell in another sheet's pivot table" href="https://bugs.documentfoundation.org/show_bug.cgi?id=134724#c4">Comment # 4</a> on <a class="bz_bug_link bz_status_NEEDINFO " title="NEEDINFO - UI - Find in Calc fails when a formula refers to a cell in another sheet's pivot table" href="https://bugs.documentfoundation.org/show_bug.cgi?id=134724">bug 134724</a> from <a class="email" href="mailto:librebugs@osxtra.dev" title="Carl Pearson <librebugs@osxtra.dev>"> Carl Pearson</a> <pre>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</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>