Podcast #128: We chat with Kent C Dodds about why he loves React and discuss what life was like in the dark days before Git. Listen now.

Hot answers tagged

4

You can extend the formula to check whether the value in the column to the left is empty or not: =if(j3>0;sum(h$2:h3);"")


4

You can use the module function for this. In A2 enter =MOD(A1;1000)


2

You’re trying to define the filePath variable by combining a Posix path string with an HFS string. Try defining the filePath variable like this… set filePath to (path to library folder from user domain as text) & ¬ "Mobile Documents:com~apple~Numbers:Documents:Budget.numbers" tell application "Numbers" open alias filePath end tell OR.. My ...


1

Numbers is free from the app store, so reinstalling should not be a problem.


1

Here is a simplified example, showing minimal code, to replicate what's shown in your OP, and as you can see in the Replies pane of Script Editor in the image further below there are no errors and both display dialog commands returned the expected value. Numbers Document Example AppleScript code: set transferValue to 0 tell application "Numbers" to ¬ ...


Only top voted, non community-wiki answers of a minimum length are eligible