Formula list.
Hi,
Numbers 9 had a "formula list" to view all formulas in the spreadsheet/s.
Is there something similar in the 3.5.3 version of Numbers?
Thanks LM
iMac (21.5-inch Mid 2011), OS X Yosemite (10.10)
Hi,
Numbers 9 had a "formula list" to view all formulas in the spreadsheet/s.
Is there something similar in the 3.5.3 version of Numbers?
Thanks LM
iMac (21.5-inch Mid 2011), OS X Yosemite (10.10)
I am not aware of a way to see the list of formulas in Number 3.x
Thanks Wayne.
LM
you can post feedback to Apple using the menu item "Numbers > Provide Numbers Feedback"
You can use the following script to list the formulas in every table in a document:
It will look something like this:
This is just a quick way to do it. The script can easily be modified to change the order/format of the listing. It can also be made into a entry in the Numbers > Services menu and attached to a keyboard shortcut.
SG
--The script:
tell application "Numbers"
set formulaStr to ""
tell front document
repeat with aSheet in sheets
set formulaStr to formulaStr & "Sheet: " & aSheet's name & return & return
repeat with aTable in aSheet's tables
set formulaStr to formulaStr & " Table: " & aTable's name & return
repeat with aCell in aTable's cells
if aCell's formula is not missing value then ¬
set formulaStr to ¬
formulaStr & " " & aCell's name & " : " & aCell's formula & return
end repeat
set formulaStr to formulaStr & return
end repeat
end repeat
end tell
end tell
formulaStr
Formula list.