I use linux full time on my home PCs, and I want Libre Office to work for me.
I _can’t_ get equivalent functionality of Excel’s tables (named range, but it dynamically expands and applies formulas as you add more data). If you’ve got excel handy, open it up select a range and press control-L to see it.
There are endless forum threads of Libre Office boosters misunderstanding what the feature does and offering the halfway there equivalent.
I want this to work, but everyone uses excel’s feature set slightly differently and something will be missing for everyone. It’s incredibly annoying.
I don't use spreadsheets much anymore, and I end up just writing scripts for everything I would use Excel for. This isn't a brag, in fact it's sort of the opposite; I often miss the simplicity of Excel and I think for a lot of my scripts I would save time if I did them in in a spreadsheet.
One of these days, I should probably go through a tutorial series for LibreOffice and Star BASIC and properly learn it.
If I need to do any kind of number crunchy stuff I usually use Julia right now. I really like Julia, it's a very cool language and platform, but for small things it's kind of overkill. I should really learn how to properly use LibreOffice.
I _can’t_ get equivalent functionality of Excel’s tables (named range, but it dynamically expands and applies formulas as you add more data). If you’ve got excel handy, open it up select a range and press control-L to see it.
There are endless forum threads of Libre Office boosters misunderstanding what the feature does and offering the halfway there equivalent.
I want this to work, but everyone uses excel’s feature set slightly differently and something will be missing for everyone. It’s incredibly annoying.