Ask Your Question

Calc crashes when transposing

asked 2020-05-19 09:37:48 +0100

nonamed gravatar image

updated 2020-05-19 11:20:08 +0100

Hi! Is it a common problem? I have used both fresh and still versions and I have this issue: when I'm using transpose option (from Ctrl+Shift+V/Paste special menu) with 50-60+ raws it always crashes. With smaller number of raws (<50) it work fine.

EDIT: Windows 10 64 bit there's link to a raport after crash - maybe it would help a bit:

edit retag flag offensive close merge delete


Just checked - the range of 3 columns of 800 rows is transposed both through the PasteSpecial and through the formula {=TRANSPOSE(A1:C800)} well. What is your OS?

JohnSUN gravatar imageJohnSUN ( 2020-05-19 10:11:58 +0100 )edit

It was not worth writing in answer, you had to use a comment on the question or edit the text of the question. That was not the answer. Or maybe it was? The question "Why does the transpose not work" - the answer is "Because Windows" :-)

How many columns In your range? Did you try function TRANSPOSE() instead Copy-Paste?

JohnSUN gravatar imageJohnSUN ( 2020-05-19 11:01:47 +0100 )edit

Here: Win 10, LibO 6.4.3 (64 bit) "only" 4GiB RAM, a dozen tabs open in Firefox ,,, 3x1001 rows containing a simple formula (increment by 1 per row).
Transpose by PasteSpecial, values only: <1s.
Transpose by PasteSpecial, including the formulas: <1s (also correct "transposition" of the formula).
TRANSPOSE() with array-evaluation: <1s.
No errors at all.
May the user profile be corrupted?

Lupp gravatar imageLupp ( 2020-05-19 11:34:48 +0100 )edit

JohnSUN, sorry ;)

With single column it works fine up to 1024 limit. With 2 or more it crashes, even if second column is empty.

nonamed gravatar imagenonamed ( 2020-05-19 13:13:59 +0100 )edit

@nonamed , do you seem to have missed @Lupp's remark about the User Profile? In vain. Your problem may be with the Windows clipboard or with a corrupted User Profile.


See here - Wiki: LibreOffice user profile - for more details.

JohnSUN gravatar imageJohnSUN ( 2020-05-20 08:38:11 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2020-05-19 13:25:17 +0100

nonamed gravatar image

updated 2020-05-19 13:30:01 +0100

I found that transpose function works well when I completely remove the formatting - maybe this information will help someone or will be helpful for fixing this bug.

Best regards!

edit flag offensive delete link more
Login/Signup to Answer

Question Tools



Asked: 2020-05-19 09:37:48 +0100

Seen: 54 times

Last updated: May 19