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@lists.freedesktop.org
Reporter: ddascalescu+freedesk...@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._______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
