HOW TO HAVE A NUMBERS FORMULA LISTED AS ROW & COLUMN ON SPREAD SHEET
How to display Numbers formulas by row and column?
Posted on Oct 23, 2026 6:50 AM
HOW TO HAVE A NUMBERS FORMULA LISTED AS ROW & COLUMN ON SPREAD SHEET
Posted on Oct 23, 2026 6:50 AM
Oct 23, 2026 10:38 AM in response to tom-formula
Would this work?
tell application "Numbers Creator Studio"
tell front document
set outText to ""
tell active sheet
repeat with thisTable in tables
tell thisTable
repeat with thisCell in cells of selection range
if formula of thisCell does not contain missing value then
set outText to outText & (thisTable's name) & "::" & (thisCell's name) & ":" & thisCell's formula & linefeed
end if
end repeat
end tell
end repeat
end tell
end tell
end tell
display dialog outText
return
Result for a selected range of cells:
Tested: Numbers 15.4, macOS 27.0.1
Oct 23, 2026 10:18 AM in response to tom-formula
What do you mean by '... listed as row and column...'?
I'm trying to imagine what you mean by that, but I'm at a loss... spreadsheets inherently use tables broken into rows and columns, so that's kind of a prerequisite...
Can you give an example of what it is you're trying to do. Maybe then someone can suggest a solution.
Originally posted at discussions.apple.com/thread/256381542