Unfortunately, the biggest incompatibility with other spreadsheet applications and OO is the fact that the formulas/functions are totally different. This is, unfortunately, intentionally left out of the ODF standard.
So... you have to learn a whole new set of functions, whee.