Comment on Microsoft announces it will automatically install the Copilot AI app alongside desktop versions of 365 products like Word, Excel and PowerPoint this October

MrSulu@lemmy.ml ⁨1⁩ ⁨day⁩ ago

• Corkyskog@sh.itjust.works ⁨20⁩ ⁨hours⁩ ago

  Which one is the Excel replacement and how does it compare? We all know companies buy office mostly just for excel…

  source

  • 4am@lemmy.zip ⁨19⁩ ⁨hours⁩ ago

    LibreOffice Calc. I think it still has some performance issues vs Excel with extremely large files, and it can only do 1024 columns. Also LibreOffice Basic can do a lot of what VBA could but the syntax is different and I don’t think it integrates well with the rest of the system like VBA’s COM integration (as unsafe as that was)

    source

    • uninvitedguest@lemmy.ca ⁨19⁩ ⁨hours⁩ ago

      What about tables, pivot tables, power query, grouping of rows and columns , and how is formula/function parity (xlookup, index, match, sumproduct, etc)?

      I’ve made some truly Frankenstein sheets that I’m not sure could be stitched together elsewhere.

      source

      • LordCrom@lemmy.world ⁨16⁩ ⁨hours⁩ ago

        Why excel for super complex computations? At some point, just code your solution instead… It’s easier than troubleshooting Excel

        source
      • MrSulu@lemmy.ml ⁨19⁩ ⁨hours⁩ ago

        I don’t have any issues. It’s free to download to any operating system. So give it a try. See if it can open your existing Excel spreadsheets

        source
      • Corkyskog@sh.itjust.works ⁨19⁩ ⁨hours⁩ ago

        I am having vague nightmares of the Momte Carlo and Black Scholes sheets we would have to compile for financial engineering classes in college…

        source
    • world_cavve@lemmy.world ⁨13⁩ ⁨hours⁩ ago

      You could try SoftMaker office for 30 days to see if their version of Excel is better.

      Yearly subscription: www.softmaker.com/en/products/…/download Perpetual license: www.softmaker.com/…/download-permanent-version Comparing the different versions: www.softmaker.com/en/products/…/order-all

      Bonus is that the license will work regardless if you use Linux, Mac or Windows. And the 2024 version is GDPR compliant.

      source
• kazerniel@lemmy.world ⁨13⁩ ⁨hours⁩ ago

  Obsidian is sadly not FOSS, but aside of that, it’s amazing (and entirely user-supported, not relying on VC profit-seeking).

  source