The problem is everyone expects Calc to be Excel, including full compatibility with reading and writing of Excel’s file formats. As Excel is a constantly moving target, following that path means you’ll forever be a second-rate Excel that’ll never quite be fully compatible.

I find Calc to be a fine spreadsheet program myself, though I’m hardly a power user. If you want to use Excel, then just go use Excel.