Is there a way with AppleScript to edit a sheet (change or add cells) without the sheet being open in a window?
You can both get and set the “cells” property of records.
Getting the “cells” property of a sheet record works fine, but trying to set the property doesn’t work for me. Moreover, the existing data is lost, as are the column definitions. I can’t get into the dialog to edit columns after trying to set the cells through script. I can add a new column through that specific dialog, after which I can edit the columns again.
Let me know if you need more for a repro. Thanks.
Please send both (!) the script and the sheet to cgrunenberg - at - devon-technologies.com, thanks.
This hasn’t happened for a couple weeks now. I’ll send an email with a repro script and db if it starts happening again. Thanks.