Floating point limits in AppleScript
Floating point limits in AppleScript
- Subject: Floating point limits in AppleScript
- From: Doug McNutt <email@hidden>
- Date: Mon, 15 Dec 2008 12:25:05 -0700
At 11:00 -0800 12/15/08, Paul Berkowitz wrote, in another thread:
Excel functions are not AppleScriptable as they are in VBA (apparently this
had to do with incompatibility of floating point precision, which is better
in Excel than in AppleScript).
Wow. I do know that Excel 2001 on this Mac 8500 uses the floating
point hardware at 80 bits internal and stores the results as
"doubles" which are a sign, a 52 bit mantissa, and an 11 bit
exponent.
I also know that AppleScript limits integers to less than +/- 2^31 so
it can have some kind of flag bit. Larger numbers get converted to
floating doubles but is there a way to force that conversion for
smaller integers? Excel would need that if binary values are used in
processing AppleEvents.
But does AppleScript limit floats in a similar way? Do newer
versions of Excel store type extended? I doubt it.
--
--> In Christianity, man can have only one wife. This is known as monotony. <--
_______________________________________________
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