There is one thing I use Libre Calc over Excel for. It’s when I need to use Autohotkey to copy data out of a spreadsheet to be sent to another program. Still, in 2024, with the current version of Office 365 Excel, I will get the error “We could not copy the content to the Clipboard, it is in use by another application”, breaking the flow of my macro.
I never have that issue when copying data out of Libre Calc, so I work with my data and formulas in Excel, then open the spreadsheet with Calc when it’s time for Autohotkey to do its thing. It’s a narrow use case for me but I appreciate Calc for being the workaround I need for that.
Sheets is decent too though, I’ve made macros for others that use Sheets and did not have any issues working with it.
There is one thing I use Libre Calc over Excel for. It’s when I need to use Autohotkey to copy data out of a spreadsheet to be sent to another program. Still, in 2024, with the current version of Office 365 Excel, I will get the error “We could not copy the content to the Clipboard, it is in use by another application”, breaking the flow of my macro.
I never have that issue when copying data out of Libre Calc, so I work with my data and formulas in Excel, then open the spreadsheet with Calc when it’s time for Autohotkey to do its thing. It’s a narrow use case for me but I appreciate Calc for being the workaround I need for that.
Sheets is decent too though, I’ve made macros for others that use Sheets and did not have any issues working with it.