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?