[Libreoffice-bugs] [Bug 48456] New: : when searching for a number, the formatting of it is considered

[bugzilla-daemon at freedesktop.org]

https://bugs.freedesktop.org/show_bug.cgi?id=48456

             Bug #: 48456
           Summary: : when searching for a number, the formatting of it is
                    considered
    Classification: Unclassified
           Product: LibreOffice
           Version: LibO 3.4.4 release
          Platform: Other
        OS/Version: All
            Status: UNCONFIRMED
 Status Whiteboard: BSA
          Severity: normal
          Priority: medium
         Component: Spreadsheet
        AssignedTo: libreoffice-bugs at lists.freedesktop.org
        ReportedBy: philip_hoflack at hotmail.com


Created attachment 59669
  --> https://bugs.freedesktop.org/attachment.cgi?id=59669
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.

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.