Quite off-topic for this list, so... On Thu, 6 Mar 2003, Beni Cherniavsky wrote:
> On 2003-03-06, Tzafrir Cohen wrote: > > > On Wed, 5 Mar 2003, Beni Cherniavsky wrote: > > > * spreadsheets (following lotus 1-2-3 ?) provide "cell aliases" which are > > names to specific cells/blocks . In other words: variables. > > > Hidden in a dialog last time I checked... In lotus and quatro: indeed. In excel: click on the box of the cell's address. > How does a goto work in the context of spreadsheets? Please explain > (and also the gosub). Do you mean that you need to escape to "macros" > for it or is it something natural to the normal table-of-cells work? goto 'address' 'address' can be a "physycal" address or a block name. Naturally. This is what goto always does. Addresses in a spreadsheets are of cells and cell blocks. > > They are basically turing complete (except the obvious memory limitation). > > Implementing a turing machine in a spreadsheet is quite trivial. STFW for > > one. > > > First google hit (seems to be the only relevant one in the first 10): > > http://cs.oregonstate.edu/~burnett/Turing/TuringMachine.html > > This explains that while "comercial spreadsheet languages are not > Turing complete, it is possible for a language using the spreadsheet > programming paradigm to be Turing complete". To examplify that it > shows a language where cells can change their values during the run, > which is quite untypical for spreadsheets (you need things like Solver > to work around). Here is the first hit on my google search: http://members.tripod.com/mumnet/tools/tools002.htm I'd appreciate replies in private mail... -- Tzafrir Cohen mailto:[EMAIL PROTECTED] http://www.technion.ac.il/~tzafrir ================================================================= To unsubscribe, send mail to [EMAIL PROTECTED] with the word "unsubscribe" in the message body, e.g., run the command echo unsubscribe | mail [EMAIL PROTECTED]
