As office suites evolve, more and more functionalities are proposed to
end-users. Regarding spreadsheets, the next Excel generation will propose around 16
billions of cells in one sheet !!
This is done through a 1 000 000 rows versus 16 000 columns sheet
Damned, who needs
so many numbers on one sheet ???
Anyway, if it is not enough, for you, powerfull end-users, OpenOffice.org
Calc spreadsheet can propose a little bit more with a matrix of 2 000 000
rows versus 32 000 columns
The last cell coordinates of this 64 billions set is
Formulas even work !
Nota : this is obviously a joke as
some minor polish remains to be done on this quick hack (Thanks to
Niklas Nebel for its pointers)
We are also waiting for the Office 12 file format to test the export
functionality and are actually thinking to a 1 000 000 000 rows
(Post originally written by Laurent Godard on the old Nuxeo blogs.)