Bug 123865 - Search for a cell used in a CALC formula should return also results in ranges
Summary: Search for a cell used in a CALC formula should return also results in ranges
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.2.0.3 release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Find-Search Cell-Formula
  Show dependency treegraph
 
Reported: 2019-03-05 10:36 UTC by steevie
Modified: 2019-08-29 22:09 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:
Regression By:


Attachments
This spreadsheet shows the problem exposed in my bug report (9.55 KB, application/vnd.oasis.opendocument.spreadsheet)
2019-05-31 12:21 UTC, steevie
Details

Note You need to log in before you can comment on or make changes to this bug.
Description steevie 2019-03-05 10:36:43 UTC
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).
Comment 1 Heiko Tietze 2019-04-17 10:40:33 UTC
Please attach a simple example.
Comment 2 Heiko Tietze 2019-05-28 08:35:13 UTC
Sorry, I cannot follow the problem and apparently neither other people.
Comment 3 steevie 2019-05-28 12:46:58 UTC
> 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)
Comment 4 steevie 2019-05-31 12:21:30 UTC
Created attachment 151804 [details]
This spreadsheet shows the problem exposed in my bug report
Comment 5 Heiko Tietze 2019-06-01 07:23:16 UTC
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.
Comment 6 steevie 2019-06-14 14:24:41 UTC
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
Comment 7 Heiko Tietze 2019-06-18 13:07:07 UTC
Okay, makes sense to find A2 when searching for A1:A3. Sounds like a difficult thing.