Using Applescript to Copy a Table Across Sheets

set value of cell 1 of row 1 of table “X” of sheet “B” to (value of cell 1 of row 1 of table “X” of sheet “A”)

or

set a_val to value of cell 1 of row 1 of table “X” of sheet “A”
set value of cell 1 of row 1 of table “X” of sheet “B” to a_val

or

tell sheet "A" to tell table "X"
set a_val to value of cell 1 of row 1
end tell
tell sheet "B" to tell table "X"
set value of cell 1 of row 1 to a_val
end tell

The late one is ready to expand to the transfer of several cells.

Yvan KOENIG (VALLAURIS, France) mercredi 30 mars 2011 19:00:36

I forgot to write that you must ALWAYS coerce values to strings.

set value of cell 1 of row 1 of table “X” of sheet “B” to (value of cell 1 of row 1 of table “X” of sheet “A”) as text

or

set a_val to value of cell 1 of row 1 of table “X” of sheet “A”
if class of a_val is date then set a_val to a_val - (time to GMT)
set value of cell 1 of row 1 of table “X” of sheet “B” to a_val as text

or

tell sheet "A" to tell table "X"
set a_val to value of cell 1 of row 1
end tell
tell sheet "B" to tell table "X"
if class of a_val is date then set a_val to a_val - (time to GMT)
set value of cell 1 of row 1 to a_val as text
end tell

It's necessary for :

(1) decimal numbers because an Applescript's decimal number use always the period character as decimal separator. Coercing to string replace this standard character by the localized one which is the comma in several countries.

(2) Numbers doesn't know the object date_time of Ap^pleScript. This is why you got the error : "Numbers got an error: AppleEvent handler failed.”

Coercing the date to string (or text which is exactly the same task), you send to Numbers a known structure. As you saw, in the 2nd and 3rd pieces of code, I substract the value (time to GMT) when a value is a date_time one. It's required to take care of the Numbers internal behavior.

Yvan KOENIG (VALLAURIS, France) mercredi 30 mars 2011 20:29:40