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:21:22 -0500
I used ScriptDebugger, opened the Excel dictionary, and searched for “zero”.
It is the first entry found.
XlDisplayBlanksAs
XlDisplayBlanksAs (enumeration)
CONSTANTS
Constant Description
interpolated
not plotted
zero
WHERE USED
The XlDisplayBlanksAs enumeration is used in the following ways:
display blanks as property of the chart class/record
> On Dec 13, 2024, at 7:12 PM, Gil Dawson <email@hidden> wrote:
>
> Thanks, S.J.--
>
> That must be the problem, indeed.
>
> Where did you find the "Applescript dictionary for Excel"?
>
> I looked in the .sdef for Excel via Script Editor's "Open Dictionary" and
> found the window property "display zeros", but not "zero" itself.
>
> Thanks for the explanation, S.J.
>
> --Gil
>
>> On Dec 13, 2024, at 4:01 PM, S. J. Cunningham via AppleScript-Users
>> <email@hidden> wrote:
>>
>> 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
>
_______________________________________________
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