[Libreoffice-bugs] [Bug 125683] New: Find and Replace fails to detect specified search characters in Calc Formulas

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=125683

            Bug ID: 125683
           Summary: Find and Replace fails to detect specified search
                    characters in Calc Formulas
           Product: LibreOffice
           Version: 6.1.4.2 release
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: minor
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: mark.pcservice at gmail.com

Description:
LibreOffice Calc falsely reports "search key not found" when performing
character search and replace in formula in a cell.


Steps to Reproduce:
1. Select range of Calc cell(s) containing formula that needs changing
2. Click "Edit"
3. Click "Find & Replace
4. Enter Character "C" (for example) in Find box
5. Enter Character "D" (for example) in Replace box
6. Select "Current selection only"
7. Accept default radio button "Columns"
8. Accept default "Search in:" dropdown setting "formulas"
9. Click "Replace All" button

Actual Results:
"Search key not found"

Expected Results:
Given formula: =(I28-D29) for a single cell or range of cells, 
Find and replace function to search for "D" and replace it with "C"
Should yield a formula of =(I28-C29)


Reproducible: Always


User Profile Reset: No



Additional Info:
Environment:Libre Office Calc version: 6.1.4.2 (x64)
Build ID: 9d0f32d1f0b509096fd65e0d4bec26ddd1938fd3
OS: Windows 10 Pro version 1803, OS build 17134.765

Workaround: Manually change one cell and manually copy and paste formula to
selected range of cells.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190604/4e527ad2/attachment-0001.html>