Currently, if I am searching for a cell used in a formula does not return intermediate cells within a range. Probably easier explained with an example.
Suppose in cell E10 you have formula =SUM(C5:C10). If you search (CTRL+F) for C5, then E10 is returned as result (E10 cell is highlighted), whereas if you search for C6, no result is returned. I am not sure if this behaviour is intended, but it would be more correct to search also within ranges (perhaps as an advanced option).
Please attach a simple example.
Sorry, I cannot follow the problem and apparently neither other people.
> Sorry, I cannot follow the problem and apparently neither other people.
Heiko, I am sorry, but I never received a notification of your first comment. Is it too late to add an example?
Thanks for your patience,
(In reply to Heiko Tietze from comment #2)
Created attachment 151804 [details]
This spreadsheet shows the problem exposed in my bug report
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.
(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
Okay, makes sense to find A2 when searching for A1:A3. Sounds like a difficult thing.