Excel is the one thing LibreOffice still falls behind on. It’s really hard to compete with Excel, specifically.
Comment on What are some FOSS programs that are objectively better than their proprietary counterparts?
Dave@lemmy.nz 1 day agoYou sound like you know your LibreOffice.
My experience is they are quite different but I’ve been able to do the same things for the most part.
But how the hell do I make a pivot table that looks and functions as nice as the plain old default one in Excel?
SnotFlickerman@lemmy.blahaj.zone 19 hours ago
CancerMancer@sh.itjust.works 10 hours ago
Excel is probably the one sore spot for LibreOffice, but also Google’s suite and really everyone else. Excel is tough to beat, especially when you consider the additional power of things like Power Query and Excel on web having JavaScript functions.
That said: I truly despite pivot tables and I no longer use them. Like pie charts, they are usually useless.
Dave@lemmy.nz 9 hours ago
Whaaaaaaaat? Pivot tables are a 2 second job to summarise large amounts of transaction data or similar by month or year. Lookups or countifs would take so much longer!