From: Tzafrir Cohen (tzafrir_at_nonexisting.hamakor.org.il)
Date: Thu 06 Mar 2003 - 15:59:12 IST
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:tzafrir_at_technion.ac.il http://www.technion.ac.il/~tzafrir ================================================================= To unsubscribe, send mail to linux-il-request_at_linux.org.il with the word "unsubscribe" in the message body, e.g., run the command echo unsubscribe | mail linux-il-request_at_linux.org.il
This archive was generated by hypermail 2.1.7 : Mon 06 Oct 2003 - 23:44:23 IST