Absurdism corner

Why?


  • Total voters
    196

FBnil

There is 1 impostor among us.
Joined
Dec 14, 2012
Messages
3,466
Location
Yurp
there is a large chasm in Brazil in Microsoft Flight Simulator.
You found the entrance to the inner earth!

Or maybe it's the abyss?
 
Last edited:

FBnil

There is 1 impostor among us.
Joined
Dec 14, 2012
Messages
3,466
Location
Yurp
Microsoft Excel - One millions rows should be enough for....


The Excel spreadsheet reached its maximum file size, which stopped new names being added in an automated process, the PA news agency understands.
The files have now been split into smaller multiple files to prevent the issue happening again.
So.. yeah. Why not CSV or XML? Who knows!



I compared MS Excel with LibreOffice, and they both still only offer only one million rows.




Excel Total number of rows and columns on a worksheet: 1,048,576 rows by 16,384 columns

LibreOffice same:
  • Maximum number of Columns per worksheet = 1024 (Col A to AMJ).
  • Maximum number of Rows per worksheet = 1,048,576 (2^20).
gnumeric.h does not go above 65536 rows :( but you can edit the constants and recompile your own version to have them:

Lines 8 and 9 of this file are:
#define SHEET_MAX_ROWS (16*16*16*16) /* 0, 1, ... */
#define SHEET_MAX_COLS (4*4*4*4) /* 0, 1, ... */

Google spreadsheet can lower the amount of columns to get more rows
Having 14 columns (A-M), the maximum row is 142 857, which is a total of 1 999 998 cells. cute.

Others I checked: Quattro Pro 2020 (could not find the data)
 

levi

Still fresh, damnit!
Joined
Oct 6, 2008
Messages
13,018
Location
Somewhere off the coast of the EU
Indeed. Why not a database? Or even a plain csv, or even as you suggest XML. Spreadsheets are for when you need live calculations on your data, and if you've more than a million lines of data setting one cell to be the multiplication of two other cells could be quite slow. But if you don't need that and all you actually need is being able to count rows, and you like the familarity of applications, make yourself familiar with a database.

In other news, I've just learned why Libreoffice always wants me to install Java. You can't make a new database in LibreOffice Base without java, at least you can make one but you can't add any data to it.
 
Top