In Excel, use the "Name Manager" dialog and the "Name Box" on the formula bar. They re somewhat hidden, but discovery of them forever changed my spreadsheets!
http://office.microsoft.com/en-us/excel-help/define-and-use-...
And functions can be VBA so the state of those global variables isn't the only way for functions to talk to each other. e.g.
Dim x As Integer
Function setx(n)
x = n
setx = 1
End Function
Function getx()
getx = x
End Function
and then you can put =setx(200) in one cell and =getx() in another. It is hard to look at the whole thing at once, but when do you need to do that?Somebody should really build a web app version of that, there are millions of custom Excel+VBA spreadsheets spread throughout businesses across the world.
The only way they will migrate online is either through custom web apps (I used to do a lot of those) or with a generic solution which doesn't exist yet.
I don't know why Google hasn't done this yet.
Excel has named ranges - allows you to give a meaningful name to single cell or a range of cells - a pretty widely used feature.
"it's a single line text field"
Excel's formula editor can be as large as you want.
Numbers.app has the nice feature (among others) to use column/row headers to name cells/colums/rows in formulas in a readable manner.
Data and formulas were kept completely separate so you could change them at will.
You get compiler errors about as helpful as trying to debug C++ macros -- namely, something is wrong with this big glob of code, but it ain't gonna tell you what or where.
There's the fact that you're dealing with cell references rather than variable names, so all of your expressions look like ($K4 - $S$1) rather than (principal - payment).
There's the fact that the IDE you're working in is trash -- rather than a text file with carefully indented parenthetical statements, it's a single line text field. Sort of like trying to code in a URL bar.
There's the fact that pieces of a program are often littered all over the spreadsheet, and it's hard to look at the whole thing at once.
There's the fact that it's extremely stateful -- the whole thing exists and depends on a table of values -- and when and where and how and in what order they're updated. From a programming perspective, everything is a global variable, and anything can update anything, and setting the state of those global variables is the only way for functions to return data or talk to each other.
I would say all of these are problems that Real Programming Languages have under control, so I can't say I worry too much about such an IDE descending into spreadsheet madness. I do wonder how you would show meaningful realtime results, though, without running a program from the top.