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
