Description: If the cell B1 contains "=A1" value I can copy B1 to B2. And B2 will be "=A2". But if I continue copy it to the next cells (B3, B4, ...etc) - there will be the value of A2, but not "=Ax"(where 'x' is number of next cells - 3, 4, ...etc). Shortly. It copies only first link value. Steps to Reproduce: 1. In LO Calc open new spreadsheet. 2. Write 1 2 3 4 numbers in cells A1 A2 A3 A4 3. Set value of B1 to "=A1" 4. Set cursor to B1 and press Ctrl+C 5. Set cursor to B2 and press Ctrl+V 6. Set cursor to B3 and press Ctrl+V 7. Set cursor to B4 and press Ctrl+V Then check the values of B2 B3 B4. Cell B2 will have "=A2" value, B3 B4 will have value "2", but not "=A3" and "=A4" accordingly. I use Gentoo Linux, the bug is present. I cannot reproduce this on MS Windows (Copy-Paste of "link cells" is working correctly in Windows build). Actual Results: It doesn't copy link, but copies the value of the last cell for all next cells. Expected Results: It should copy link, not the value. Reproducible: Always User Profile Reset: Yes OpenGL enabled: Yes Additional Info: Version: 6.0.6.2 Build ID: Gentoo official package CPU threads: 4; OS: Linux 4.14; UI render: default; VCL: gtk3; Locale: en-US (en_US.utf8); Calc: group
no repro with Version: 6.0.6.2 Build ID: 0c292870b25a325b5ed35f6b45599d2ea4458e77 CPU threads: 8; OS: Linux 4.19; UI render: default; VCL: kde4; Locale: nl-BE (en_US.UTF-8); Calc: group
No repro. Linux Mint 19 Version: 6.2.0.0.alpha1+ Build ID: 1647bc1309dcd313dff2614f4844b71b1c558dee CPU threads: 2; OS: Linux 4.15; UI render: default; VCL: gtk3; Locale: en-US (en_US.UTF-8); Calc: threaded Given that two experienced triagers have not confirmed. I am setting this to WORKSFORME. Andrey - This can be moved back to UNCONFIRMED with the following additional information: (1) Is this a regression compared to older versions?; (2) Can you test daily build or at least beta of 6.2 to see if the problem still exists? (3) Please provide two sample files: -One with just A1-A4 and B1 filled in (through step 3) -One with all values filled in (all steps provided) Thank you!
Created attachment 146883 [details] Step 3
Created attachment 146884 [details] all-steps
(In reply to Joel Madero from comment #2) > This can be moved back to UNCONFIRMED with the following additional > information: > (1) Is this a regression compared to older versions?; > (2) Can you test daily build or at least beta of 6.2 to see if the problem > still exists? > (3) Please provide two sample files: > -One with just A1-A4 and B1 filled in (through step 3) > -One with all values filled in (all steps provided) > > Thank you! Thanks for reply! 1. I can say nothing about that. I didn't use it before. In Gentoo repositories there's one prebuild version available at this time -> https://packages.gentoo.org/packages/app-office/libreoffice-bin 2. No, I can't untill it appears at Gentoo repositories. However, I have opened bug in our local bugzilla -> https://bugs.gentoo.org/671530 but nobody replied yet... 3. Done. See attachments Step3 and all-steps
The Problem is solved by fresh login (deleting all dot files/folders in ~). So, not a bug.
Found the trick! KDE klipboard -> Options -> "Synchronize contents of the clipboards and the selection". When unchecked (default) it's all ok, else - the subj is. When I copy with that option it selects cell value and the selection overwrites link with first copied value.