How can one display and/or print out the list of expressions and/or formulas which were used in a Numbers Spreadsheet.
It used to be very straightforward in iWorks 09.
MacBook Pro (17-inch 2.4 GHz), OS X El Capitan (10.11.4)
Numbers v3.6.1 Help menu : Formulas and Functions Help.
You may have Numbers '09 v2.3 in your Applications : iWork '09 folder. Use that.
Numbers v3.6.1 Help menu : Formulas and Functions Help.
You may have Numbers '09 v2.3 in your Applications : iWork '09 folder. Use that.
Do you mean list the formulas used in a specific document?
If so, that's really easy in Numbers 3 with a short script.
The results can be copied out of the dialog and pasted anywhere, if you need to print.
If you find this script is useful and think you will be using it again you can place it in the Script Menu or the Numbers > Services menu. If you need help on that post back.
BTW, I'd be skeptical of advice to use the old Numbers (as opposed to the old Pages). After a controversial start, Numbers 3 has evolved into a powerful app that in many important ways is more than a match for the old Numbers, including in scripting support.
SG
tell application "Numbers"
tell front document
repeat with s in sheets
set fStr to "Sheet: " & s's name & return
repeat with t in s's tables
set fStr to fStr & return & "Table: " & t's name & return
repeat with c in t's cells
tell c to if formula is not missing value then ¬
set fStr to fStr & name & ":" & tab & formula & return
end repeat
end repeat
end repeat
end tell
end tell
display dialogfStrbuttons "Ok"
Tx VikingOSX.
Unfortunately, I trashed my former iWork packages some time ago.
Do you imply in your answer that in 3.6.1 there is no easy way to print out the list of functions, equations, expressions used in a particular spreadsheet?
Thanks for your help.
I think our posts crossed each other. Yes, there is a very easy way. See post above.
SG
There is an easy way to get at the spreadsheet formulas with SGIII's script contribution, but otherwise no.
Hi Noel,
"in 3.6.1," that is correct.
The "easy way" is to use the script provided in SG's post above.
If you have a large number of formulas in your document, you may not be able to see them all in the dialog that opens to show the list, but you will be able to copy the whole list (Click in the list, press command-A to select all, Copy), then paste the result into another document (Pages, Text Edit or a text box in Numbers—whatever you want to print from.
The script is easy to use, and works well. I was a bit surprised that SG didn't send the result to the Clibboard, bypassing the need to select and copy the list, as he's done on similar scripts earlier.
Regards,
Barry
Here's the script with a line added to send the results to the clipboard (as Barry suggests) and also view it in the dialog. That way you can see the results on your screen and can also paste elsewhere as needed without having to select and copy.
This takes just one click to use, no harder than using the built-in feature in the old Numbers. No knowledge of scripting needed, just copy, paste, and click.
SG
tell application "Numbers"
tell front document
repeat with s in sheets
set fStr to "Sheet: " & s's name & return
repeat with t in s's tables
set fStr to fStr & return & "Table: " & t's name & return
repeat with c in t's cells
tell c to if formula is not missing value then ¬
set fStr to fStr & name & ":" & tab & formula & return
end repeat
end repeat
end repeat
end tell
end tell
set the clipboard tofStr
display dialogfStrbuttons "Ok"
Thank you very much. Works great!!!
In a way, it is actually better than what used to exist in iWorks 09: iWorks 09 used to add a separate additional sheet with this list-of-expressions.
With your script, it is possible to paste whatever is on the clipboard in a text-box placed in any convenient location on page 1 of the spreadsheet.
Makes much more sense. Thanks very much for your help. Greatly appreciated!
Numbers 3.6.1 List of expressions and/or formulas.
