Re: Make AppleScript Create an AppleWorks Spreadsheet? (Applescript-users Digest, Vol 2, Issue 667)
Re: Make AppleScript Create an AppleWorks Spreadsheet? (Applescript-users Digest, Vol 2, Issue 667)
- Subject: Re: Make AppleScript Create an AppleWorks Spreadsheet? (Applescript-users Digest, Vol 2, Issue 667)
- From: Yvan KOENIG <email@hidden>
- Date: Sat, 15 Oct 2005 22:04:45 +0200
Le 15 oct. 2005 , à 4:13, Jonathan Levi, M.D. a écrit :
At Wed, 12 Oct 2005 17:48:46 +0200, Yvan KOENIG <email@hidden>
wrote:
------------------------------
Le 10 oct. 2005 , ý 14:56, Jonathan Levi MD a Ècrit :
> Would someone please help -- how to script AppleWorks's creating,
say,
> a new 20-column x 10-row spreadsheet, without using System Events?
Hello here is a script which do that except if you are using an old
version (before 628) in which deleting an empty row activates the bad
old eutocalc on strike bug.
-- [SCRIPT SS 20x20]
...
-- [/SCRIPT]
Fortunately, I'm using 6.2.9.
Thank you very much for your insightful and painstakingly complete
script.
My principal discovery from your script was the "select menu item 14
of menu 4" command, which makes unnecessary my call to System Events:
'tell application "System Events" to tell process "AppleWorks 6" to
keystroke "k" using {shift down, command down}..." (the "Delete
Cells... item).
For all the weaknesses of AppleWorks's dictionary, I have to admit
that the "menu item" class and its properties, "enabled", "checked"
and "check character", are very useful. Thank you for alerting me to
these!
Hello
I wrote the script when I was working under Mac OS 9.2.2. So I had to
find soluces without the availability of "System Events".
In the original script, before 628, I stored a string in the cell A of
every row i had to remove. Doping that I got rid of the infamous
autocalc anomaly.
In recent scripts, I uses "System Events" which is faster than the
"old" way.
I uses menus and menu items indexes so I am free of the application
localisation. Alas, some menu items must be used thru their name
because this name changes during the app use (Hide … <-> UnHide…).
When these menu items are triggered, checking the app localisation is
required (grabbing the item wording from the resourcefork is doable but
time consuming).
Yvan KOENIG
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Applescript-users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden