Transpose above ~1040 rows do not transpose See attachment - Transpose thsi larga a1 table. Nothing happens! I search if Tranpose has any limit but in librecalc documentation did not find something relevant. Thereforem I filled that bug.
Sorry ~940 rows
I don't see any attachment here, could you please use this link: https://bugs.documentfoundation.org/attachment.cgi?bugid=144300&action=enter ?
Created attachment 174784 [details] Two transpose commands - 1st dont Transpose, 2nd transpose ~982 rows
Thank you for your feedback. I don't understand how does it work so I'll put back to UNCONFIRMED and uncc myself. Certainly someone may help here.
You click on a1 (yellow) to see the formula and then you can activate this formula as array "Ctrl + Shift + Enter." https://help.libreoffice.org/6.3/en-US/text/scalc/01/04060107.html?DbPAR=CALC
(In reply to elias estatistics from comment #5) > You click on a1 (yellow) to see the formula and then you can activate this > formula as array "Ctrl + Shift + Enter." > > https://help.libreoffice.org/6.3/en-US/text/scalc/01/04060107.html?DbPAR=CALC Your problem is you try to insert the formula for transpose 982 cells in AP column. AP column is 46th column. Calc allows you to use only 1024 column. So let's calculate 982+46=1028! It's bad Calc doesn't work silently of course. If you'll try insert your formula in AK column it will work as expected. Please try it and give us a feedback
You are right! This was! However, I find 1024 column limit very limited for a such application. Here, it says that libreoffice has experimental feature of "with 16k columns and 2m rows in upcoming version 7.0." Is it true? I wil search it. You may put "solved", however it must be an option "upgrade" or "Enhancement
(In reply to elias estatistics from comment #7) > Here, it says that libreoffice has experimental feature of > "with 16k columns and 2m rows in upcoming version 7.0." > > Is it true? Yes, today you can activate that feature, but it's still unstable and it's still in experimental status. You can try: 1. Enable experimental features in Tools-Options-LibreOffice-Advances 2. Restart LibreOffice and open Calc 3. Enable very large spreadsheet option in Tools-Options-LibreOffice Calc-Defaults 4. Restart Calc and try enjoy but you shouldn't have any surprises if Calc will work unstable > You may put "solved", however it must be an option "upgrade" or "Enhancement I think we should close this one as NOTABUG because you know where you was wrong in your case now.