Bug 97901 - paste special with transpose activated fails with "not enough space on sheet"
Summary: paste special with transpose activated fails with "not enough space on sheet"
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All All
: medium normal
Assignee: Not Assigned
Depends on:
Blocks: Paste-Special
  Show dependency treegraph
Reported: 2016-02-16 14:03 UTC by documentfoundation
Modified: 2020-05-19 09:18 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

400x100 sized example ods for MWE (156.69 KB, application/vnd.oasis.opendocument.spreadsheet)
2016-02-16 14:03 UTC, documentfoundation

Note You need to log in before you can comment on or make changes to this bug.
Description documentfoundation 2016-02-16 14:03:16 UTC
Created attachment 122688 [details]
400x100 sized example ods for MWE

paste special with transpose activated fails with "There is not enough space on the sheet to insert here" for moderate-size tables (400x100 and transposed). There is enough space, especially it stays within the 1024 column limit and non-transposed paste works.

MWE: open attached ods, select all, cut table, paste special with transpose activated.
Comment 1 Buovjaga 2016-02-17 12:41:35 UTC

Win 7 Pro 64-bit Version:
Build ID: a6f876d45bd4e41a7143594a6cb11b6893a0f620
CPU Threads: 4; OS Version: Windows 6.1; UI Render: default; 
TinderBox: Win-x86@39, Branch:master, Time: 2016-02-11_00:07:38
Locale: fi-FI (fi_FI)
Comment 2 QA Administrators 2017-03-06 15:20:32 UTC Comment hidden (obsolete)
Comment 3 documentfoundation 2017-03-06 17:35:15 UTC
still present in debian-stretch's lo
Comment 4 QA Administrators 2018-07-12 02:44:35 UTC Comment hidden (obsolete)
Comment 5 documentfoundation 2020-05-15 13:28:38 UTC
I can't reproduce this bug anymore. 

Build ID: 1:6.4.4~rc1-1
CPU threads: 6; OS: Linux 4.19; UI render: default; VCL: x11; 
Locale: de-CH (en_DK.UTF-8); UI-Language: en-US
Calc: threaded
Comment 6 Mehrad Mahmoudian 2020-05-19 08:49:01 UTC
I just faced it. What I have is a file with 36 cols and 14 rows. When I do Ctrl + A and then copy and go to another sheet and paste special with transpose I get the error, but when I manually select the range of the cells that are not empty (36x14) I can paste it transposed. I guess something is wrong with Calc understanding the "area of interest".

Build ID: 747b5d0ebf89f41c860ec2a39efd7cb15b54f2d8
CPU threads: 8; OS: Linux 4.15; UI render: default; VCL: gtk3; 
Locale: en-US (en_US.UTF-8); UI-Language: en-US
Calc: threaded
Comment 7 Buovjaga 2020-05-19 09:18:19 UTC
Yeah, I actually still repro with attachment 122688 [details]

Arch Linux 64-bit
Build ID: bdc8cd060dca8a97ef7970d1c0ab30694930beea
CPU threads: 8; OS: Linux 5.6; UI render: default; VCL: kf5; 
Locale: en-US (fi_FI.UTF-8); UI: en-US
Calc: threaded
Built on 14 May 2020