How can I get a list of all formulas used in a table?
I use the latest version of both OS and Numbers and would like to learn how to make a list or overview of all formulas used in a table.
iMac, OS X El Capitan (10.11.1), Number version 3.6.1
A short script can produce something like this:
- Copy-paste the script below into Script Editor (in Applications > Utilities).
- Click in any cell in the table you want to examine.
- Click the triangle run button in Script Editor.
This is easily customized to provide a string for pasting into a Numbers table or even creating a new Numbers table containing the list of formulas.
SG
tell application "Numbers"
tell front document
tell active sheet
tell (first table whose selection range's class is range)
set fStr to ""
repeat with c in cells
tell c
if formula is not missing value then ¬
set fStr to fStr & name & ":" & tab & formula & return
end tell
end repeat
end tell
end tell
end tell
end tell
display dialogfStrbuttons "Ok"