Highest Rated Comments


baseCase00762 karma

Power User / VBA Developer here. I'm going to be a little direct, because while I love Excel, I've definitely seen it's warts.

Four questions:

  1. Can you/someone fix the Ctrl-Break bug in Excel? I don't run into it often, but when I do, I am surprised that this isn't a priority. It's the second most WTF thing in Excel. http://stackoverflow.com/a/5823507/2886869

  2. The most WTF thing in Excel is the Data Model. I've had Pivot Tables quit on me, saying that the Data Model is corrupt, with no additional tooling, or help, and I've had to rebuild entire spreadsheets. I really like the idea of ListObjects and Tables, but if they randomly break, I can't really put them in my spreadsheets until the tooling around fixing them is better.

  3. Can we update the VB Editor to, like, 2005? It hasn't changed since Office 97 and there are things that I really would like IE code folding, regex search inside the VBE, Eclipse's automatic reformatting of code, VIM bindings, etc, etc. Can we take SOME of the Visual Studio Code stuff and port it?

  4. If we are getting Javascript in Office, that's great, then can you pretty please heavily promote D3 as the visualization library of choice, complete with some training to integrate both?

baseCase0072 karma

One more thing. VBE needs a linter. Pretty please?