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.
Created attachment 151908 [details] search_replace (In reply to Mark Ogilvie from comment #0) i can not reproduce with: Version: 6.2.4.2 (x64) Build ID: 2412653d852ce75f65fbfa83fb7e7b669a126d64 CPU threads: 4; OS: Windows 10.0; UI render: default; VCL: win; Locale: de-DE (de_DE); UI-Language: en-US Calc: > Given formula: =(I28-D29) for a single cell > 4. Enter Character "C" (for example) in Find box > 5. Enter Character "D" (for example) in Replace box Did you accidentally swap the steps 4/5?
Please be sure you have no marked 'Entire cell' under Find box.
Needinfo while we wait for a response to comment 1 and 2
Dear Mark Ogilvie, This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INSUFFICIENTDATA due to lack of needed information. For more information about our NEEDINFO policy please read the wiki located here: https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Status/NEEDINFO If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed. Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-NeedInfo-Ping
Dear Mark Ogilvie, Please read this message in its entirety before proceeding. Your bug report is being closed as INSUFFICIENTDATA due to inactivity and a lack of information which is needed in order to accurately reproduce and confirm the problem. We encourage you to retest your bug against the latest release. If the issue is still present in the latest stable release, we need the following information (please ignore any that you've already provided): a) Provide details of your system including your operating system and the latest version of LibreOffice that you have confirmed the bug to be present b) Provide easy to reproduce steps – the simpler the better c) Provide any test case(s) which will help us confirm the problem d) Provide screenshots of the problem if you think it might help e) Read all comments and provide any requested information Once all of this is done, please set the bug back to UNCONFIRMED and we will attempt to reproduce the issue. Please do not: a) respond via email b) update the version field in the bug or any of the other details on the top section of our bug tracker Warm Regards, QA Team MassPing-NeedInfo-FollowUp