3 ms·
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 dyn
by jackvalentine 11mo ago
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.
- tombert 11mo agoWhat do you end up using at home?
- jackvalentine 11mo agoMost recent example, putting together a pretty basic car shopping spreadsheet I’ve just gotten pissed off and not done it. Yes it’s petty, yes it means I just don’t do something easy. Yes in the end it’s only my problem. I’ll probably just do it on excel for the web.
- tombert 11mo agoI 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.
- jackvalentine 11mo agoAnything ‘real’ I’ll do in R, but my wife is not super keen on that where we’re collaborating on something!
- tombert 11mo agoI'm not keen on R even at the best of times :) 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.
- jackvalentine 11mo agoWe all have our vices! (It's what I learned first, and feel most confident in). This has been a nice interaction which is increasingly rare online, thanks.