<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_RESOLVED bz_closed" title="RESOLVED INSUFFICIENTDATA - Search for a cell used in a CALC formula should return also results in ranges" href="https://bugs.documentfoundation.org/show_bug.cgi?id=123865#c6">Comment # 6</a> on <a class="bz_bug_link bz_status_RESOLVED bz_closed" title="RESOLVED INSUFFICIENTDATA - Search for a cell used in a CALC formula should return also results in ranges" href="https://bugs.documentfoundation.org/show_bug.cgi?id=123865">bug 123865</a> from <a class="email" href="mailto:steevie@gmail.com" title="steevie@gmail.com">steevie@gmail.com</a> <pre>Hi Heiko, (In reply to Heiko Tietze from <a href="show_bug.cgi?id=123865#c5">comment #5</a>) > It's never to late (and Gmail also tags messages as spam for me with a > terrible workflow to deal with that). > > Your example seems a bit oversimplified. If you quick-search (Ctrl+F) for 5 > you get 5,15,45. To restrict the search, we have the Find dialog (Ctrl+H) > that offers a vast number of features including the checkbox in selection > only to get 5,15 when the data col is selected. The point is not to serach for a value (like you did with 5), but for a cell that is used in a formula. So E10 contains the sum of cells C5 to C10. If I search for C5 and C10, I obtain E10 as result because C5 and C10 are explicitly written there, but if I search for C6, C7, C8, or C9, no result is returned, although they are used to compute the result of the function in C10. Using advanced serch (CTRL+H) doesn't help either. I hope it's clearer now MfG, Stefano</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>