https://bugs.documentfoundation.org/show_bug.cgi?id=150227
Bug ID: 150227 Summary: single quote (') is not working in Find and Replace in CALC Product: LibreOffice Version: 7.3.4.2 release Hardware: x86-64 (AMD64) OS: Windows (All) Status: UNCONFIRMED Severity: normal Priority: medium Component: Calc Assignee: libreoffice-bugs@lists.freedesktop.org Reporter: rajup...@rediffmail.com Description: single quote (') is not working in Find and Replace of LibreOffice CALC. If we try to replace cells having ' with BLANK , then the message "search text is not found" is received. This bug is still present in the latest version of LibreOffice also. Steps to Reproduce: 1. '123 2. '225 3. '427 Actual Results: FIND ' and REPLACE it with blank Result : "Search text is not found" This bug is present in the latest version also. Expected Results: '123 AIM :- To replace the leading ' with blanks and to find the SUM of them. '225 If we use "FIND and REPLACE" to clear ' the message is "SEARCH TEXT IS '427 NOT FOUND". Reproducible: Always User Profile Reset: Yes OpenGL enabled: Yes Additional Info: Definitely, this is a BUG , and is NOT corrected in the latest version also. If we check the data type of '123 in "Format" option in the cell that it contains, we can see it as a "Numeric Value" in the "TYPE" of the Cell. i.e., a non-numeric value in a numeric cell !! -- You are receiving this mail because: You are the assignee for the bug.