Calc crashes when transposing
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: https://crashreport.libreoffice.org/s...
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?
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?
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?
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 , 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.