Re: Recalculation of AppleWorks Spreadsheet
Re: Recalculation of AppleWorks Spreadsheet
- Subject: Re: Recalculation of AppleWorks Spreadsheet
- From: mikeboyer <email@hidden>
- Date: Sun, 26 May 2002 18:58:14 +0100
I have found a solution to my problem, as follows:
set mypath to "Macintosh HD:Users:mike:testsheet"
tell application "AppleWorks 6"
open mypath
tell document 1
recalculate
end tell
i.e using document 1 rather than mypath as the parameter.
However I don't think this is what the AppleWorks dictionary intends.
Thanks
Mike
-----------------------------------
On Saturday, May 25, 2002, at 10:07 , mikeboyer wrote:
>
I have a number of AppleWorks spreadsheets which refer to each other and
>
I want to ensure their synchronisation by doing the equivalent of a
>
"calculate now" menu command, on each file, from a script.
>
>
The AppleWorks 6 dictionary offers the "recalculate" command which I
>
assume is meant to do this. The actual dictionary entry is:
>
>
recalculate: Recalculate a spreadsheet
>
recalculate spreadsheet layer -- the spreadsheet to recalculate
>
>
>
Seems simple but it doesn't work for me. My several script attempts
>
(with the corresponding error messages) are as follows
>
>
set myfile to "Macintosh HD:Users:mike:testsheet" as alias
>
tell application "AppleWorks 6"
>
open myfile as document type spreadsheet --AppleWorks launches OK
>
activate
>
(1) recalculate -- Error : "AppleWorks can't
>
continue recalculate"
>
(2) recalculate myfile -- Error`: myfile "doesn't
>
understand the recalculate message"
>
(3) recalculate spreadsheet layer -- Error:
>
"expected eol but found command name"
>
(4) recalculate spreadsheet layer myfile -- Error: "expected
>
eol but found command name"
>
end tell
>
>
I am using OSX10.1.4.
>
>
Can anyone please advise me how this recalculate should work?
>
>
Thanks
>
Mike Boyer
>
_______________________________________________
>
applescript-users mailing list | email@hidden
>
Help/Unsubscribe/Archives:
>
http://www.lists.apple.com/mailman/listinfo/applescript-users
>
Do not post admin requests to the list. They will be ignored.
_______________________________________________
applescript-users mailing list | email@hidden
Help/Unsubscribe/Archives:
http://www.lists.apple.com/mailman/listinfo/applescript-users
Do not post admin requests to the list. They will be ignored.