From: | Andrew Bruno |
Date: | 29 May 2001 at 08:03:45 |
Subject: | Re: Final calc / AREXX problem. Walk through. |
Hello Ash
On 29-May-01, you wrote:
Ok to start you need a sheet with 5 pages.
Page 5 is the one which is effected by this script.
So you will need to make a project which fits this need first.
>> /*
>> ** Written 12/5/01
>> ** Andrew Bruno
>> */
>
>> OPTIONS RESULTS
>
>
>> top.1 = 'E_A34:E_C34'
>> bottom.1= 'E_A54:E_C54'
>> right.1 = 'E_D35:E_D53'
>> home.1 = 'E_B40'
The above lines are the "borders" around the area for year 1. Alas there
is a bug with this as it is supposed to be financial years not calandar
years.
>> top.2 = 'E_E34:E_G34'
>> bottom.2= 'E_E54:E_G54'
>> right.2 = 'E_H35:E_H53'
>> home.2 = 'E_F40'
Year 2
And I am sure you get the rest.
Each of these cells are '\=' for the horizontal ones and '|' for the
vertical ones.
(yes I could of used the lines function, but this is how things are.
>> cell e_k1
>> contents e_k1
>> number = result
Why do I HAVE to put the cell e_k1 line in the script?
the next line:
contents e_k1 should give me the contents of e_k1 but if I don't have the
cell e_k1 line, I don't get the correct value.
BTW, e_k1 is the number value of the year. For now it is calandar years.
That is not here or there in how the script works.
The rest of it pretty well works. Appart from the fact that I have to put
the cursor somewhere to remove the "block mode" when it colours the last
range.
Regards
Andrew Bruno
abruno@zeta.org.au
ARexx mailing list - No flames, no overquoting, no crossposting.
Unsub: Blank mail to mailto:arexx-unsubscribe@yahoogroups.com
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/