Bug 113626 - Search not working with formula
Summary: Search not working with formula
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.2.4.2 release
Hardware: All All
: medium normal
Assignee: Jean-Sebastien Bevilacqua
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2017-11-03 13:00 UTC by Jean-Sebastien Bevilacqua
Modified: 2017-11-06 14:16 UTC (History)
0 users

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Jean-Sebastien Bevilacqua 2017-11-03 13:00:47 UTC 
Hello,

When you search a value in calc, you can check the "Formatted Display" checkbox.
Although this checkbox is checked, you can't find computed value of Formula.

Step to reproduce:

- Open a calc document
- In A1: =SUM(2+3)
- Ctrl-f (check formatted display)
- Search for 5

It can't find it.
Comment 1 Jean-Sebastien Bevilacqua 2017-11-03 13:12:09 UTC 
My patch here https://gerrit.libreoffice.org/#/c/44263
Comment 2 Jean-Sebastien Bevilacqua 2017-11-06 14:16:57 UTC 
It's possible to search for formula result with the find and replace popup.