What is "zero" in Excel?
What is "zero" in Excel?
- Subject: What is "zero" in Excel?
- From: Gil Dawson via AppleScript-Users <email@hidden>
- Date: Fri, 13 Dec 2024 13:42:35 -0800
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