Hacker News Reader

It's a great idea, but I've been working in multiple enterprise excel hells and most of the places use macros, because the simple stuff just does not allow needed complexity.

Now try to visualize that...

View on HN

What we have found is that one of the biggest problems in the BI space is the fact people are not able to code and resort to some of the horrific formulae we see. But agreed - including macros would add a huge new layer of complexity!

I much prefer reading Excel spreadsheet with complex formulae, than those with complex macros. It's much easier to follow things around and literally 'see' what's going on.

Parentheses FTW!

Absolutely!

Also, the people who write macros are invariably not programmers[1], and the macro code they write is... not so great.

[1] I am a programmer who writes macros, and presumably there are others too.

Reply on news.ycombinator.com