Re: AppleScript commands for AppleWorks Spreadsheets
Re: AppleScript commands for AppleWorks Spreadsheets
- Subject: Re: AppleScript commands for AppleWorks Spreadsheets
- From: Marc Venot <email@hidden>
- Date: Fri, 31 May 2002 23:06:13 +0200 (MEST)
>
Having recently learned to command cells in an AppleWorks spread sheet
>
thanks to help via this list I managed to run into a problem that
>
perhaps someone here can clear up for me.
>
>
Info: Running Mac OS Z1-9.1 on a G4 Cube
>
AppleWorks version 6.1.2
You should update (free) to version 6.2.3
>
AppleScript version 1.6
>
>
With a clean new AW Spreadsheet open I run the following Script
>
>
tell application "AppleWorks 6"
>
activate
>
select cell "A1" in spreadsheet of front document
>
copy to clipboard
>
select cell "B2" in spreadsheet of front document
>
paste values
>
end tell
>
>
Cell A1 contains a simple formula, =$C$6. When I enter a numerical value
>
in cell C6 that number promptly appears in cell A1 as it should.
>
When I run the script tthe number appears in cell B2 along with the
>
formula from A1. This I do not want. I want just the numerical value in
>
cell B2 because I need to use it in another place and the formula messes
>
things up.
>
>
I have tried changeing the next to last line of the script to value and
>
to just paste. No matter, B2 still ends up with the number and the
>
formula. I thought 'values' or 'value' would act the same as Paste
>
Special in the AW menu.
>
>
Can anyone tell me how to forestall that tagalong formula so that it
>
does not show up in cell B2?
>
>
I hope it isn't just the way things work in my version of AW or
>
AppleScript.
>
>
Many thanks in advance to any and all who can shed light on this problem.
>
>
Robert Christy
proposed by:
Hubert Jacquot-Dion <email@hidden>
on
<email@hidden> (Liste AppleScript francophone)
tell application "AppleWorks 6"
activate
set r to cell "A1" in spreadsheet of front document
set formula of cell "B2" in spreadsheet of front document to r
end tell
--
GMX - Die Kommunikationsplattform im Internet.
http://www.gmx.net
_______________________________________________
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.