Very slow Applescript operation in iWork Numbers 09
Very slow Applescript operation in iWork Numbers 09
- Subject: Very slow Applescript operation in iWork Numbers 09
- From: Mads Fog Albrechtslund <email@hidden>
- Date: Wed, 25 Nov 2009 19:22:31 +0100
I have a question about a very slow Applescript operation in iWork
Numbers 09.
I have a document in Numbers, about 30.000 rows long.
What I am trying to do, is set the value of every cell of a new column
before column 1.
I can do this, but the speed is very slow.
My script looks like either this:
----------------------------------------
tell application "Numbers"
set theDocument to table 1 of sheet 1 in the front document
add column before column 1 of theDocument
set theCells to count of cells in column 1 of theDocument
set value of cells 1 through theCells of column 1 of theDocument to
6453
end tell
----------------------------------------
Or this (which I tried in case the speed should be different)
----------------------------------------
tell application "Numbers"
set theDocument to table 1 of sheet 1 in the front document
add column before column 1 of theDocument
set value of every cell of column 1 of theDocument to 6453
end tell
----------------------------------------
Both these scripts works, but are slow.
If the operation is done by hand:
Enter 6453 in cell 1
Copy this
Mark all cells
Paste to all cells
The operations takes a split-second.
The Applescripts take about 1 minute and 45 seconds.
I have tried the scripts on both Mac OS X 10.5.8 and Mac OS X 10.6.2,
both with Numbers fully updated.
Do any of you have some surjections or inputs?
Thanks
Mads Fog Albrechtslund
Technical consultant
Artwork-Systems Nordic A/S
Denmark
_______________________________________________
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