Function's Languages Are Mixed Up Using Apple Script

P

petitesoeur

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel Hi all,

a rather bizarre problem occurred to me
(I use a German version of Excel on a German OS platform):

1. The cell should show a different content depending of the last month of a quarter. Its function checks if the current month can be divided by 3 without remainder (= end of quarter):

WENN(ISTUNGERADE(MONAT(JETZT())/3);-9;"[-9")

{in English, hopefully: IF(ISODD(MONTH(NOW())/3);-9;"[-9")}

After I run the Apple Script (which only sets the window size & place) the formula is changed _always_ to a language mixed-up version (German/English):
WENN(ISODD(MONAT(JETZT())/3);-9;"[-9")

Result: #value-Error.

I know, that different languages cannot be mixed up in a cascade of functions. But the script does this by itself.

Note: if I open the file manually, no changes in cell content, no errors. (But, unfortunately, I have to use scripting.)

Any idea, a workaround?
 
J

John McGhie

Why do you need the ISODD function?

What about simply MOD, or even "> 0"?

=IF(MOD(MONTH(NOW()),3)=0,"[-9","")

Cheers

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel
Hi all,

a rather bizarre problem occurred to me
(I use a German version of Excel on a German OS platform):

1. The cell should show a different content depending of the last month of a
quarter. Its function checks if the current month can be divided by 3 without
remainder (= end of quarter):

WENN(ISTUNGERADE(MONAT(JETZT())/3);-9;"[-9")

{in English, hopefully: IF(ISODD(MONTH(NOW())/3);-9;"[-9")}

After I run the Apple Script (which only sets the window size & place) the
formula is changed _always_ to a language mixed-up version (German/English):
WENN(ISODD(MONAT(JETZT())/3);-9;"[-9")

Result: #value-Error.

I know, that different languages cannot be mixed up in a cascade of functions.
But the script does this by itself.

Note: if I open the file manually, no changes in cell content, no errors.
(But, unfortunately, I have to use scripting.)

Any idea, a workaround?

This email is my business email -- Please do not email me about forum
matters unless you intend to pay!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top