Re: limits of GUI scripting in numbers?
Re: limits of GUI scripting in numbers?
- Subject: Re: limits of GUI scripting in numbers?
- From: Yuma Decaux <email@hidden>
- Date: Sun, 05 Feb 2012 22:00:00 +1300
Hi Ronald,
Lucky you. I haven't gotten into that part yet. The reason i use numbers is because i need to pull out graphs from it at each instance my script calls for it. Maybe using another database type application might be better.
Best
On 5/02/2012, at 9:40 PM, Ronald Hofmann wrote:
> No Yuma, not really.
> One reason is that I don't use Numbers.
> On the oherr hand I'm using AS mainly with Xcode, Sorry.
>
> Regards
> Ronald
> ---
>
> Am 05.02.2012 um 09:06 schrieb Yuma Decaux <email@hidden>:
>
>> Hi Ronald,
>>
>> Thanks for the suggestion but its a no go. I've tried saving, closing, rebooting, cursing, calling chtulhu, does nothing. Still need to press option enter on the cell, then option again.
>>
>> Do you know how to get applescript to make a cell selection?
>>
>> Best
>>
>>
>>
>> On 5/02/2012, at 8:48 PM, Ronald Hofmann wrote:
>>
>>> Hi Yuma,
>>> it's hard to say what's wrong with a complex string from some distance.
>>> Anyway, I used to have similar results when talking to iCal or Address Book.
>>> It simply was a missing Save.
>>>
>>> May be something like this is missing here? Just a guess :)
>>>
>>> Regards
>>> Ronald
>>> ---
>>>
>>> Am 05.02.2012 um 06:57 schrieb Yuma Decaux <email@hidden>:
>>>
>>>> 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
>>
>>
>> _______________________________________________
>> 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
_______________________________________________
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