Created attachment 59669 [details]
A screenshot (I made sure the cell contains the value and not a formula)
When I search for "65.536" (European format, so it means sixty-five thousand five hundred thirty six) it cannot find 65.536 (the same number as it is shown in the spreadsheet) I have to search for 65536 in order for it to find the number, even though I got the "65.536" string I initially searched by copying the value of the cell which contains 65536.
Steps to reproduce:
1. type 65536 in a cell
2. make sure the formatting of the cell is set to "-1.234", so that it will show 65536 as 65.536
3. copy the content of the cell
4. paste it in the search box
5. search for the number
Current behavior: LibreOffice cannot find the number pasted in the search box
Expected behavior: LibreOffice finds the number
Platform (if different from the browser):
Browser: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:11.0) Gecko/20100101 Firefox/11.0
I use the dutch version of LibreOffice.
Build ID: own W7 debug build
Windows 7 Professional SP1 64 bit
Still confirmed, LibO: 220.127.116.11
Marking as NEW and prioritizing:
Enhancement: This apparently is acting like it's supposed to but your suggestion makes sense, marking as a enhancement
High: Seems like a lot of users could benefit from this (anyone who uses number formatting + find feature). Should be able to search for things the same way that they look. Lastly, I doubt it'll be a very hard hack (probably not an easy hack but not incredibly difficult)
Submitted a patch at https://gerrit.libreoffice.org/#/c/19420/
Dennis Francis committed a patch related to this issue.
It has been pushed to "master":
tdf#48456 : when searching for a number, consider formatting
It will be available in 5.1.0.
The patch should be included in the daily builds available at
http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
Affected users are encouraged to test the fix and report feedback.
*** Bug 97434 has been marked as a duplicate of this bug. ***