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 4 hours ago | parent [-]

What do you end up using at home?

▲

jackvalentine 3 hours ago | parent [-]

Most 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 3 hours ago | parent [-]

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.

	▲	jackvalentine an hour ago \| parent [-]
		Anything ‘real’ I’ll do in R, but my wife is not super keen on that where we’re collaborating on something!