ODF 1.0 is completely insufficient for spreadsheet interoperability today and SUN were aware and rushed it in order to be 1st.
http://notes2self.net/archive/2006/07/12/Cutting-corners-_2D00_-the-realpolitik-of-ODF-standardisation_3F00_.aspx