Hello Donna; The only reason I have for looking at spreadsheets is to see what all the fuss is about. I looked at them once, in the early 80's, when VisiCalc was all there was, and didn't see much of note. Spreadtheets don't give me anything desireable that APL/J doean't. I'm still wondering what all the fuss is about. Maybe someone can tell me.
I am aware of expressions like: range PUT expression which I saw in earlier attempts at APL spreadsheets. They appeared to me to be a negation of the advantage of spreadsheets, like the goto was reintroduced where it had been eliminated. ------------------------------------------------------------------------ |\/| Randy A MacDonald | APL: If you can say it, it's done.. (ram) |/\| [EMAIL PROTECTED] | |\ | |If you cannot describe what you are doing BSc(Math) UNBF'83 þas a process, you don't know what you're doing. Sapere Aude | - W. E. Deming Natural Born APL'er | Demo website: http://156.34.64.225/ -----------------------------------------------------(INTP)----{ gnat }- ----- Original Message ----- From: "dly" <[EMAIL PROTECTED]> To: "General forum" <[email protected]> Sent: Friday, June 16, 2006 8:21 AM Subject: Re: [Jgeneral] spreadsheets > In general, you can put expressions in cells of spreadsheets which > direct there results to other cell ranges. You can put script-like > code in cells that don't get displayed in the viewing section. The > spreadsheet can actually be much like a workspace in many respects. > > In my first Lotus123 application I was using (if I recall) a {left} > {left}{left}... command to move the cursor around the spreadsheet. > (Used APL to read budget data into a worksheet and have Budget > managers update etc--directing them to input fields.) Being dyslexic > I initially used {left}{left}{left}... when I meant {right}{right} > {right}...in those days you couldn't just say move left 20 cells. > > Worth looking into? I hope you have other options. > > Donna > [EMAIL PROTECTED] > > > > On 10-Jun-06, at 8:40 PM, Randy MacDonald wrote: > > > This ability to express array constants seems like a trivial > > extension of > > cell ranges. I don't see how the result of the expression can be an > > array. > > Does Excel display a cell with the formula '({1,2,3})' for example, > > or does > > something like "<<ARRAY>>" show up in the cell? > > > > I've got the Open Office spreadsheet on my box someplace. Is _that_ > > worth > > exploring, anyone? > > ---------------------------------------------------------------------- > For information about J forums see http://www.jsoftware.com/forums.htm > ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm
