Numbers Scriptability

[NovaScotian]

Is Numbers '09 running in Leopard AppleScriptable? It shows a dictionary, but I can't manage to get the selected cell of table 1 of sheet 1 of window 1. Have I got the tree wrong?

[renaultssoftware]

I don't think you can get the selected cell. You can get the selection range, which is about the same thing:

tell application "Numbers" to get the selection range of table 1 of sheet 1 of document 1
-- result: «class » "B3:D12" of table "Table 1" of sheet "Sheet 1" of document "Untitled" of application "Numbers"

[NovaScotian]

Thanks, Renault. That actually makes it unscriptable though. That leading «class » part means that you can't set an understandable variable to the range. For example:

set F to format of (get selection range) gets an error: "Numbers got an error: Can’t make «class " and it stops there. Ugh.

I suppose this might work in Snow Leopard, but I want the big screen on my G5 machine, not a laptop screen.

[renaultssoftware]

There is a class for the selection (range) in the sdef. I saw it earlier. :confused:

[NovaScotian]

I think the problem is the space: «class »; a bug perhaps.

[renaultssoftware]

Strangely,
tell application "Numbers" to get the class of the selection range of table 1 of sheet 1 of document 1
-- returns: range

[jeffshenk]

The following worked for me:

tell application "Numbers"
tell table 1 of sheet 1 of front document
set F to (get format of (a reference to (its selection range)))
F
end tell
end tell
--returns: checkbox

If more than one cell is selected, this returns the format for the first cell in the range.

[tw]

try:
tell application "Numbers"
get the value of every cell of the selection range of table 1 of sheet 1 of document 1
end tell
that should return a list of the values of all the cells in the selection. if there's only one cell selected, it will return a list of one item.

[NovaScotian]

Thanks, TW -- I just got there yesterday; for a single selected cell, the command must include cell 1 or cells.