How to set the format of range in Numbers by JXA

Question

Level 1

8 points

How to set the format of range in Numbers by JXA

How to set the format of range in JXA like the following AppleScript code?


tell application "Numbers"
    activate
    tell document 1
        tell active sheet
            tell table 1
                set the format of range "A2:B2" to currency
            end tell
        end tell
    end tell
end tell

I can't find the documentation related to enumeration in JXA. The format property is enumeration.

table.ranges["A2:B2"].format = "currency"

This code will trigger error (invalid format value).

MacBook Pro 13", macOS 10.14

Posted on May 8, 2019 1:10 AM

Reply

Answer 1

Best reply

SGIII

Level 8

35,258 points

May 15, 2019 5:36 AM in response to caichicong

Javascript is easier to use than applescript

Not easier to use if the Javascript is as poorly implemented and documented as JXA seems to be!

One can do certain things such as setting values in cells and sorting and so forth, but, as you've discovered, formats don't seem to be recognized.

Better to use AppleScript that works than JXA that is full of "gotchas."

If you're finding AppleScript hard to use with Numbers feel free to post questions.

SG

Reply

Answer 2

SGIII

Level 8

35,258 points

May 15, 2019 5:21 AM in response to caichicong

As I think people have responded to you on the developer forum and elsewhere, best stick with AppleScript. JXA is very much a "work in progress" and not well documented.

SG

Reply

Answer 3

caichicong Author

Level 1

8 points

May 15, 2019 5:29 AM in response to SGIII

You're right. JXA is not not well documented. But Javascript is easier to use than applescript.

Reply

How to set the format of range in Numbers by JXA

Similar questions