LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #13   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 147
Default XLL, C++ and dates

joel wrote:
Dates in excel are stored a a single precision number 24 bit IEEE
standard and uses 4 bytes (32bits) to store the data. Integers were 16
bits (2 byes) but I'm told they are being stored as long which is also
32 bit.


including time in it, date is stored as double.
and there is no way to distinguish if number passed to c++ procedure is
a real double or a date.
That what i was asking for. if there is really no way to distinguish
that or simply I don't know how to do that.

and procedure to convert number into date and date into number is simple
but requires a little of bit o work. That procedure is of course
included in Excel but not available as "source code", so I was asking if
that information is somewhere so I don't have to write what is already
written.

We are at the beginning.




Characters are 1 byte (8 bit) per character but I believe the
actual storage of the string has the byte count before the actual data


yes.

(I don't think you actually see the byte count when it is passed to
another function).


strings are passed as pointers and must be prepared the same way in
XLOPER. First byte represents string length.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Linking computer dates (time) to spreadsheet dates that have formu bigisle Excel Worksheet Functions 3 January 3rd 10 08:05 PM
Stop dates from showing as numbers - when formated as dates JR Excel Discussion (Misc queries) 1 October 29th 08 04:38 PM
compare 2 tables of dates to find the preceding dates Babi Excel Worksheet Functions 3 October 28th 08 05:52 AM
how do I sort a column of random dates into Consecutive dates Rob Gibson Excel Worksheet Functions 2 June 12th 07 05:10 AM
Toggle a range of Julian dates to Gregorian Dates and Back PSKelligan Excel Programming 4 May 8th 07 05:51 AM


All times are GMT +1. The time now is 02:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"