this post was submitted on 18 Sep 2025
541 points (98.7% liked)

Technology

75300 readers
6279 users here now

This is a most excellent place for technology news and articles.


Our Rules


  1. Follow the lemmy.world rules.
  2. Only tech related news or articles.
  3. Be excellent to each other!
  4. Mod approved content bots can post up to 10 articles per day.
  5. Threads asking for personal tech support may be deleted.
  6. Politics threads may be removed.
  7. No memes allowed as posts, OK to post as comments.
  8. Only approved bots from the list below, this includes using AI responses and summaries. To ask if your bot can be added please contact a mod.
  9. Check for duplicates before posting, duplicates may be removed
  10. Accounts 7 days and younger will have their posts automatically removed.

Approved Bots


founded 2 years ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
[–] 4am@lemmy.zip 5 points 22 hours ago* (last edited 22 hours ago) (2 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.

[–] world_cavve@lemmy.world 1 points 16 hours 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.

[–] uninvitedguest@lemmy.ca 3 points 22 hours 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.

[–] LordCrom@lemmy.world 1 points 19 hours ago

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

[–] MrSulu@lemmy.ml 2 points 22 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

[–] Corkyskog@sh.itjust.works 1 points 22 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...