The issue comes in where you take a complex spreadsheet (like financial analysis ones for work) that were created in Excel and try to run them in Calc. Agreed that ones created in Calc generally work well. It's just the interoperability that's the issue.
I have always said that if you are going to use an intense Excel spreadsheet, you should convert it to Calc instead of running it natively. And if you have a lot of visual basic, then convert to some SQL and build an app around it.