MOD weirdness

Question

Level 1

0 points

MOD weirdness

Can anyone tell why this simple formula:

=MOD(127,60)

returns this error:

"The formula contains a function with the wrong number of arguments"

and also, why does Numbers automatically change my formula to:

=MOD(127,6)

Thanks !

MacBook Pro 15", Mac OS X (10.5.4), Model Identifier: MacBookPro1,1

Posted on Jul 24, 2008 8:51 AM

Reply

Answer 1

KOENIG Yvan

Level 8

41,807 points

Jul 24, 2008 10:13 AM in response to ianman

My guess is that you are using Numbers in English in a country whose decimal separator is the comma.

If I am right,

1 - you must use the semi-colon as parameter separator:

=MOD(127;60)

2 - it would be useful to go to my iDisk:
<http://idisk.me.com/koenigyvan-Public?view=web>

download:
for iWork:for_Numbers::pour_modifierNumbers.zip

expand it
run it to install the modified resources: Anglais_semiColon

Yvan KOENIG (from FRANCE jeudi 24 juillet 2008 19:13:19)

Reply

Answer 2

ianman Author

Level 1

0 points

Jul 26, 2008 1:44 AM in response to KOENIG Yvan

Thanks Yvan, that (solution 1) did the trick.

I tried you script but got an error.

Reply

Answer 3

KOENIG Yvan

Level 8

41,807 points

Jul 26, 2008 2:11 AM in response to ianman

ianman wrote:
I tried you script but got an error.

Which error ?

As far as I know, the only way to fool it is to move the script out of the delivered disk image.

This is why the Read me claims:
_Open the disk image and run (double click) the script without moving any file._

Just for info, which is your system language?

Yvan KOENIG (from FRANCE samedi 26 juillet 2008 11:00:38)

Reply

Answer 4

ianman Author

Level 1

0 points

Jul 29, 2008 10:51 AM in response to KOENIG Yvan

I did not move the files, so I'm running your script from the "pour modifierNumbers" disk. I open the script in Script Editor, run it an get "AppleScript Error: System events got an error: Access for assistive devices is disabled."

My system language is English.

Maybe your script should be compiled to an app, as you mention "... run (double click) the script...", but this just opens the file in a script editor.

Ian

Reply

Answer 5

KOENIG Yvan

Level 8

41,807 points

Jul 29, 2008 11:41 AM in response to ianman

You didn't activate the GUI scripting.
To do that, open the Universal acces System Preferences pane then check the box at the very bottom, the one speaking of "assistive devices".

Yvan KOENIG (from FRANCE mardi 29 juillet 2008 20:41:02)

Reply