Benches Uncategorized

1

Numbers '09 value of a cell

apple Verified

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.

  1. 0

    Apple Support Community member

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Btw, I meant to say a list of Applescript objects with the properties cellName and formula.