[Libreoffice-bugs] [Bug 121748] New: Feature request: look in values or comments when searching in Calc

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 121748
           Summary: Feature request: look in values or comments when
                    searching in Calc
           Product: LibreOffice
           Version: 6.2.0.0.beta1+
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: ddascalescu+freedesktop at gmail.com

Description:
Apologies if this has been requested already, since it's such a basic feature,
but searched have yielded nothing relevant[1].

Consider this sheet:

A1: foo
A2: bar
A3: ...
...
A181: =A1

Searching for "foo" will only find A1, but not A181. Excel has had this option
since I can remember (MS Office 2003): "Look in formulas/values/comments". In
Calc, it appears impossible to look in anything but formulas.


[1]:
https://bugs.documentfoundation.org/buglist.cgi?quicksearch=calc%20look%20in%20values&list_id=870950

Steps to Reproduce:
1. Create a sheet where A1 contains "foo" and A2 is "=A1".
2. Add a comment to A2, "foo".
2. Search for "foo".


Actual Results:
Only A1 is found.

Expected Results:
A1 and A2 should be found, if the user wishes to search in values or comments,
as opposed to searching only in formulas.


Reproducible: Always


User Profile Reset: No



Additional Info:
Basic feature in Excel.

-- 
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/20181128/00b833a3/attachment.html>