Do people hate LibreOffice that much?

jackvalentine 4 hours ago | parent | next [-]

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!

▲

tombert 6 hours ago | parent | prev [-]

My dad makes extremely liberal use of the VBA in Excel. LibreOffice does have an equivalent, but it's different enough to where he would be forced to port over large amounts of his code.

I think he could get over the different interface but I don't completely blame him for not wanting to redo all his work.