Description: "Find and Replace" replaces cells unintentionally. Cells that are different from the selection are replaced. This seems to happen when the search string is blank. It seems that replacement only occurs in columns that contain values. Steps to Reproduce: 1. Open the sample file. 2. Select the range of cells (here, B15-B20, etc.) 3. From the menu, select "Edit" - "Find and Replace" to display the dialog 4. Leave "Find" blank and enter 3, etc. for "Replace". 5. When you replace all, all the different cells (B3-E10 and A2) will be replaced. Actual Results: [Actual behavior] B3-E10 and A2 are replaced Expected Results: [Expected behavior] I want only the selected range to be replaced Reproducible: Always User Profile Reset: No Additional Info: Version: 24.8.2.1 (X86_64) / LibreOffice Community Build ID: 0f794b6e29741098670a3b95d60478a65d05ef13 CPU threads: 24; OS: Linux 6.8; UI render: default; VCL: gtk3 Locale: ja-JP (ja_JP.UTF-8); UI: ja-JP Calc: threaded
Created attachment 198133 [details] Here is a sample file with the steps to reproduce
Created attachment 198134 [details] No.1
Created attachment 198135 [details] No.2
Created attachment 198136 [details] No.3
Reproduced in the following environment Version: 24.8.3.2 (X86_64) / LibreOffice Community Build ID: 48a6bac9e7e268aeb4c3483fcf825c94556d9f92 CPU threads: 4; OS: Linux 5.10; UI render: default; VCL: gtk3 Locale: ja-JP (ja_JP.UTF-8); UI: en-US Calc: threaded The original report of this report is below: https://ask.libreoffice.org/t/libreoffice-calc/114699/5
Seems the issue is that, in Search&Replace dialog, the option for 'Current selection only' is not available if there is no data on the selected range. Version: 24.8.4.1 (X86_64) / LibreOffice Community Build ID: 1be9007f5d86a3741c366527d13e2970cbeef057 CPU threads: 16; OS: Windows 11 X86_64 (10.0 build 26100); UI render: Skia/Vulkan; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL threaded Inherited from OOo
For " doesn't allow to select 'Current selection only'" see https://bugs.documentfoundation.org/show_bug.cgi?id=124357
It seems to be the same problem with Writer and Calc, I think it is correct to close one of the two as a duplicate.
(In reply to m_a_riosv from comment #8) > It seems to be the same problem with Writer and Calc, I think it is correct > to close one of the two as a duplicate. I've seen that some bugs solved for Find & Replace have code special for Writer, in sw folder. We have to be sure in order to duplicate one of them.