This is a read-only archive. Find the latest Linux articles, documentation, and answers at the new Linux.com!

Linux.com

Another Functions and formulas item

Posted by: Anonymous [ip: 69.76.168.112] on October 12, 2007 11:14 AM
I routinely create inordinately complex spreadsheets and formulas in them. (I am a programmer.) In excel, I often had to create 'boildown' columns that would have a 5-level equation each, and then another column acting on those boildown columns. This is because Excel limits the scope-level (the number of parenthesis deep that you can go) in equations. Earlier versions of Excel limited to 7 or 8 levels. 2000-2003 limited it to 15 levels. I have not yet found the limit if there is one in Calc. This is invaluable when you need to express complex equations and logic in the formulas of cells.

Also, Calc lets you save your work into a spreadsheet file format! Isn't that great! Excel only creates corrupt binary blobs (ew!).

#

Return to Office shootout: OpenOffice.org Calc vs. Microsoft Excel