limits of GUI scripting in numbers?
limits of GUI scripting in numbers?
- Subject: limits of GUI scripting in numbers?
- From: Yuma Decaux <email@hidden>
- Date: Sun, 05 Feb 2012 18:57:20 +1300
Hi List,
I have successfully created a lengthy and complex script with many variables and layers of repeat loops and it all works seriously fine except for one annoying issue in iwork numbers.
I've created interactions with various cells of columns to come up with an action that places the following formula in every ascending cell
=100-100/(1+((((SUM(E17:E30)/14)*13)+G16)/14)/((((SUM(E17:E30)/14)*13)+G16)/14))
The formula is a concatenation of several variables taking information of names of cells etc and incrementing cel values via other nested loops.
It all works great.
The formula also works fine, but it just doesn't appear as a result when the script is run.
I have to option enter each cell, where the formula is in fact residing, then press enter for the result to appear.
Is there anything like a refresh or other method to get these results to appear without having to manually look into the forumla and press enter? Or if that's the only solution, is there a way to point the selection to a cell and do the manual option enter then enter?
I suppose the gui scripting would go like:
Tell application "System Events"
Tell process "Numbers:
Tell table 1 of sheet 1 of front document
Keycode 36 using (option down)
Keycode 36
End tell
End tell
End tell
And create a repeat to loop throughout the range of cells i want, but that's like sticking an adhesive to a key on the keyboard to have my ultima online avatar to mine and gain xp while i'm off eating noodles.
Any more elegant solution as the rest of the script has elegance in mind?
Thanks for any advise
Yuma
_______________________________________________
Do not post admin requests to the list. They will be ignored.
AppleScript-Users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
Archives: http://lists.apple.com/archives/applescript-users
This email sent to email@hidden