Comment

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

<- View Parent

4am@lemmy.zip ⁨22⁩ ⁨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

Sort:hotnew top

uninvitedguest@lemmy.ca ⁨21⁩ ⁨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 ⁨18⁩ ⁨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 ⁨21⁩ ⁨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 ⁨21⁩ ⁨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 ⁨15⁩ ⁨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