I would love to switch to LibreOffice (or similar) but I haven’t been able to find a way to get tables to work in the same way they do in Excel, and that’s a deal breaker for me. None of the suggested approaches come close to being able to select a range, press ctrl+t and immediately be able to filter/sort/lookup using column names from anywhere in the document.
I use that feature dozens of times a day, and so does everyone in my circles that deals with financial data.
I think you name the range, and then you can do the same using ctrl+shit+L
I may not remember right, but I haves used calc and excel interchangeably since it was open office. Some things in excel drive me up the wall, some things in calc do to.
Either way, the best thing I found was get the data out of spread sheets and into something that can work with it better. Like sql or pandas.
But I get that for financial work, it is a staple. Which frightens me to no end.
I would love to switch to LibreOffice (or similar) but I haven’t been able to find a way to get tables to work in the same way they do in Excel, and that’s a deal breaker for me. None of the suggested approaches come close to being able to select a range, press ctrl+t and immediately be able to filter/sort/lookup using column names from anywhere in the document. I use that feature dozens of times a day, and so does everyone in my circles that deals with financial data.
I think you name the range, and then you can do the same using ctrl+shit+L
I may not remember right, but I haves used calc and excel interchangeably since it was open office. Some things in excel drive me up the wall, some things in calc do to.
Either way, the best thing I found was get the data out of spread sheets and into something that can work with it better. Like sql or pandas.
But I get that for financial work, it is a staple. Which frightens me to no end.
What about OnlyOffice?
You can purchase the Microsoft apps , word, excel, PowerPoint, as a package that you own. There are no upgrades. You own them.
I am in the process of moving to Linux and Libreoffice at the moment. I’m working at getting myself off of Onedrive.
Once complete I will start the process of getting off Google. I’ve been using Proton for years and I am going to remove any other online support.