Daniel Noll wrote:
 00 00 e1 2e 1c 00 00 00    Record, type = 12001, length = 28
 Next 28 bytes are god-knows what, but I'm thinking the comment date
 has to be in here somewhere as PowerPoint knows what time the comment
 was added.
     01 00 00 00 d6 07 01 00 02 00 18 00 10 00 0e 00
     34 00 d4 01 0a 00 00 00 0a 00 00 00

Disassembling this a bit:

  First four bytes:
  01 00 00 00     = 1 (comment number?  It was 2, 3, 4 on the next three
                       comments.)

  Next 16 bytes is a datetime structure:
  d6 07           = 2006 (year)
  01 00           = 1 (month, January)
  02 00           = 2 (day of week?  comment was made on Tuesday.)
  18 00           = 24 (day of month)
  10 00           = 16 (hour)
  0e 00           = 14 (minute)
  34 00           = 52 (second)
  d4 01           = 468 (milliseconds??)
  0a 00 00 00     ?
  0a 00 00 00     ?

Does this look about right? I've never seen an application store dates in such a fashion. As ACSII, yes... as 64-bit little-endian numbers, yes... but not like this.

The last two integers seem to be identical on all the comments I tested today (actually, every comment has different values, but the two values were equal to each other) but I've seen them being different on my original test comments. I can't immediately see what they mean, but perhaps this data can just be left sitting around as a byte[] once the other data is parsed out.

Knowing my luck, HSLF already has some logic somewhere for converting this structure into a Java date and I just wasted my time. ;-)

I probably should bring this thread over to the dev list anyway, huh... most of the people here probably don't care about how PowerPoint stores its wacky dates. :-)

Daniel


--
Daniel Noll

Nuix Australia Pty Ltd
Suite 79, 89 Jones St, Ultimo NSW 2007, Australia
Phone: (02) 9280 0699
Fax:   (02) 9212 6902

This message is intended only for the named recipient. If you are not
the intended recipient you are notified that disclosing, copying,
distributing or taking any action in reliance on the contents of this
message or attachment is strictly prohibited.

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/

Reply via email to