Apple

Le 20 déc. 2009 à 00:36, Paul Berkowitz a écrit :

I'm very curious to know whether that "=COUNTIF(C8:C600,4.2)" works in Excel or whether there is a workaround that works.

As I am curtious too, I downloaded the trial version of Office 2008 (the French one).

I ran the original script:

tell application "Microsoft Excel"

tell active sheet of active workbook

set inputFormula to "=COUNTIF(C8:C50;A2)"

set formula of cell "D2" to inputFormula

end tell

The result is an infamous "#NOM?" error.

Just for see, I tried to replace the semi-colon by a comma and of course got the same error.

Then I tried "=NB.SI(C8:C50,A2)" and got the same error.

At last I tried "=NB.SI(C8:C50;A2)"

and Hurrah it behaves flawlessly.

So, your sentence:

From what I can see, Excel has taken the opposite route, and maintains one single vocabulary for all AppleScript versions, even where the UI maintains different versions for different languages, yes?

was wrong !

Excel behaves exactly like Numbers, it requires the use of the localized parameters delimiter and the use of the localized functions names !

As you could saw in my late message, I was ready to accept that I was wrong but I wasn't !

To be able to write scripts usable worldwide with Excel, we must be able to grab:

(1) the decimal separator to define the current parameters delimiter (easy task)

(2) the localized functions names. As I'm not really interested by Excel scripting, I didn't search where are stored these names.

Yvan KOENIG (VALLAURIS, France) dimanche 20 décembre 2009 20:07:35