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: [email protected]
Reporter: [email protected]
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
