Description: ... overwriting the cell at the same position of the new sheet, while leaving the original cell unchanged. Steps to Reproduce: 1. Create a new spreadsheet, type "aaa" in A1 and "bbb" in A2. 2. Add a sheet named "Sheet2", type "ccc" in A1 but do not confirm the change (click elsewhere or press enter). 3. press Ctrl+H to open "Find and Replace" dialog, type "bbb" in "Find:", check "All sheets" and click "Find Next". Actual Results: Jumped to A2 of Sheet1, A1 of Sheet1 became "ccc", while A1 of Sheet2 remained blank. Expected Results: edit takes effect at A1 of Sheet2, then jumps to A2 of Sheet1. Sheet1 shouldn't change at all. Reproducible: Always User Profile Reset: Yes Additional Info: I believe this is a bug because: - This behavior is not seen in other office apps. - This can change the spreadsheet content unexpectedly, leading to data loss. Version: 7.5.5.2 (X86_64) / LibreOffice Community Build ID: 50(Build:2) CPU threads: 16; OS: Linux 6.4; UI render: default; VCL: kf5 (cairo+wayland) Locale: zh-CN (zh_CN.UTF-8); UI: zh-CN 7.5.5-1 Calc: threaded
Reproducible 'ccc' it's added in sheet1 instead of sheet2 Version: 24.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 58a4459627a92958ef133868f72af10d8d56ccad CPU threads: 16; OS: Windows 10.0 Build 22621; UI render: default; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL threaded
Type "ccc" in Sheet2.B1, and you will get "ccc" on Sheet1.B1. Version: 7.4.3.2 / LibreOffice Community Build ID: 40(Build:2) CPU threads: 1; OS: Linux 5.14; UI render: default; VCL: gtk3 Locale: es-MX (en_US.UTF-8); UI: en-US Calc: threaded