[Libreoffice-bugs] [Bug 97901] paste special with transpose activated fails with "not enough space on sheet"

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=97901

--- Comment #9 from Scito <info at scito.ch> ---
I've investigated this issue. All selected cells are taken into account. Also
the empty cells.

Steps to reproduce:

i) Copying columns:

1. Write 1 in cell A1.
2. Select column A.
3. Copy
4. Go to cell B1.
5. Paste
6. --> It works and 1 is in cell B1.
7. Go to cell C2.
8. Paste
9. --> Error "There is not enough space on the sheet to insert here"
10. Go to cell A2
11. Edit > Paste Special > Transpose
12. --> Error "There is not enough space on the sheet to insert here"

ii) The same is valid for copying rows.

20. Select column 1
21. Copy
22. Go to cell A2.
23. Paste
24. --> It works and 1 is in cell A2.
25. Go to cell B3.
26. Paste
27. --> Error "There is not enough space on the sheet to insert here"
28. Go to D1
29. Edit > Paste Special > Transpose
30. --> It works and 1 is in cell D1. (This case works as there are less cells
in a row than a column.

Copying everything is just copying columns (i.) and rows (ii.) combined.

Pasting with skip empty cells of Paste Special does not change the behavior.

The behavior of transposing seems consistent with the "normal" copy/paste. It
is not really an issue of transposing.

The solution is just to select and copy/paste/transpose the data that you want.

With the current design of rows and columns in LibreOffice, I think there is no
proper solution to this bug report (only for transposing). It would be a hack.

A proper solution should handle the cases in steps 9., 12., and 27. together
and keep the consistency.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210404/2e6f9d70/attachment.htm>