553
Microsoft announces it will automatically install the Copilot AI app alongside desktop versions of 365 products like Word, Excel and PowerPoint this October (www.pcgamer.com)
submitted 1 year ago by to c/technology@lemmy.world
117 comments fedilink hide all child comments
you are viewing a single comment's thread
view the rest of the comments
[–] 4 points 1 year ago (6 children)

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

  • permalink
  • fedilink
  • source
  • parent
  • hideshow 6 child comments
    •
  • [–] 5 points 1 year ago* (5 children)

    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)

    If you aren’t pushing Excel to its absolute limits then it’s more than enough.

  • permalink
  • fedilink
  • source
  • parent
  • hideshow 5 child comments
    •
  • [–] 3 points 1 year ago (3 children)

    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.

  • permalink
  • fedilink
  • source
  • parent
  • hideshow 3 child comments
    •
  • [–] 1 point 1 year ago

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

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

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

  • permalink
  • fedilink
  • source
  • parent