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, Stefano (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.
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
Okay, makes sense to find A2 when searching for A1:A3. Sounds like a difficult thing.