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 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.