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

• 4am@lemmy.zip ⁨3⁩ ⁨weeks⁩ 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 ⁨3⁩ ⁨weeks⁩ 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 ⁨3⁩ ⁨weeks⁩ 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 ⁨3⁩ ⁨weeks⁩ 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 ⁨3⁩ ⁨weeks⁩ 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 ⁨2⁩ ⁨weeks⁩ 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