[Libreoffice-ux-advise] [Bug 149764] user-defined rows by columns (RxC, 2RxC/2, 4RxC/4, 8RxC/8, 16CxC/16)
https://bugs.documentfoundation.org/show_bug.cgi?id=149764 Heiko Tietze changed: What|Removed |Added Blocks||133764 --- Comment #6 from Heiko Tietze --- Couldn't find a ticket for the jumbo sheet itself (but a META ticket for remaining issues). WFMs for bug 133880 and bug 134362 could be DUP too. Bug 50916 requested "Allow more than 1024 columns in calc" (coming in 7.4). Feel free to reopen if you are aware of the feature and the question is about something different. UX-wise I recommend to use specialized software for large data sets, for example R. Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=133764 [Bug 133764] [META] Very large spreadsheets problem -- You are receiving this mail because: You are on the CC list for the bug.
[Libreoffice-ux-advise] [Bug 149764] user-defined rows by columns (RxC, 2RxC/2, 4RxC/4, 8RxC/8, 16CxC/16)
https://bugs.documentfoundation.org/show_bug.cgi?id=149764 m.a.riosv changed: What|Removed |Added Status|UNCONFIRMED |RESOLVED CC||miguelangelrv@libreoffice.o ||rg Resolution|--- |WORKSFORME --- Comment #5 from m.a.riosv --- Activating Menu/Tools/Options/LibreOffice/Advanced - Enable experimental features. You can activate Menu/Tools/Options/LibreOffice Calc/Defaults - Enable very large spreadsheets. At least since versions 7.3 -- You are receiving this mail because: You are on the CC list for the bug.
[Libreoffice-ux-advise] [Bug 149764] user-defined rows by columns (RxC, 2RxC/2, 4RxC/4, 8RxC/8, 16CxC/16)
https://bugs.documentfoundation.org/show_bug.cgi?id=149764 --- Comment #4 from Pierre Fortin --- (In reply to Rafael Lima from comment #3) > AFAIK LibreOffice Calc has a limit of 1,048,576 rows regardless if you > reduce the number of columns. Precisely! That's the issue this enhancement request is addressing. -- You are receiving this mail because: You are on the CC list for the bug.
[Libreoffice-ux-advise] [Bug 149764] user-defined rows by columns (RxC, 2RxC/2, 4RxC/4, 8RxC/8, 16CxC/16)
https://bugs.documentfoundation.org/show_bug.cgi?id=149764 --- Comment #3 from Rafael Lima --- AFAIK LibreOffice Calc has a limit of 1,048,576 rows regardless if you reduce the number of columns. -- You are receiving this mail because: You are on the CC list for the bug.
[Libreoffice-ux-advise] [Bug 149764] user-defined rows by columns (RxC, 2RxC/2, 4RxC/4, 8RxC/8, 16CxC/16)
https://bugs.documentfoundation.org/show_bug.cgi?id=149764 --- Comment #2 from Pierre Fortin --- I don't understand "n x m" -- are you implying this feature is already available? If so, I haven't found it... We have lots of data which produces 5M to 12M+ rows by up to 90-100 columns. Calc only allows 1M rows; so our data doesn't fit. I'm proposing a way to re-arrange the same 1Billion cells into different configurations so that we can use more of the available cells. Currently, we're using up to 100 columns which means 90%+ of the available cells can't be used. I should mention that my team uses filters extensively, so breaking up say 90 columns into multiple sheets (or multiple sets of columns on the same sheet) doesn't help. If this feature was available; we would likely leave Calc set to 16M rows by 128 columns. I am proposing a more universal Calc. Even more universal would also allow R/2x2C, R/4x4C, ... :) Even better, in a multi-sheet file, we could use: sheet1: 8RxC/8 or 16RxC/16 sheet2: RxC or another. ... If the total file size was limited to max 1B cells; that would be adequate... It's the current fixed 1Mx1024 that restricts us. Hope this helps... -- You are receiving this mail because: You are on the CC list for the bug.
[Libreoffice-ux-advise] [Bug 149764] user-defined rows by columns (RxC, 2RxC/2, 4RxC/4, 8RxC/8, 16CxC/16)
https://bugs.documentfoundation.org/show_bug.cgi?id=149764 --- Comment #1 from Heiko Tietze --- I don't understand you workflow. What hinders you do use n x m cells? -- You are receiving this mail because: You are on the CC list for the bug.
[Libreoffice-ux-advise] [Bug 149764] user-defined rows by columns (RxC, 2RxC/2, 4RxC/4, 8RxC/8, 16CxC/16)
https://bugs.documentfoundation.org/show_bug.cgi?id=149764 Telesto changed: What|Removed |Added CC||libreoffice-ux-advise@lists ||.freedesktop.org, ||tele...@surfxs.nl Keywords||needsUXEval -- You are receiving this mail because: You are on the CC list for the bug.