Apple

If you can tell me which localized version of Excel you have (or which country you bought it in) and confirm that it uses the semicolon in 2008 in formulas, I'll make inquiries. It's some sort of bug.

This sentence is not related to AppleScript but only to Excel.

It's why I asked "Why describe that as a bug ?"

The use of semi-colon in Excel is the normal behavior in Countries using the decimal comma.

As Microsoft products aren't allowed to enter my machines, I don't know how the pair AppleScript + Excel behaves.

Given what Jan Bultereys wrote in its second message, it appears that Excel 2004 and Excel 2008 behave differently.

He wrote that in its script, with 2004 he was forced to use

"=COUNTIF(C8:C600;A2)"

and that with 2008 he is forced to use

"=COUNTIF(C8:C600,A2)"

Given that, I guess that like Axel Luttgens he is using Excel in English on a system using the decimal comma.

It seems that you missed that I took care to write :

I don't know for Excel 2008 but I know spreadsheets whose functions names are localized : Excel v5.x, openOffice, neoOffice, AppleWorks, Numbers

All the SS which I named are using the semi-colon in countries using the decimal comma. I never used XL v5 with Applescript so I don't know if it required the semi-colon in the scripts driving it.

I take care to write about products which I know, not about those which I don't know.

Given your late messages, it's now clear that your original sentence was meaning:

If you can tell me which localized version of Excel you have (or which country you bought it in) and confirm that it uses the semicolon in 2008 in formulas built in AppleScript , I'll make inquiries. It's some sort of bug.

If the original sentence was embedding the reference to Applescript, I would not have posted about it.

Yvan KOENIG (VALLAURIS, France) dimanche 20 décembre 2009 13:03:31

References:
	>Re: Excel 2004 issue (From: Paul Berkowitz <email@hidden>)