I'm trying to write a numbers script (to do this, as it happens), in which I need to change the value of a cell.
However, if I do something like
tell application "Numbers" activate tell document 1 tell sheet 3 set the value of cell "E1" to 1000 end tell end tell end tell
then I get the error
error "Numbers got an error: Can’t set cell \"E1\" of sheet 3 of document 1 to 1000." number -10006 from cell "E1" of sheet 3 of document 1
but this contains no information about why it can't set that cell. The document, the sheet and the cell all exist.
I guess this might depend on my particular spreadsheet, but is this the correct way to set the value of a cell, and if so, what else can I do to understand why it's not working?
error "Numbers got an error: Can’t get cell \"A1\" of sheet 1 of document 1." number -1728 from cell "A1" of sheet 1 of document 1(I'll edit all this into the question later)