Some FOSS programs, due to being mantained by hobbyists vs a massive megacorporation with millions in funding, don’t have as many features and aren’t as polished as their proprietary counterparts. However, there are some FOSS programs that simply have more functionality and QoL features compared to proprietary offerings.

What are some FOSS programs that are objectively better than their non-FOSS alternatives? Maybe we can discover useful new programs together :D

I’ll start, I think Joplin is a great note-taking app that works offline + can sync between desktop and mobile really well. Also, working with Markdown is really nice compared with rich text editors that only work with the specific program that supports it. Joplin even has a bunch of plugins to extend functionality!

Notion, Evernote, Google Keep, etc. either don’t have desktop apps, doesn’t work offline, does not support Markdown, or a combination of those three.

What are some other really nice FOSS programs?

edit: woah that’s a whole load of cool FOSS software I have to try out! So far my experiences have been great (ShareX in particular is AWESOME as a screenshot tool, it’s what snip and sketch wishes it could be and mostly replaces OBS for my use case and a whole lot more)

  • Dave@lemmy.nz
    link
    fedilink
    arrow-up
    14
    ·
    6 days ago

    You 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?

    • JustEnoughDucks@feddit.nl
      link
      fedilink
      arrow-up
      2
      ·
      edit-2
      5 days ago

      Ugh I hate excel. It can’t do the most basic things like search and replace things reliably in all cases. I have moved literally all data analysis besides the absolute basic “count” and “sum” operations to python in spyder. 200x faster, repeatable, won’t freeze up with large datssetd, and has never once failed a basic operation like a search and replace. Not to mention the localization issues and the fact that it will fuck things up completely if you install a new printer because Microsoft decided the printer has priority of your document and spreadsheet layouts over choosing a default.

      I had some evaluation board software that whenever the value dipped below -1, would place the comma completely randomly in the floating point number.

      Excel almost had a heart attack when I asked it to search and replace ”-1” with “-1,” and it found all of the cases just fine, but decides to ignore the replace and not place a comma at all. If I tried to convert them to a number, it freaked out and placed the decimal place also randomly, different than the input. And of course trying to do in-place operations on a column for export is just painful.

      Hell, in notepad++ I could just regex the digit range that was preceded by a ”-1” and get everything replaced using a few brackets.

      Not to mention how terrible the graphs work in comparison and how bad they look with the default options 😅. But hey, you can automatically put in a drop shadow or frame it in a useless way.

      There are some people who can work very efficiently and do some crazy things in excel (like the excel doom) but unless you have literally been using it daily for many years and actively looking for ways to speed up, then it is just as easy or easier to do things in an actual data processing program like matlab, octave, python, or R (And I am not a coder) and you can literally copy paste a file name for the next full dataset.

    • CancerMancer@sh.itjust.works
      link
      fedilink
      arrow-up
      4
      ·
      edit-2
      4 days 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 despise pivot tables and I no longer use them. I use lookups, countif, or other functions to display what I need, otherwise I use Power Query.

      • Dave@lemmy.nz
        link
        fedilink
        arrow-up
        3
        ·
        edit-2
        6 days 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!

        Not to mention that you can drill into the data using them.