Re: Becoming part of Gnome Office

[Brian Bruns <camber ais org>]

On Wed, 1 Jan 2003, Jody Goldberg wrote:

> On Wed, Jan 01, 2003 at 09:52:16PM -0500, Brian Bruns wrote:
> > 
> > What is gnumeric doing as far as running embedded VB stuff?
> With the death of gb we're waiting to see what shakes out of Mono at
> this point.
> 
> > Speaking of which, are there any OLE experts on this list? I have some 
> > data that might be OLE but I'm having a bit of trouble deciphering it.
> That would be me.  What have you got ?
>

Here's a table properties thing stored in the LvProp column (an OLE 
column) of the MSysObjects table.  I can parse it apart pretty well, but 
if it's OLE I'm hoping to use some standard libraries to deal with it, but 
alas have not had much success.  A hex dump follows:
 
0000  4b 4b 44 00 ac 00 00 00  80 00 08 00 46 69 6c 74   KKD.........Filt
0010  65 72 4f 6e 0b 00 44 65  73 63 72 69 70 74 69 6f   erOn..Descriptio
0020  6e 07 00 4f 72 64 65 72  4f 6e 1a 00 44 61 74 61   n..OrderOn..Data
0030  73 68 65 65 74 47 72 69  64 6c 69 6e 65 73 42 65   sheetGridlinesBe
0040  68 61 76 69 6f 72 0b 00  43 6f 6c 75 6d 6e 57 69   havior..ColumnWi
0050  64 74 68 0b 00 43 6f 6c  75 6d 6e 4f 72 64 65 72   dth..ColumnOrder
0060  0c 00 43 6f 6c 75 6d 6e  48 69 64 64 65 6e 07 00   ..ColumnHidden..
0070  43 61 70 74 69 6f 6e 0c  00 46 69 6c 74 65 72 4c   Caption..FilterL
0080  6f 6f 6b 75 70 08 00 52  65 71 75 69 72 65 64 0f   ookup..Required.
0090  00 41 6c 6c 6f 77 5a 65  72 6f 4c 65 6e 67 74 68   .AllowZeroLength
00a0  0e 00 44 69 73 70 6c 61  79 43 6f 6e 74 72 6f 6c   ..DisplayControl
00b0  51 00 00 00 00 00 06 00  00 00 00 00 09 00 00 01   Q...............
00c0  00 00 01 00 00 2a 00 01  0a 01 00 22 00 53 68 69   .....*.....".Shi
00d0  70 70 65 72 73 27 20 6e  61 6d 65 73 20 61 6e 64   ppers' names and
00e0  20 70 68 6f 6e 65 20 6e  75 6d 62 65 72 73 2e 09    phone numbers..
00f0  00 00 01 02 00 01 00 00  09 00 00 02 03 00 01 00   ................
0100  03 86 00 00 00 01 00 0f  00 00 00 09 00 53 68 69   .............Shi
0110  70 70 65 72 49 44 35 00  01 0a 01 00 2d 00 4e 75   pperID5.....-.Nu
0120  6d 62 65 72 20 61 75 74  6f 6d 61 74 69 63 61 6c   mber automatical
0130  6c 79 20 61 73 73 69 67  6e 65 64 20 74 6f 20 6e   ly assigned to n
0140  65 77 20 73 68 69 70 70  65 72 2e 0c 00 00 03 04   ew shipper......
0150  00 04 00 83 04 00 00 0c  00 00 03 05 00 04 00 00   ................
0160  00 00 00 09 00 00 01 06  00 01 00 00 12 00 01 0c   ................
0170  07 00 0a 00 53 68 69 70  70 65 72 20 49 44 09 00   ....Shipper ID..
0180  01 02 08 00 01 00 01 92  00 00 00 01 00 11 00 00   ................
0190  00 0b 00 43 6f 6d 70 61  6e 79 4e 61 6d 65 21 00   ...CompanyName!.
01a0  01 0a 01 00 19 00 4e 61  6d 65 20 6f 66 20 73 68   ......Name of sh
01b0  69 70 70 69 6e 67 20 63  6f 6d 70 61 6e 79 2e 09   ipping company..
01c0  00 01 01 09 00 01 00 01  09 00 01 01 0a 00 01 00   ................
01d0  00 0c 00 00 03 04 00 04  00 81 06 00 00 0c 00 00   ................
01e0  03 05 00 04 00 00 00 00  00 09 00 00 01 06 00 01   ................
01f0  00 00 14 00 01 0c 07 00  0c 00 43 6f 6d 70 61 6e   ..........Compan
0200  79 20 4e 61 6d 65 0a 00  01 03 0b 00 02 00 6d 00   y Name........m.
0210  09 00 01 02 08 00 01 00  01 8f 00 00 00 01 00 0b   ................
0220  00 00 00 05 00 50 68 6f  6e 65 0c 00 00 03 04 00   .....Phone......
0230  04 00 a0 05 00 00 0c 00  00 03 05 00 04 00 00 00   ................
0240  00 00 09 00 00 01 06 00  01 00 00 38 00 01 0a 01   ...........8....
0250  00 30 00 50 68 6f 6e 65  20 6e 75 6d 62 65 72 20   .0.Phone number
0260  69 6e 63 6c 75 64 65 73  20 63 6f 75 6e 74 72 79   includes country
0270  20 63 6f 64 65 20 6f 72  20 61 72 65 61 20 63 6f    code or area co
0280  64 65 2e 09 00 01 01 09  00 01 00 00 09 00 01 01   de..............
0290  0a 00 01 00 00 0a 00 01  03 0b 00 02 00 6d 00 09   .............m..
02a0  00 01 02 08 00 01 00 00                            ........