Re: Excel 2004 issue
Re: Excel 2004 issue
- Subject: Re: Excel 2004 issue
- From: Axel Luttgens <email@hidden>
- Date: Sun, 20 Dec 2009 10:55:04 +0100
Le 20 déc. 2009 à 00:36:22, 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.
Hello Paul,
It doesn't seem to work here (Excel 2004, 11.5.6 (090928) - System: 10.6.2, french, "," as decimal separator); making use of it is silently discarded:
tell application "Microsoft Excel"
set formula of selection to "9999"
formula of selection
--> "9999"
set formula of selection to "=COUNTIF(B1,4.2)"
formula of selection
--> "9999"
set formula of selection to "=COUNTIF(B1,A2)"
formula of selection
--> "9999"
set formula of selection to "=COUNTIF(B1;4,2)"
formula of selection
--> "=COUNTIF(B1;4,2)"
formula local of selection
--> "=NB.SI(B1;4,2)"
set formula of selection to "=COUNTIF(B1;A2)"
formula of selection
--> "=COUNTIF(B1;A2)"
formula local of selection
--> "=NB.SI(B1;A2)"
end tell
It also appears that, in contradiction of Jan's experience, I have to make use of the semicolon as argument separator when building a formula. Go know...
HTH,
Axel _______________________________________________
Do not post admin requests to the list. They will be ignored.
AppleScript-Users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
Archives: http://lists.apple.com/archives/applescript-users
This email sent to email@hidden