Subject: bug 142565 Hello, I wanted to say version 7.1.4.2 has almost completely fixed [Windows Key] + V. Copying several items in a row for searching and pasting work much better. A thing that could still be improved is this. If I am working from a spreadsheet that has several separate sheets (pages) and I copy an entry from one page to paste in another, in a series of copied cells using the [Windows Key] + V, I must select the cell I want to paste into, click on it after I selected it, in order to avoid getting the message “the contents could not be pasted” and then paste. When the paste is completed, the cell becomes one line longer because the pasted material now contains a “return” and there is now a blinking cursor on the next line. I must then delete the “return” in order for the cell to go back to the correct size of only one line per cell. It would be good if the material could be pasted without having to select a cell, then click to activate the cell, then paste the material, then delete the extra cursor that the paste action created. Thanks for all your great work. David
This bug occurs when copying a few cells onto the clipboard, one after another, with the goal of searching for one of the items and then pasting others into nearby cells after doing a search. The items will be recalled from the clipboard using the [WindowsKey]+V combination. To recreate this bug do the following: 1. Create a new Calc spreadsheet. 2. In A1 enter a 1, in B1 enter a 2, in C1 enter a 3 3. In F15 enter a 1 4. Go to A1 and copy the 1 to the clipboard, Go to B1 and copy the 2 to the clipboard, Go to C1 and copy the 3 to the clipboard. 5. Click in the SEARCH or FIND area at the bottom left of the Calc window. 6. Using [Windows key]+V paste the 1 into the FIND window. Search for cells containing a 1. 7. When the search finds cell F15, click on G15, do [Windows key]+V and try to paste the 2 into G15. 8. The message appears “The content of the clipboard could not be pasted”. 9. Double click G15 to get a blinking cursor. 10. Using [Windows key]+V, paste the 2 into G15. The paste will work, but now there is a blinking cursor on a newly added second line. Delete the cursor and the second line will go away. 11. Ideally, a paste in G15 should be possible without having to double click it resulting a blinking cursor that must then be deleted.
repro in Version: 7.1.5.2 (x64) / LibreOffice Community Build ID: 85f04e9f809797b8199d13c421bd8a2b025d52b5 CPU threads: 4; OS: Windows 10.0 Build 19042; UI render: Skia/Vulkan; VCL: win Locale: en-US (en_US); UI: en-US Calc: CL
*** Bug 142565 has been marked as a duplicate of this bug. ***
I tried to reproduce this bug, but I don't understand how can I do this step: 4. Go to A1 and copy the 1 to the clipboard, Go to B1 and copy the 2 to the clipboard, Go to C1 and copy the 3 to the clipboard. I don't find the clipboard of Calc. I only succeeded to copy-paste, one element after another. Could you, please, specify precisely this step? Version: 7.1.0.0.alpha1+ (x64) Build ID: 738bcf5e9a8c443d60c29c3a8068e8c16c72638a CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: fr-FR (fr_FR); UI: en-US Calc: CL
The way it is working for Calc is: 1. Click on the formula bar inputwin, or enter edit mode ([F2]). 2. [WIN]+[V] 3. Click on the desired text to paste. 4. [ENTER]. I don't have to delete any LF or CR characters, but probably that depends on what exactly is being originally copied. Apparently, Calc is only supporting "unformatted text" in this mode. IDK whether there is some way to activate additional formats in general. IIUC, MSO supports more than just "unformatted text" for pasting from this mode of the Windows Clipboard. (In reply to Sophie Sipasseuth from comment #4) > I don't find the clipboard of Calc. > I only succeeded to copy-paste, one element after another. Windows 10+ includes an option to have a history of multiple clipboards. Press [WIN]+[V] to activate it (or search your Windows settings). Then [CTRL]+[C] should add copied items to the clipboard history instead of replacing the prior clipboard in memory. Then, instead of using [CTRL]+[V], use [WIN]+[V] in order to select what to paste.
(In reply to ady from comment #5) > Apparently, Calc is only supporting "unformatted text" in this mode. I should be more accurate. It is not really unformatted text, but rather the text with its formatting (e.g. bold). What it is not able to paste is a complete "cell" (or range of cells), but its content. For example, a cell's background color will not be pasted in this way.
Thanks, Ady for your help, Repro Version: 7.1.0.0.alpha1+ (x64) Build ID: 738bcf5e9a8c443d60c29c3a8068e8c16c72638a CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: fr-FR (fr_FR); UI: en-US Calc: CL Version: 7.2.8.0.0+ (x64) / LibreOffice Community Build ID: ffa09959edd087794b1f2fe6b9b6faac484ef74b CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: fr-FR (fr_FR); UI: en-US Calc: CL Version: 7.3.0.0.alpha1+ (x64) / LibreOffice Community Build ID: 229123ccc6f90ebf66b3e659bebbd53f8a9bdd3a CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: fr-FR (fr_FR); UI: en-US Calc: CL Version: 7.4.8.0.0+ (x64) / LibreOffice Community Build ID: f8ba7c6f77497e2dc7bfef8378511e2074ce01f9 CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: fr-FR (fr_FR); UI: en-US Calc: CL Version: 7.5.0.0.alpha1+ (X86_64) / LibreOffice Community Build ID: 1c629ca0048670db4bed5e7d8d76bcf8e81f2158 CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: fr-FR (fr_FR); UI: en-US Calc: CL threaded Version: 7.6.0.0.beta1+ (X86_64) / LibreOffice Community Build ID: 1b5cee822e0bc15ddbdfc86926678ca35ab3e082 CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: fr-FR (fr_FR); UI: en-US Calc: CL threaded