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?
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?