Re: What is "zero" in Excel?
Re: What is "zero" in Excel?
- Subject: Re: What is "zero" in Excel?
- From: "S. J. Cunningham via AppleScript-Users" <email@hidden>
- Date: Fri, 13 Dec 2024 19:01:16 -0500
If you look in the Applescript dictionary for Excel you will see that “zero” is
a constant. Perhaps that is the problem.
> On Dec 13, 2024, at 4:42 PM, Gil Dawson via AppleScript-Users
> <email@hidden> wrote:
>
> Hi--
>
> Using Script Editor 2.11 (AppleScript 2.0) and Excel 16.90 running Sequoia
> 15.1.1 in my MacBook Air M1, 2020...
>
> Debugging an AppleScript/Excel project, I pared down a bug to this
> construction:
>
> tell application "Microsoft Excel"
>
> log "(zero = 0)=" & (zero = 0)
>
> end tell
>
> (*(zero = 0)=false*)
>
> I expected Excel to find the variable "zero" to be "undefined".
> AppleScript does:
>
> log "zero=" & zero
>
> tell application "Microsoft Excel"
>
> log "(zero = 0)=" & (zero = 0)
>
> end tell
>
> Result:
> error "The variable zero is not defined." number -2753 from "zero"
>
>
> Moreover, defining "zero" seems not to change the result:
>
> property zero : 0
>
> tell application "Microsoft Excel"
>
> log "(zero = 0)=" & (zero = 0)
>
> end tell
>
> (*(zero = 0)=false*)
>
> Other variable names (besides "zero") seem to work as I expect.
>
> property toll : 0
>
> tell application "Microsoft Excel"
>
> log "(toll = 0)=" & (toll = 0)
>
> end tell
>
> (*(toll = 0)=true*)
>
> I'd appreciate an explanation.
>
> --Gil
> _______________________________________________
> 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
_______________________________________________
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