007 Bond wrote:
No word processer is ever going to be as good as Word. No spreadsheet program will ever be as good as Excel.
As someone who uses (and creates for other people) spreadsheets as part of my job, I feel like doing a John McEnroe about now...
<New York Accent>
You can NOT be serious!
</New York Accent>
Excel is OK for casual spreadsheet users, those who dabble a bit and 'Professional developers' who think Bill Gates is King and can do no wrong - but I've found its tendency to 'break' spreadsheets that use any serious VBA scripting at each MS upgrade makes it an utter P.I.T.A. to use for anything that goes beyond the simplest recorded macro.
Lotus 123 (God bless it!) seems to me to be way, way more robust in that regard, I've got to support hundreds of applications based on Lotus Rel 2.4 /3.0 & 5.0 that I wrote in the late 1980's early 1990's. So far I think I've had to make maybe two or three minor 'tweaks' to the code (where I've exploited an undocumented feature - so I can't blame Lotus for that) and these apps are still in use today on Smartuite 9.5, 9.8 etc. Trust me on this, if I'm investing a lot of time in building a complex spreadsheet, I'll do it in Lotus and forget about it, or do it in Excel and it's 'odds on' that when the next Excel upgrade comes along I'll be doing it again.
Of course, the fact Excel apps seem to need revision with each new release might be regarded as an advantage by some developers. It is in their interest to promote Excel as 'the best choice' when you think about it. (Cynical aren't I!)
While I'm at it, Access *is* very good and is now the 'standard' - although Approach is (I think) a much more friendly DBM package to use. Word users suffer from the same "upgrade hell" problems that Excel does but to a much lesser extent (fewer people have a reason to script Word). Personally I prefer Word Pro to Word - but that's probably because 'way back when' we had a choice of Word 6.0 which crashed all the time, or Word Pro which didn't crash and also looked nicer.
Just because something is the most used choice doesn't make it the best product by any means. MS have mastered the art of using their dominance of the OS market to lever competing products in other areas out of the way over the years, and I think the MS Office dominance owes a lot more to that tactic than any particular merit of the product(s).
Al (MaDbRiT)