Not implying that you don't already know, but this may be of interest in terms of Calc/Excel compatibility: https://wiki.documentfoundation.org/Feature_Comparison:_Libr...
I have used the tool predominantly with xlsx format spreadsheets created in Excel.