• turboSnail ( turboSnail@piefed.europe.pub ) 
    link
    fedilink
    English
    arrow-up
    12
    ·
    9 months ago

    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.

    • Ferk ( Ferk@lemmy.ml ) 
      link
      fedilink
      arrow-up
      5
      ·
      edit-2
      9 months ago

      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.

      • turboSnail ( turboSnail@piefed.europe.pub ) 
        link
        fedilink
        English
        arrow-up
        1
        ·
        9 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.