Hacker News new | ask | show | jobs
by kristiandupont 460 days ago
If you have a spreadsheet with macros that are anything more than the most basic, you can't run it in Calc. It's not that trivial.
1 comments

The 2% ...And your company logic should not be in the Macros.

"The Wall of Shame for the Worst Excel Errors" - https://www.solving-finance.com/post/the-wall-of-shame-for-t...

Right, so your argument is that this is easy, and if it turns out that it's not, we'll just be smug and tell them that they were holding it wrong all along?

It sounds like you are picturing in your head that all spreadsheet work is greenfield. Do you have any idea how much Excel code is embedded everywhere? Very often made by people who are no longer around. You can lecture all you want, but this is the situation. I don't like it either.

Relax...the weekend almost here... :-)

Did not intend to be smug...honestly..not really. :-) In my defense, I have more than 20 years corporate experience in tech AND finance domains, in more than 25 countries. And in the cultural domains of the five different languages I am familiar and whose grammar I regularly brutalize. Can't recognize the problem you are describing, as the mountain that would stop any company from start using LibreOffice.

All that logic in Excel sheets is just a serious governance problem...

"How an Excel error cost JP Morgan $6 billion" - https://www.linkedin.com/posts/eriklidman_how-an-excel-error...