Is xlOptimizer compatible with Open Office Calc, or another spreadsheet?

No, xlOptimizer is not compatible with other spreadsheets, except for Microsoft's Excel.