Re: Sort a range of rows in Numbers.
Re: Sort a range of rows in Numbers.
- Subject: Re: Sort a range of rows in Numbers.
- From: KOENIG Yvan <email@hidden>
- Date: Sun, 1 Feb 2009 16:16:09 +0100
Le 1 févr. 2009 à 15:58, Michelle Steiner a écrit :
On Feb 1, 2009, at 6:56 AM, KOENIG Yvan wrote:
Maybe some of you may have a better idea allowing me to really
work with knownSyntax set to true.
The problem, of course, is defining the range. By experiment, I
found that a range is defined as a string containing two cells
separated by a colon, e.g.:
tell application "Numbers"
tell document 1
tell sheet 1
tell table 1
range 1
end tell
end tell
end tell
end tell
--> {format:automatic, font name:"HelveticaNeue", alignment:center,
font size:10.0, name:"A1:A1", class:range, text color:{0, 0, 0},
background color:{59111, 59111, 59111}, vertical alignment:top,
text wrap:true}
Note that the range's name is "A1:A1".
This leads me to believe that the following script should work for
a table containing rows 2 through 13:
tell application "Numbers"
tell document 1
tell sheet 1
tell table 1
sort by column 2 direction descending in rows "2:13"
end tell
end tell
end tell
end tell
Unfortunately, it doesn't.
--> "Numbers got an error: Bad sort range."
Thanks Michelle.
I forgot to write that I tested with "A2:A44" and with "2:44"
When I type = in a cell and select a few rows, I get =5:10 in the
formula editor.
Yvan KOENIG (from FRANCE dimanche 1 février 2009 16:15:33)
_______________________________________________
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