Linked by David Adams on Tue 4th Dec 2007 19:39 UTC, submitted by michuk
Talk, Rumors, X Versus Y "It may be a brave opinion but I predict that Ubuntu Linux and Windows Vista are going to be the two operating systems that will take over the largest chunk of the desktop OS market during the next couple of years. This comparison is based on my experience with both systems during the last couple of weeks on two different computers."
Thread beginning with comment 288622
To view parent comment, click here.
To read all comments associated with this story, please click here.
RE[7]: Give it some time
by autumnlover on Wed 5th Dec 2007 01:06 UTC in reply to "RE[6]: Give it some time"
autumnlover
Member since:
2007-04-12

Well, there are still no real Excel alternative under Linux (see numerous issues with tables and graphs in OO's Calc, and those are only examples!), so I can not see the point of talking about alternatives of something so advanced like Autodesk software.

Reply Parent Score: 0

RE[8]: Give it some time
by evangs on Wed 5th Dec 2007 08:41 in reply to "RE[7]: Give it some time"
evangs Member since:
2005-07-07

OO's calc doesn't even do datedif. Seriously, wtf?

Reply Parent Score: 0

RE[9]: Give it some time
by lemur2 on Wed 5th Dec 2007 11:06 in reply to "RE[8]: Give it some time"
lemur2 Member since:
2007-02-17

OO's calc doesn't even do datedif. Seriously, wtf?


What is datedif?

PS: answering my own question:
http://www.cpearson.com/excel/datedif.aspx
"datedif ... is documented in the help file only for Excel 2000. For some reason, Microsoft has decided not to document this function in any other versions. DATEDIF is treated as the drunk cousin of the Formula family. Excel knows it lives a happy and useful life, but will not speak of it in polite conversation."

Not ever having run Excel 2000, I didn't know about datedif.

OK, it is apparently a "drunk cousin" undocumented function. Like, I should really rely on that.

In OO calc, if I have one cell with a date, and another cell with an earlier date, and I simply subtract the second cell value from the first, the answer I get is the number of days between those dates.

Isn't that what you want? Why would you need a special function for it? What exactly is wrong with simple subtraction?

OO calc handles dates way better than Excel, or OOXML in general.

In order to be compliant with OOXML, for example, you may not have any date before 1900.

Here is a shortened list of the aspects that OO calc handles far better than Excel:
http://en.wikipedia.org/wiki/OpenFormula#OpenFormula_Attributes

Imagine that ... getting mathematicians involved in designing the way that formulas worked. Imagine making a test suite so that you can check if your application is getting the right answers.

Who would have thought of that?

Certainly not Microsoft, apparently:
http://www.news.com/8301-13580_3-9784577-39.html

Edited 2007-12-05 11:21

Reply Parent Score: 6