[Libreoffice-bugs] [Bug 123865] Search for a cell used in a CALC formula should return also results in ranges

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #6 from steevie at gmail.com ---
Hi Heiko,

(In reply to Heiko Tietze from comment #5)
> 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

-- 
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/20190614/9ec3a990/attachment-0001.html>