Comment I use both quite a bit (Score 3, Informative) 285
People who do "serious" work with Office have real problems migrating.
I'm one of those people who does "serious" spreadsheet work. By and large switching between the Excel and OOo/LO works pretty well. Occasional formatting issues and the odd formula incompatibility but mostly it works fine. I try to use macros as little as possible so I can't speak to compatibility there but I would expect it to be something of a creeping horror.
Write and Word do have incompatibilities.
Sadly yes. Quite a few of them in fact.
I never tried to open a MS Access database in OpenOffice Base,
I have and it generally works but probably not exactly the way you expect. Base isn't really the same thing as Access. It's more of a connector application than a standalone database product. I use it primarily to do ODBC connections between spreadsheets and a database. Unfortunately they tend to break their ODBC code between versions so I've been stuck on a pretty old version of OO for quite a while.
Switching from MS Office to OpenOffice / LibreOffice is not easy at all for power users. To put into geek terms: imagine switching from Apache to Lighttpd. For most things, it will be great. But, if you have some serious
Bingo. If you have a heavily macro'd set of Excel spreadsheets or the like you probably aren't going to want to switch. Just way too painful. But most people could probably switch with only modest problems here and there.