tell application "Numbers"
tell table 1 of sheet 1 of front document
--Note: Daylight Saving Time started 2016-03-27
set value of cell 1 of row 1 to "2016-03-25"
--return short date string of (get value of cell 1 of row 1)
set xx to formula of cell "C1"
log xx (*= ""&A1*)
log (get value of cell "C1")
set formula of cell "D1" to "= " & quote & quote & "&A1"
--> error "Erreur dans Numbers : Il est impossible de régler formula of cell à \"= \\\"\\\"&A1\"." number -10006 from formula of cell
return value of cell "D1" -- ""
end tell
end tell
You will see that the given formula converts the date into a string which is correctly extracted.
I'm just puzzled by the fact that I don't retrieve the correct syntax to urge the script to insert the formula.
As you may see, my late attempt failed with error #-10006.