I've used it a lot in the past, and I'm looking forward to using it again soon as I move to Linux. But there's a feature that Calc doesn't seem to have: Power Query.
I'm using it to process data from an Access database into the spreadsheet (while transforming it).
I'm not sure if LO has plans on implementing something like that?