My only issue is that i am not a developer, I am heavily reliant on Excel, i know it inside and out and just not sure whether OpenOffice supports excel files. In the past it barely did.
There are many features of Excel that LibreOffice Calc doesn't support. Most importantly: structured references, VBA, PowerQuery. Not to mention its UI is very laggy even on powerful machines.
For real financial/business work, Calc is just not a serious player.
I have a spreadsheet I've been using since 2017 to track all my spending and savings accounts on a weekly basis, plus some trend analytics, plus some simple graphs on multiple sheets. A few hundred rows and columns, both entered and calculated values (simple formulas, nothing fancy). Haven't noticed any slowness. When I have some data to look at (like .csv or even .xlsx), I always use Calc. I work with Excel at work all the time, it might be faster on larger data sets, but Libre's Calc is more than enough for many use cases.
My only issue is that i am not a developer, I am heavily reliant on Excel, i know it inside and out and just not sure whether OpenOffice supports excel files. In the past it barely did.