you are viewing a single comment's thread
view the rest of the comments
[–] 6 points 6 months ago (6 children)

Excel is the biggest hurdle to overcome. No other spreadsheet software comes close to providing the same amount of features and functionality.

  • source
  • parent
  • hideshow 6 child comments
  • [–] 14 points 6 months ago (3 children)

    Can confirm! Calc is fine as long as you’re not trying to do anything too advanced. Then again, when you bump into those limits, you might want to consider switching to R or Python anyway. Excel just allows you to delay that inevitability a little bit longer.

  • source
  • parent
  • hideshow 3 child comments
  • [–] 7 points 6 months ago* (last edited 6 months ago) (1 child)

    I mean, you can run python (or their own language "LibreOffice Basic") from within a Libreoffice Calc sheet.

    Calc's scripting is actually more powerful than the aging VBA thing Excel uses for macros, imho.

  • source
  • parent
  • hideshow 1 child comment
  • [–] 1 point 6 months ago

    Very interesting... I guess my calculations can be supercharged while still technically remaining in the realm of a spreadsheet.

    Hopefully Python still runs with its usual consistency. VBA is a total nightmare in this regard. The code can randomly throw some useless error for no obvious reason. You can run the same code a few hours later and everything works perfectly even though you didn't change anything. Can't really use anything that unstable for anything serious.

  • source
  • parent
  • [–] 9 points 6 months ago

    So I keep hearing... Yet, I'm having a hard time believing that most people are even aware of those fancy features, let alone use any of them.

    I accept that there are important models implemented as excel sheets. Reimplementing or even attempting to migrate away is viewed as risk. But this is a different argument.

  • source
  • parent