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)

Posted on Oct 15, 2015 8:36 AM

Reply
4 replies

Oct 15, 2015 1:20 PM in response to lmsmac

You can use the following script to list the formulas in every table in a document:


  1. Copy-paste the script below into Script Editor (in Applications > Utilities).
  2. With the document open, click the 'run' button.


It will look something like this:


User uploaded file


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

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Formula list.

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.