[Libreoffice-bugs] [Bug 144300] Transpose above ~940 rows do not transpose

2021-09-05 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=144300

Roman Kuznetsov <79045_79...@mail.ru> changed:

   What|Removed |Added

 Resolution|--- |NOTABUG
 Status|NEEDINFO|RESOLVED

--- Comment #8 from Roman Kuznetsov <79045_79...@mail.ru> ---
(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.

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 144300] Transpose above ~940 rows do not transpose

2021-09-05 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=144300

--- Comment #7 from elias estatistics  ---
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

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 144300] Transpose above ~940 rows do not transpose

2021-09-05 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=144300

Roman Kuznetsov <79045_79...@mail.ru> changed:

   What|Removed |Added

 Ever confirmed|0   |1
 Status|UNCONFIRMED |NEEDINFO
 CC||79045_79...@mail.ru

--- Comment #6 from Roman Kuznetsov <79045_79...@mail.ru> ---
(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 receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 144300] Transpose above ~940 rows do not transpose

2021-09-05 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=144300

--- Comment #5 from elias estatistics  ---
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

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 144300] Transpose above ~940 rows do not transpose

2021-09-05 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=144300

Julien Nabet  changed:

   What|Removed |Added

 Ever confirmed|1   |0
 CC|serval2...@yahoo.fr |
 Status|NEEDINFO|UNCONFIRMED

--- Comment #4 from Julien Nabet  ---
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 are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 144300] Transpose above ~940 rows do not transpose

2021-09-05 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=144300

elias estatistics  changed:

   What|Removed |Added

 CC||elias__0...@yahoo.com

--- Comment #3 from elias estatistics  ---
Created attachment 174784
  --> https://bugs.documentfoundation.org/attachment.cgi?id=174784=edit
Two transpose commands - 1st dont Transpose, 2nd transpose ~982 rows

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 144300] Transpose above ~940 rows do not transpose

2021-09-05 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=144300

Julien Nabet  changed:

   What|Removed |Added

Summary|Transpose above ~1040 rows  |Transpose above ~940 rows
   |do not transpose|do not transpose

-- 
You are receiving this mail because:
You are the assignee for the bug.