使用场景:
Numbers中有许多空白单元格,但是由于计算需要不能留空,需要填0,所以使用apple script处理,chatGPT写的,实测成功。要是自己写还不知道要掉多少头发…
tell application "Numbers"
tell front document
tell active sheet
tell (first table whose selection range's class is range)
set selectedRange to selection range
set startRow to (first row of selectedRange)'s address
set endRow to (last row of selectedRange)'s address
set startColumn to (first column of selectedRange)'s address
set endColumn to (last column of selectedRange)'s address
repeat with i from startRow to endRow
repeat with j from startColumn to endColumn
set cellValue to value of cell i of column j of it
if cellValue is missing value then
set value of cell i of column j of it to 0
end if
end repeat
end repeat
end tell
end tell
end tell
end tell