3 ms·
>It has near 1:1 function compatibility. You're kidding, right? LibreOffice Calc does not have: - tables - powerquery - dynamic array formulae - XLOOKUP, L
by _dain_ 4y ago
>It has near 1:1 function compatibility.
You're kidding, right? LibreOffice Calc does not have:
- tables
- powerquery
- dynamic array formulae
- XLOOKUP, LET, FILTER, and the rest of the extremely useful new formulae
These four things completely dominate my Excel workflow. Opening Calc is like stepping back into the dark ages.
- greazy 4y agoThree out of those 4 things aren't functions. I do agree newer functions are missing (such as XLOOKUP) but for most people calc/excel is a high powered calculator and they use it as such. So Calc is perfect replacement. It's not the dark ages, that's an exaggeration.
- philliphaydon 4y agoI often think people suggesting things like Libreoffice just open csv files and scroll through then tell everyone else they can do everything in libreoffice. When you’re a heavy user of excel, almost nothing else compares. Tho Google sheets does give excel a run for its money, because it has scripts (javascript) to do everything else.
- greazy 4y agoLO Calc has python scripting. I think you mean power user, I can accept that LO calc is not up to speed for powerusers of Excel. I'm a heavy user of LO calc, but my usage is of course different from yours. For true data wrangling I use R so this statement. I can't imagine the data wrangling and transformations that I perform in R being done in Excel. Its a nightmare waiting to happen!