Ask HN: Excel experts – Formula IDE in Excel (MVP screenshot)

Re:Ask HN: Excel experts – Formula IDE in Excel (MVP screens... by LarryMade2 on Wednesday July 29, 2015 @10:05AM (#9968673)

I like the concept, when debugging some complex sheets that could come in handy - though having all the formulas in a windows might hinder understanding the layout of the sheet, especially if you are lazy and don't label all your cells (or just know enough about excel to be dangerous).

I thought it would be cool if formulas would pop into little syntax highlighted text edit areas when double clicked (or some other meta-click)

I think having a look at some more complex sheets would be good. (Ask for your company's accounting department I'm sure they have some Excel monsters lurking on desktops).

[ Parent | on HN ]

Re:Ask HN: Excel experts – Formula IDE in Excel (MVP screens... by damian_r on Wednesday July 29, 2015 @10:46AM (#9968971)

I like the concept of simple editor for the formula.

Maybe an editor that would extract all formulas from the sheet and give you different view after double click would be a good solution. On one hand you would still have your normal spreadsheet but you can go to a different level if you want to do refactoring etc.

[ Parent | on HN ]