4 ms·
My major frustration with Office products (Excel specifically) was the cell limits (size, #cols, #rows) that prevented me from managing large quantities of data
by r00fus 14y ago
My major frustration with Office products (Excel specifically) was the cell limits (size, #cols, #rows) that prevented me from managing large quantities of data (e.g.: Excel 2003 could only manage 65k rows - IIRC, in 2007 that increased to 2M, but even that's too little for some heavy applications).
Does LibreOffice have similar limts?
- chris_wot 14y ago1 million rows as of v3.3 http://www.libreoffice.org/download/3-3-new-features-and-fixes/ http://www.libreoffice.org/download/3-3-new-features-and-fix...
- TorKlingberg 14y agoIf you have that much data it may be time to look into an other solution. Matlab, Octave or Python+NumPy are popular in science.
- ganders 14y agoHave you seen powerpivot for excel? Bit off topic for this thread but allows you to work with biggish (>2m row) data sets through excel pivot tables
- forgottenpaswrd 14y agoIf you use so much data, forget about spreadsheets, learn numeric python and or R. If not you will be losing time every minute you spend in the spreadsheet.
- ars 14y agoSometimes you just want to quickly edit (not analyze) a large file.