Re: AppleScript commands for AppleWorks Spreadsheets
Re: AppleScript commands for AppleWorks Spreadsheets
- Subject: Re: AppleScript commands for AppleWorks Spreadsheets
- From: Robert Christy <email@hidden>
- Date: Thu, 30 May 2002 14:49:12 -0700
- Organization: N/A
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
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
_______________________________________________
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.