Numbers '09 value of a cell
Imported from the Apple Support Forums via the Wayback Machine 🔗
I'm not liking Numbers and value of a cell. I would like to do something like this.
tell application "Numbers" to tell weeklyDoc to tell sheet 1 to tell table 1
set the value of (cell 2 of column 1) to "=A1"
--some additional scripting goes by, now I want to change the sum in B1.
--I would like to do something like this
set the value of (cell 2 of column 1) to get value (cell 2 of column 1) & "+ B1"
-- but I can't because get value (cell 2 of column 1) would return the calculated value,
-- not the content
end tell
AppleWorks had a formula property for cells which seems to be more powerful and versatile. But I don't have that.
Since I will have multiple cells to track, I am going to implement a list of properties {cellName, formulaString} and track things myself.
Anyone suggest a better way?
1 reply
Sign in or join Beachball Help to reply.
- 0