4 ms·
LibreOffice has now left OpenOffice in the dust, and is a viable replacement of Microsoft Office for all but a tiny minority of users. LibreOffice Calc may not
by cs702 14y ago
LibreOffice has now left OpenOffice in the dust, and is a viable replacement of Microsoft Office for all but a tiny minority of users. LibreOffice Calc may not yet be as shiny as Microsoft Excel, but it works well and reliably -- I use it regularly with fairly large spreadsheets chock-full of array functions that manipulate vectors and matrices.[1]
--
[1] Yes, LibreOffice forumals can manipulate and return vectors and matrices, not just single values -- see https://help.libreoffice.org/Calc/Array_Functions#What_is_an_Array.3F https://help.libreoffice.org/Calc/Array_Functions#What_is_an...
- r00fus 14y agoMy 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.