Unofficial archive. This is a read-only, community-run archive of the Apple Support Community. It is not affiliated with or endorsed by Apple Inc.

How to display Numbers formulas by row and column?

HOW TO HAVE A NUMBERS FORMULA LISTED AS ROW & COLUMN ON SPREAD SHEET



2 replies

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

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.