| Summary: | : when searching for a number, the formatting of it is considered | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | philip_hoflack |
| Component: | Calc | Assignee: | Dennis Francis <dennisfrancis.in> |
| Status: | RESOLVED FIXED | ||
| Severity: | enhancement | CC: | andrew, bfo.bugmail, h3734236, jmadero.dev |
| Priority: | high | ||
| Version: | Inherited From OOo | ||
| Hardware: | Other | ||
| OS: | All | ||
| See Also: |
https://bugs.freedesktop.org/show_bug.cgi?id=52242 https://bugs.documentfoundation.org/show_bug.cgi?id=70142 |
||
| Whiteboard: | BSA target:5.1.0 | ||
| Crash report or crash signature: | Regression By: | ||
| Attachments: | A screenshot (I made sure the cell contains the value and not a formula) | ||
Confirmed with: LO 3.5.6.2 Build ID: own W7 debug build Windows 7 Professional SP1 64 bit Still confirmed, LibO: 3.6.3.2 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": http://cgit.freedesktop.org/libreoffice/core/commit/?id=9a85743766e8a063d20d5f93ee88758e243397f4 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: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. |
Created attachment 59669 [details] A screenshot (I made sure the cell contains the value and not a formula) Problem description: 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.