javascriptmacosnumbers
It's always annoyed me that I can't write a custom function for Numbers. It would make the spreadsheet so much more useful to me. In Google Apps spreadsheets you can do it, using Javascript.
In other words, you write
function myCustomStuff(a, b) { ... }
and a cell can contain:
=myCustomStuff(A1, B2)
Now, in Yosemite, they have Javascript automation. I wonder if it's possible.
(⌥OptionEnter↩).
Or just return if you've unchecked Return key moves to next cell in the inspector:
use this AppleScript ▼
--finds next next blank (or non-blank) cell in column
--select starting cell, and run
property searchFor : missing value
tell application "Numbers"
set t to front document's active sheet's first table whose selection range's class is range
tell t's selection range
set currentRow to its first cell's row's address
set searchCol to its first cell's column's address
end tell
tell t's column searchCol
repeat with i from currentRow + 1 to count cells
if cell i's value is searchFor then --add not if want to find non-blank
set t's selection range to cell i
return
end if
end repeat
end tell
end tell
from →
how do I move/find the next non empty cel… - Apple Community_2019-09-25
Best Answer
No - injecting a function looks to be something that isn't easily scriptable.
A simple macro might be doable and you could start with these two references:
This link is the developer documentation on how to connect the script to the Numbers app.
This automation site has for a very long time been the best place I've known to learn and implement AppleScript tools.
If you're new, you could follow the numbers tutorial in AppleScript to make sure you have a workable task and then re-code it in the new language. Then you'd need to determine the hooks in Numbers and see if your specific task is doable without utilizing the Objective-C bridge which allows lower level integration to apps on OS X.