Slashdot Mirror
Office 2007SP2 ODF Interoperability Very Bad
David Gerard writes "Microsoft Office 2007 SP2 claims support for ODF 1.1. With hard work and careful thinking, they have successfully achieved technical compliance but zero interoperability! MSO 2007sp2 won't read ODF 1.1 from any other existing application, and its ODF is only readable by the CleverAge plugin. The post goes into detail as to how it manages this so thoroughly."
Sun's ODF plugin for Office.
My ism, it's full of beliefs.
this is how
Kind of looks like the whole thing was a farce to begin with given how they created a bad spec and then went on to support a worse one before imploding.
"You're right," Fisheye says. "I should have set it on 'whip' or 'chop.'"
Microsoft Windows is POSIX.1 compliant, which will not help anyone today but which is nonetheless true.
"You're right," Fisheye says. "I should have set it on 'whip' or 'chop.'"
ODF does not specify the a language for formulas. Everybody but MS uses one language, MS uses another. Of course there are incompatibilities.
Why did ODF not specify a spreadsheet formula language?
Go green: turn off your refrigerator.
And the problem in this case is the missing formula specification. It's not in ODF 1.1, and ODF 1.2 is still a draft. While this is Microsoft and we all "know" that this was intentional, ODF is what should be fixed first. We were all bashing OOXML specifications, but ODF 1.1's far from perfect, as we can see.
That is, curiously, not quite true. ODF 1.1 doesn't fully specify formulas, but it does specify the general syntax that should be used for them, and Microsoft seems to have ignored this. (Also, in practice, the major spreadsheets are quite similar in terms of what expressions they accept in formulas. This makes it relatively simple to convert between MS Office formulas and OpenOffice.org ones, which are what most ODF-based apps use.)
nobody would have believed that Microsoft was the good guys.
Actually there was a time when Microsoft was hailed as the white knight in the shiny armor freeing us from the evil IBM empire.
Well if you just go for the basic level of posix support, then yes it does support it. So does 100 other OSes, including weird embedded OSes that can't even run executables. Everything has to be compiled in, but they are "POSIX" too.
To be far UNIX Services for Windows is pretty decent and gives you a very complete POSIX environment on Windows.
“Common sense is not so common.” — Voltaire
Interesting. According the article referenced in the Wikipedia even OpenOffice and KOffice don't get along.
You don't know what you don't know.
People like to continue to whine about how MS must be evil. As you said, ODF 1.2 isn't finished. Who wants to target a moving standard? On the other hand, I've found that SP2's ODT support is quite good, to the point that I find I no longer need OpenOffice to open older files I have in that format. Even some complicated ones with equations and images.
From the article:
The irony here is that the formula language used by OpenOffice (and by other vendors) is based on that used by Excel, which itself was not fully documented when OpenOffice implemented it. So an argument, by Microsoft, not to support that language because it is not documented is rather hypocritical. Excel supports 1-2-3 files and formulas and legacy Excel versions (back to Excel 4.0) neither of which have standardized formula languages. Why are these supported? Also, the fact that the Microsoft/CleverAge add-in correctly reads and writes the legacy ODF formula syntax shows not only that it can be done, but that Microsoft already has the code to do it. The inexplicably thing is why that code never made it into Excel 2007 SP2.
"...1 second or so that it took to open the "Save file as" dialog..."
It takes 2 seconds for a menu to appear on my work XP laptop when I click the Start button. It takes forever to open a Word document. Virus scanning is now part of the Office experience and can't be disregarded. And this is on a more modern computer. What is your point.
Åpne dokumentstandarder blir obligatoriske i staten.
My rough translation from Norwegian:
- Norway has so far lacked a policy regarding the area of software. This have now changed. This Cabinet has decided that IT-development in the public sector shall be based upon Open Standards. In the future we will not accept that State activities locks users of public information to Locked Formats. - Heidi Grande Røys (Minister of Government Administration and Reform).
Microsoft might play their games to hinder development as much as they can, but at least in this country the turn towards Open Standards seems inevitable.
The Long Now Foundation
Actually there was a time when Microsoft was hailed as the white knight in the shiny armor freeing us from the evil IBM empire.
I've heard this said, but somehow I managed to miss it. I started work in the industry in 87, and had first encountered microsoft probably in 84. Outside of ziff-davis style vanity press, everything about MS was about what crap they were technically and ethically. The white knights were DEC, BSD, Borland, Commodore, ...
It was pretty obvious to many techies by the early 90s that Microsoft software was crap. The printed press was one of its tools and perpetuated the myth that companies would be better off with Microsoft. By 1995 it was getting out to a more general crowd how bad Microsoft was but these people still required having their eyes and minds open. Considering where they are today, it's obvious many are still pretty ignorant to their business practices and technology in general. By 1995, even the author, Douglas Adams saw this:
Microsofthttp://www.gksoft.com/a/fun/dna-on-microsoft.html
Here's a quote from the end of that short article:
"The idea that Bill Gates has appeared like a knight in shining armour to lead all his customers out of a mire of technological chaos neatly ignores the fact that it was he who by peddling second-hand, second-rate technology, led them all into it in the first place."
Over $200 million in marketing spent on Window 95 and about the same amount the following year pushing NT as _the_ server OS suckered in enough to seal their position in the market. That seal is leaking now but unfortunately, the general population of computer users and IT execs are mostly just as naive as they were in the early 1990s. It's the OEM's who are driving the market now because of very low margins and the high relative cost of Microsoft software.
LoB
"Anyone who stands out in the middle of a road looks like roadkill to me." --Linus
Microsoft's supposed ODF 1.1 spreadsheet output is not compliant with the ODF 1.1 specification.
From 8.1.3 (emphasis mine):
From 8.3.1 Referencing Table Cells (emphasis mine):
Now look at a Microsoft formula in their ODF 1.1 spreadsheets. You'll see a formula attribute value of "msoxl:=B4-B3". For that to be correct per the ODF 1.1 specification, that should be "msoxl:=[.B4]-[.B3]". Compare this to the OpenOffice.org and OpenFormula syntax:
msoxl:=[.B4]-[.B3]
oooc:=[.B4]-[.B3]
of:=[.B4]-[.B3]
Ignoring the prefix, they're identical. Furthermore, the formula functions used by OpenOffice.org are generally based on the functions in Excel to begin with (such as "TODAY", for example), so I can only conclude that Microsoft is intentionally sabotaging interoperability to keep people from using ODF while still claiming conformance.
On the contrary, it does make sense to alter them because there is something wrong with Microsoft's formulas. For example, consider the MAX() function in Excel:
Now consider the OO.o (and forthcoming ODF 1.2 standard) equivalent:
OO.o uses semicolons instead of commas to separate parameters; so what? Well, let's what would happen if you were European, and tried to do the same thing in Excel:
Uh-oh! Now, since Europeans use commas instead of periods to indicate decimals, Excel suddenly thinks that there are 8 integer parameters instead of 4 decimal ones! Excel is wrong! In contrast, here's how it looks in OO.o:
Hey, whaddya know: still four decimal numbers! It works!
But that's just the tip of the iceberg. If you read previous posts in the linked blog, the guy points out how (for example) most of Excel's date and financial functions are wrong (not just because of syntax, but because they implement the wrong algorithms).
Actually, it does -- 300-odd pages worth of one, in fact. But Excel doesn't follow that either!
In fact, those date and financial functions tend to give answers different from both the OOXML standard and the original financial standards they are supposed to be based on!
"[Regarding the 'cloud,'] ownership was what made America different than Russia." -- Woz