Created attachment 193435 [details] Test file Hi there, I am not sure if my bug is the same as bug 158751, because the behaviour is slightly different in my own sheet (in a blank new sheet, the behaviour is the same as described in bug 158751) In my sheet, when I paste unformatted text into a merged cell, the new (copied) value is not displayed until I edit the cell (F2) or save the document again. Steps to reproduce: 1. open attached .ods file 2. Copy (CTRL+C) the cell L1 3. Paste unformatted text to merged cell L2:L3 (Menu/Edit/Paste Special/Paste unformatted text) Actual Results: In L2:L3 you still see value 200 € Expected Results: After Paste unformatted text in cell L2:L3 you should see the value 100 € immediately. Please take in note that: - the value in L2:L3 changes immediately (you can see the new value in the input line) but it is not displayed in the sheet itself... even if you move with the key arrows, you still see the value of 200 €, but in the input line you can see the value 100 €, - Recalculate (F9) makes no difference, - Hard recalculate (Menu/Data/Calcuclate/Recalculate hard) will make the change. I am pretty sure, this behaviour was not present in previous version of LO (think 7.4, or 7.3 worked well), but I am not sure, which version is affected as first one, as i use this kind of document only occasionally, but for years...
This is a visual issue. After pasting as unformatted text, you can scroll down (until the destination cell is not seen on screen) and up again; the new content will be seen on the cell (too). There are probably several similar reports. This can be reproduced since LO 6.0 (when Paste as unformatted text was introduced). Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 1344e6261a1d856c71eca1e0cc29215a586bf335 CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: en-US (es_AR); UI: en-US Calc: CL threaded
Thanks for the answer, but I do not agree that this is a permanent problem since LO 6.0 (although I can recall some behaviour of this in the very very past, but I think it has been resolved). As I wrote, I work with the same document template for years, at least 1x per year quarter, but also through the year when making some chanhes. At the beginning of January 2024 I did not have this problem and I am absolutely sure that I was using paste unformatted text into merged cells. I am also sure, I did not have this problem through all the year 2023 and probably also 2022.
I opened attachment 193435 [details] using several different minor release versions of several branches (7.6, 7.5, 7.4, 7.3, 6.0, 5.4, 5.0, 3.3, and I might be forgetting some other test). My comment 1 reflects (in short) what I saw as the result of my tests. I also reported the simplest way I could refresh the screen in that test, so it can be confirmed that the problem is _visual_, not about actual calculation updates nor about saving the value. Maybe this visual issue happens under some particular conditions/settings but not under other settings. Other volunteers might test and report a different result. That is the reason to include the Help > About version info I posted. Please feel free to test and report any relevant feedback. For each test, please include the "Help > About" version info – the icon in that dialog allows to copy the info to the clipboard, so you can paste it here in a new comment. If someone knows of some other report that would reflect the same visual problem, this report might be set as dupe, or at least as "See also".
Thank you for submitting this bug. I can confirm that it is present in Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: a2265e8faa099d9652efd12392c2877c2df1d1eb CPU threads: 8; OS: Windows 10.0 Build 19045; UI render: default; VCL: win Locale: en-US (en_US); UI: en-US Calc: threaded as well as Version: 24.2.1.2 (X86_64) / LibreOffice Community Build ID: db4def46b0453cc22e2d0305797cf981b68ef5ac CPU threads: 8; OS: Windows 10.0 Build 19045; UI render: default; VCL: win Locale: en-US (en_US); UI: en-US Calc: threaded
No repro Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: f3d0a184c4da57907a1fcf1ed784340be7d974d6 CPU threads: 4; OS: Linux 6.5; UI render: default; VCL: gtk3 Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US Calc: threaded Jumbo Probably windows issue.
For windows, I can reproduce this bug at the earliest on: Version: 6.4.7.2 (x64) Build ID: 639b8ac485750d5696d7590a72ef1b496725cfb5 CPU threads: 8; OS: Windows 10.0 Build 19045; UI render: GL; VCL: win; Locale: en-US (en_US); UI-Language: en-US Calc: CL I could also reproduce this bug all the way up to (and versions in between): Version: 24.8.0.0.alpha1+ (X86_64) / LibreOffice Community Build ID: ae798781ef4df7a1fdef13af0bc459bf4f6e7b4c CPU threads: 8; OS: Windows 10 X86_64 (10.0 build 19045); UI render: Skia/Raster; VCL: win Locale: en-US (en_US); UI: en-US Calc: CL threaded As noted, I could not reproduce on versions before 6.0 since the “paste unformatted text” feature is not available. Also if you double click the merged L2:L3 cells after pasting, the new value will show correctly. I thought this was a Windows only bug, but after testing on several Linux versions I was able to reproduce it on: Version: 6.4.7.2 Build ID: 639b8ac485750d5696d7590a72ef1b496725cfb5 CPU threads: 8; OS: Linux 6.5; UI render: default; VCL: gtk3; Locale: en-US (en_US.UTF-8); UI-Language: en-US Calc: threaded For later versions on Linux (for example Ver: 7.3.7.2 & later) the bug was not reproducible.