AppleScript creation for use on Numbers

Question

Level 1

4 points

AppleScript creation for use on Numbers

Good evening guys, I would need an Apple script to paste on Automator to create a quick action that allows me, on Numbers, to transform the formula present on a cell, in text format in that same cell. so the script must perform these steps:

1) double click on the cell

2) press the function symbol on the left

3) once you open that drop-down menu you have to select on "convert formula to text in cell).

A few months ago you already helped me with the opposite script to this that I am asking now, namely the text in the cell to be converted into an active formula And you succeeded, so now I am asking exactly the opposite, thank you. please guys

MacBook Air 13″, macOS 14.6

Posted on Sep 7, 2024 3:13 PM

Reply

Answer 1

Top-ranking reply

Badunit

Level 7

28,324 points

Sep 7, 2024 3:51 PM in response to Yuri2302

tell application "Numbers"
	tell front document to tell active sheet
		tell (first table whose selection range's class is range)
			repeat with aCell in (get selection range)'s cells
				set theformula to formula of aCell
				set value of aCell to text 2 thru end of theformula
			end repeat
		end tell
	end tell
end tell

Reply