Nishant, Apparently, remote formulas are not supported currently by HSSF.
Could you add an entry in bugzilla for this? Also, if possible attach an excel workbook containing a sheet with the said formula that is created via MS Excel so that any fix can be tested against that file. Regards, ~ amol > -----Original Message----- > From: Nishant Chandra [mailto:[EMAIL PROTECTED] > Sent: Tuesday, June 14, 2005 7:24 AM > To: Avik Sengupta > Cc: [email protected] > Subject: Re: Remote reference formula support > > > yes its a pipe character and its supported in excel. > heres what biffviewer gave me for the remote reference formula > =blp|m!'MSFT US Equity,[LAST_TRADE]' : > > > Offset 0x0 (0) > recordid = 0x809, size = 16 > [BOF RECORD] > .version = 600 > .type = 5 > .build = 1cfe > .buildyear = 1997 > .history = 40c9 > .requiredversion = 106 > [/BOF RECORD] > > Offset 0x14 (20) > recordid = 0xe1, size = 2 > [INTERFACEHDR] > .codepage = 4b0 > [/INTERFACEHDR] > > Offset 0x1a (26) > recordid = 0xc1, size = 2 > [MMS] > .addMenu = 0 > .delMenu = 0 > [/MMS] > > Offset 0x20 (32) > recordid = 0xe2, size = 0 > [INTERFACEEND] > [/INTERFACEEND] > > Offset 0x24 (36) > recordid = 0x5c, size = 112 > [WRITEACCESS] > .name = UPSILON S.A. > [/WRITEACCESS] > > Offset 0x98 (152) > recordid = 0x42, size = 2 > [CODEPAGE] > .codepage = 4b0 > [/CODEPAGE] > > Offset 0x9e (158) > recordid = 0x161, size = 2 > [DSF] > .isDSF = 0 > [/DSF] > > -----UNKNOWN---------------------------------- > **NO RECORD DATA** > -----UNKNOWN---------------------------------- > Offset 0xa8 (168) > recordid = 0x13d, size = 4 > [TABID] > .elements = 2 > .element_0 = 1 > .element_1 = 0 > [/TABID] > > Offset 0xb0 (176) > recordid = 0x9c, size = 2 > [FNGROUPCOUNT] > .count = 14 > [/FNGROUPCOUNT] > > Offset 0xb6 (182) > recordid = 0x19, size = 2 > [WINDOWPROTECT] > .protect = false > [/WINDOWPROTECT] > > Offset 0xbc (188) > recordid = 0x12, size = 2 > [PROTECT] > .protect = false > [/PROTECT] > > Offset 0xc2 (194) > recordid = 0x13, size = 2 > [PASSWORD] > .password = 0 > [/PASSWORD] > > Offset 0xc8 (200) > recordid = 0x1af, size = 2 > [PROT4REV] > .protect = false > [/PROT4REV] > > Offset 0xce (206) > recordid = 0x1bc, size = 2 > [PROT4REVPASSWORD] > .password = 0 > [/PROT4REVPASSWORD] > > Offset 0xd4 (212) > recordid = 0x3d, size = 18 > [WINDOW1] > .h_hold = 168 > .v_hold = 10e > .width = 3a5c > .height = 23be > .options = 38 > .hidden = false > .iconic = false > .hscroll = true > .vscroll = true > .tabs = true > .selectedtab = 1 > .displayedtab = 0 > .numselectedtabs = 1 > .tabwidthratio = 258 > [/WINDOW1] > > Offset 0xea (234) > recordid = 0x40, size = 2 > [BACKUP] > .backup = 0 > [/BACKUP] > > Offset 0xf0 (240) > recordid = 0x8d, size = 2 > [HIDEOBJ] > .hideobj = 0 > [/HIDEOBJ] > > Offset 0xf6 (246) > recordid = 0x22, size = 2 > [1904] > .is1904 = 0 > [/1904] > > Offset 0xfc (252) > recordid = 0xe, size = 2 > [PRECISION] > .precision = true > [/PRECISION] > > Offset 0x102 (258) > recordid = 0x1b7, size = 2 > [REFRESHALL] > .refreshall = false > [/REFRESHALL] > > Offset 0x108 (264) > recordid = 0xda, size = 2 > [BOOKBOOL] > .savelinkvalues = 0 > [/BOOKBOOL] > > Offset 0x10e (270) > recordid = 0x31, size = 26 > [FONT] > .fontheight = c8 > .attributes = 0 > .italic = false > .strikout = false > .macoutlined= false > .macshadowed= false > .colorpalette = 7fff > .boldweight = 190 > .supersubscript = 0 > .underline = 0 > .family = 0 > .charset = 0 > .namelength = 5 > .fontname = Arial > [/FONT] > > Offset 0x12c (300) > recordid = 0x31, size = 26 > [FONT] > .fontheight = c8 > .attributes = 0 > .italic = false > .strikout = false > .macoutlined= false > .macshadowed= false > .colorpalette = 7fff > .boldweight = 190 > .supersubscript = 0 > .underline = 0 > .family = 0 > .charset = 0 > .namelength = 5 > .fontname = Arial > [/FONT] > > Offset 0x14a (330) > recordid = 0x31, size = 26 > [FONT] > .fontheight = c8 > .attributes = 0 > .italic = false > .strikout = false > .macoutlined= false > .macshadowed= false > .colorpalette = 7fff > .boldweight = 190 > .supersubscript = 0 > .underline = 0 > .family = 0 > .charset = 0 > .namelength = 5 > .fontname = Arial > [/FONT] > > Offset 0x168 (360) > recordid = 0x31, size = 26 > [FONT] > .fontheight = c8 > .attributes = 0 > .italic = false > .strikout = false > .macoutlined= false > .macshadowed= false > .colorpalette = 7fff > .boldweight = 190 > .supersubscript = 0 > .underline = 0 > .family = 0 > .charset = 0 > .namelength = 5 > .fontname = Arial > [/FONT] > > Offset 0x186 (390) > recordid = 0x41e, size = 30 > [FORMAT] > .indexcode = 5 > .unicode length = 19 > .isUnicode = false > .formatstring = #,##0\ "BF";\-#,##0\ "BF" > [/FORMAT] > > Offset 0x1a8 (424) > recordid = 0x41e, size = 35 > [FORMAT] > .indexcode = 6 > .unicode length = 1e > .isUnicode = false > .formatstring = #,##0\ "BF";[Red]\-#,##0\ "BF" > [/FORMAT] > > Offset 0x1cf (463) > recordid = 0x41e, size = 36 > [FORMAT] > .indexcode = 7 > .unicode length = 1f > .isUnicode = false > .formatstring = #,##0.00\ "BF";\-#,##0.00\ "BF" > [/FORMAT] > > Offset 0x1f7 (503) > recordid = 0x41e, size = 41 > [FORMAT] > .indexcode = 8 > .unicode length = 24 > .isUnicode = false > .formatstring = #,##0.00\ "BF";[Red]\-#,##0.00\ "BF" > [/FORMAT] > > Offset 0x224 (548) > recordid = 0x41e, size = 62 > [FORMAT] > .indexcode = 2a > .unicode length = 39 > .isUnicode = false > .formatstring = _-* #,##0\ "BF"_-;\-* #,##0\ > "BF"_-;_-* "-"\ "BF"_-;[EMAIL PROTECTED] > [/FORMAT] > > Offset 0x266 (614) > recordid = 0x41e, size = 62 > [FORMAT] > .indexcode = 29 > .unicode length = 39 > .isUnicode = false > .formatstring = _-* #,##0\ _B_F_-;\-* #,##0\ > _B_F_-;_-* "-"\ _B_F_-;[EMAIL PROTECTED] > [/FORMAT] > > Offset 0x2a8 (680) > recordid = 0x41e, size = 70 > [FORMAT] > .indexcode = 2c > .unicode length = 41 > .isUnicode = false > .formatstring = _-* #,##0.00\ "BF"_-;\-* #,##0.00\ "BF"_-;_-* > "-"??\ "BF"_-;[EMAIL PROTECTED] > [/FORMAT] > > Offset 0x2f2 (754) > recordid = 0x41e, size = 70 > [FORMAT] > .indexcode = 2b > .unicode length = 41 > .isUnicode = false > .formatstring = _-* #,##0.00\ _B_F_-;\-* #,##0.00\ _B_F_-;_-* > "-"??\ _B_F_-;[EMAIL PROTECTED] > [/FORMAT] > > Offset 0x33c (828) > recordid = 0x41e, size = 28 > [FORMAT] > .indexcode = a4 > .unicode length = 17 > .isUnicode = false > .formatstring = "$"#,##0_);\("$"#,##0\) > [/FORMAT] > > Offset 0x35c (860) > recordid = 0x41e, size = 33 > [FORMAT] > .indexcode = a5 > .unicode length = 1c > .isUnicode = false > .formatstring = "$"#,##0_);[Red]\("$"#,##0\) > [/FORMAT] > > Offset 0x381 (897) > recordid = 0x41e, size = 34 > [FORMAT] > .indexcode = a6 > .unicode length = 1d > .isUnicode = false > .formatstring = "$"#,##0.00_);\("$"#,##0.00\) > [/FORMAT] > > Offset 0x3a7 (935) > recordid = 0x41e, size = 39 > [FORMAT] > .indexcode = a7 > .unicode length = 22 > .isUnicode = false > .formatstring = "$"#,##0.00_);[Red]\("$"#,##0.00\) > [/FORMAT] > > Offset 0x3d2 (978) > recordid = 0x41e, size = 55 > [FORMAT] > .indexcode = a8 > .unicode length = 32 > .isUnicode = false > .formatstring = _("$"* #,##0_);_("$"* \(#,##0\);_("$"* > "-"_);_(@_) > [/FORMAT] > > Offset 0x40d (1037) > recordid = 0x41e, size = 46 > [FORMAT] > .indexcode = a9 > .unicode length = 29 > .isUnicode = false > .formatstring = _(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_) > [/FORMAT] > > Offset 0x43f (1087) > recordid = 0x41e, size = 63 > [FORMAT] > .indexcode = aa > .unicode length = 3a > .isUnicode = false > .formatstring = _("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* > "-"??_);_(@_) > [/FORMAT] > > Offset 0x482 (1154) > recordid = 0x41e, size = 54 > [FORMAT] > .indexcode = ab > .unicode length = 31 > .isUnicode = false > .formatstring = _(* #,##0.00_);_(* \(#,##0.00\);_(* > "-"??_);_(@_) > [/FORMAT] > > Offset 0x4bc (1212) > recordid = 0xe0, size = 20 > [EXTENDEDFORMAT] > STYLE_RECORD_TYPE > .fontindex = 0 > .formatindex = 0 > .celloptions = fffffff5 > .islocked = true > .ishidden = false > .recordtype= 1 > .parentidx = fff > .alignmentoptions= 20 > .alignment = 0 > .wraptext = false > .valignment= 2 > .justlast = 0 > .rotation = 0 > .indentionoptions= 0 > .indent = 0 > .shrinktoft= false > .mergecells= false > .readngordr= 0 > .formatflag= false > .fontflag = false > .prntalgnmt= false > .borderflag= false > .paternflag= false > .celloption= false > .borderoptns = 0 > .lftln = 0 > .rgtln = 0 > .topln = 0 > .btmln = 0 > .paleteoptns = 0 > .leftborder= 0 > .rghtborder= 0 > .diag = 0 > .paleteoptn2 = 0 > .topborder = 0 > .botmborder= 0 > .adtldiag = 0 > .diaglnstyl= 0 > .fillpattrn= 0 > .fillpaloptn = 20c0 > .foreground= 40 > .background= 41 > [/EXTENDEDFORMAT] > > Offset 0x4d4 (1236) > recordid = 0xe0, size = 20 > [EXTENDEDFORMAT] > STYLE_RECORD_TYPE > .fontindex = 1 > .formatindex = 0 > .celloptions = fffffff5 > .islocked = true > .ishidden = false > .recordtype= 1 > .parentidx = fff > .alignmentoptions= 20 > .alignment = 0 > .wraptext = false > .valignment= 2 > .justlast = 0 > .rotation = 0 > .indentionoptions= fffff400 > .indent = 0 > .shrinktoft= false > .mergecells= false > .readngordr= 0 > .formatflag= true > .fontflag = false > .prntalgnmt= true > .borderflag= true > .paternflag= true > .celloption= true > .borderoptns = 0 > .lftln = 0 > .rgtln = 0 > .topln = 0 > .btmln = 0 > .paleteoptns = 0 > .leftborder= 0 > .rghtborder= 0 > .diag = 0 > .paleteoptn2 = 0 > .topborder = 0 > .botmborder= 0 > .adtldiag = 0 > .diaglnstyl= 0 > .fillpattrn= 0 > .fillpaloptn = 20c0 > .foreground= 40 > .background= 41 > [/EXTENDEDFORMAT] > > Offset 0x4ec (1260) > recordid = 0xe0, size = 20 > [EXTENDEDFORMAT] > STYLE_RECORD_TYPE > .fontindex = 1 > .formatindex = 0 > .celloptions = fffffff5 > .islocked = true > .ishidden = false > .recordtype= 1 > .parentidx = fff > .alignmentoptions= 20 > .alignment = 0 > .wraptext = false > .valignment= 2 > .justlast = 0 > .rotation = 0 > .indentionoptions= fffff400 > .indent = 0 > .shrinktoft= false > .mergecells= false > .readngordr= 0 > .formatflag= true > .fontflag = false > .prntalgnmt= true > .borderflag= true > .paternflag= true > .celloption= true > .borderoptns = 0 > .lftln = 0 > .rgtln = 0 > .topln = 0 > .btmln = 0 > .paleteoptns = 0 > .leftborder= 0 > .rghtborder= 0 > .diag = 0 > .paleteoptn2 = 0 > .topborder = 0 > .botmborder= 0 > .adtldiag = 0 > .diaglnstyl= 0 > .fillpattrn= 0 > .fillpaloptn = 20c0 > .foreground= 40 > .background= 41 > [/EXTENDEDFORMAT] > > Offset 0x504 (1284) > recordid = 0xe0, size = 20 > [EXTENDEDFORMAT] > STYLE_RECORD_TYPE > .fontindex = 2 > .formatindex = 0 > .celloptions = fffffff5 > .islocked = true > .ishidden = false > .recordtype= 1 > .parentidx = fff > .alignmentoptions= 20 > .alignment = 0 > .wraptext = false > .valignment= 2 > .justlast = 0 > .rotation = 0 > .indentionoptions= fffff400 > .indent = 0 > .shrinktoft= false > .mergecells= false > .readngordr= 0 > .formatflag= true > .fontflag = false > .prntalgnmt= true > .borderflag= true > .paternflag= true > .celloption= true > .borderoptns = 0 > .lftln = 0 > .rgtln = 0 > .topln = 0 > .btmln = 0 > .paleteoptns = 0 > .leftborder= 0 > .rghtborder= 0 > .diag = 0 > .paleteoptn2 = 0 > .topborder = 0 > .botmborder= 0 > .adtldiag = 0 > .diaglnstyl= 0 > .fillpattrn= 0 > .fillpaloptn = 20c0 > .foreground= 40 > .background= 41 > [/EXTENDEDFORMAT] > > Offset 0x51c (1308) > recordid = 0xe0, size = 20 > [EXTENDEDFORMAT] > STYLE_RECORD_TYPE > .fontindex = 2 > .formatindex = 0 > .celloptions = fffffff5 > .islocked = true > .ishidden = false > .recordtype= 1 > .parentidx = fff > .alignmentoptions= 20 > .alignment = 0 > .wraptext = false > .valignment= 2 > .justlast = 0 > .rotation = 0 > .indentionoptions= fffff400 > .indent = 0 > .shrinktoft= false > .mergecells= false > .readngordr= 0 > .formatflag= true > .fontflag = false > .prntalgnmt= true > .borderflag= true > .paternflag= true > .celloption= true > .borderoptns = 0 > .lftln = 0 > .rgtln = 0 > .topln = 0 > .btmln = 0 > .paleteoptns = 0 > .leftborder= 0 > .rghtborder= 0 > .diag = 0 > .paleteoptn2 = 0 > .topborder = 0 > .botmborder= 0 > .adtldiag = 0 > .diaglnstyl= 0 > .fillpattrn= 0 > .fillpaloptn = 20c0 > .foreground= 40 > .background= 41 > [/EXTENDEDFORMAT] > > Offset 0x534 (1332) > recordid = 0xe0, size = 20 > [EXTENDEDFORMAT] > STYLE_RECORD_TYPE > .fontindex = 0 > .formatindex = 0 > .celloptions = fffffff5 > .islocked = true > .ishidden = false > .recordtype= 1 > .parentidx = fff > .alignmentoptions= 20 > .alignment = 0 > .wraptext = false > .valignment= 2 > .justlast = 0 > .rotation = 0 > .indentionoptions= fffff400 > .indent = 0 > .shrinktoft= false > .mergecells= false > .readngordr= 0 > .formatflag= true > .fontflag = false > .prntalgnmt= true > .borderflag= true > .paternflag= true > .celloption= true > .borderoptns = 0 > .lftln = 0 > .rgtln = 0 > .topln = 0 > .btmln = 0 > .paleteoptns = 0 > .leftborder= 0 > .rghtborder= 0 > .diag = 0 > .paleteoptn2 = 0 > .topborder = 0 > .botmborder= 0 > .adtldiag = 0 > .diaglnstyl= 0 > .fillpattrn= 0 > .fillpaloptn = 20c0 > .foreground= 40 > .background= 41 > [/EXTENDEDFORMAT] > > Offset 0x54c (1356) > recordid = 0xe0, size = 20 > [EXTENDEDFORMAT] > STYLE_RECORD_TYPE > .fontindex = 0 > .formatindex = 0 > .celloptions = fffffff5 > .islocked = true > .ishidden = false > .recordtype= 1 > .parentidx = fff > .alignmentoptions= 20 > .alignment = 0 > .wraptext = false > .valignment= 2 > .justlast = 0 > .rotation = 0 > .indentionoptions= fffff400 > .indent = 0 > .shrinktoft= false > .mergecells= false > .readngordr= 0 > .formatflag= true > .fontflag = false > .prntalgnmt= true > .borderflag= true > .paternflag= true > .celloption= true > .borderoptns = 0 > .lftln = 0 > .rgtln = 0 > .topln = 0 > .btmln = 0 > .paleteoptns = 0 > .leftborder= 0 > .rghtborder= 0 > .diag = 0 > .paleteoptn2 = 0 > .topborder = 0 > .botmborder= 0 > .adtldiag = 0 > .diaglnstyl= 0 > .fillpattrn= 0 > .fillpaloptn = 20c0 > .foreground= 40 > .background= 41 > [/EXTENDEDFORMAT] > > Offset 0x564 (1380) > recordid = 0xe0, size = 20 > [EXTENDEDFORMAT] > STYLE_RECORD_TYPE > .fontindex = 0 > .formatindex = 0 > .celloptions = fffffff5 > .islocked = true > .ishidden = false > .recordtype= 1 > .parentidx = fff > .alignmentoptions= 20 > .alignment = 0 > .wraptext = false > .valignment= 2 > .justlast = 0 > .rotation = 0 > .indentionoptions= fffff400 > .indent = 0 > .shrinktoft= false > .mergecells= false > .readngordr= 0 > .formatflag= true > .fontflag = false > .prntalgnmt= true > .borderflag= true > .paternflag= true > .celloption= true > .borderoptns = 0 > .lftln = 0 > .rgtln = 0 > .topln = 0 > .btmln = 0 > .paleteoptns = 0 > .leftborder= 0 > .rghtborder= 0 > .diag = 0 > .paleteoptn2 = 0 > .topborder = 0 > .botmborder= 0 > .adtldiag = 0 > .diaglnstyl= 0 > .fillpattrn= 0 > .fillpaloptn = 20c0 > .foreground= 40 > .background= 41 > [/EXTENDEDFORMAT] > > Offset 0x57c (1404) > recordid = 0xe0, size = 20 > [EXTENDEDFORMAT] > STYLE_RECORD_TYPE > .fontindex = 0 > .formatindex = 0 > .celloptions = fffffff5 > .islocked = true > .ishidden = false > .recordtype= 1 > .parentidx = fff > .alignmentoptions= 20 > .alignment = 0 > .wraptext = false > .valignment= 2 > .justlast = 0 > .rotation = 0 > .indentionoptions= fffff400 > .indent = 0 > .shrinktoft= false > .mergecells= false > .readngordr= 0 > .formatflag= true > .fontflag = false > .prntalgnmt= true > .borderflag= true > .paternflag= true > .celloption= true > .borderoptns = 0 > .lftln = 0 > .rgtln = 0 > .topln = 0 > .btmln = 0 > .paleteoptns = 0 > .leftborder= 0 > .rghtborder= 0 > .diag = 0 > .paleteoptn2 = 0 > .topborder = 0 > .botmborder= 0 > .adtldiag = 0 > .diaglnstyl= 0 > .fillpattrn= 0 > .fillpaloptn = 20c0 > .foreground= 40 > .background= 41 > [/EXTENDEDFORMAT] > > Offset 0x594 (1428) > recordid = 0xe0, size = 20 > [EXTENDEDFORMAT] > STYLE_RECORD_TYPE > .fontindex = 0 > .formatindex = 0 > .celloptions = fffffff5 > .islocked = true > .ishidden = false > .recordtype= 1 > .parentidx = fff > .alignmentoptions= 20 > .alignment = 0 > .wraptext = false > .valignment= 2 > .justlast = 0 > .rotation = 0 > .indentionoptions= fffff400 > .indent = 0 > .shrinktoft= false > .mergecells= false > .readngordr= 0 > .formatflag= true > .fontflag = false > .prntalgnmt= true > .borderflag= true > .paternflag= true > .celloption= true > .borderoptns = 0 > .lftln = 0 > .rgtln = 0 > .topln = 0 > .btmln = 0 > .paleteoptns = 0 > .leftborder= 0 > .rghtborder= 0 > .diag = 0 > .paleteoptn2 = 0 > .topborder = 0 > .botmborder= 0 > .adtldiag = 0 > .diaglnstyl= 0 > .fillpattrn= 0 > .fillpaloptn = 20c0 > .foreground= 40 > .background= 41 > [/EXTENDEDFORMAT] > > Offset 0x5ac (1452) > recordid = 0xe0, size = 20 > [EXTENDEDFORMAT] > STYLE_RECORD_TYPE > .fontindex = 0 > .formatindex = 0 > .celloptions = fffffff5 > .islocked = true > .ishidden = false > .recordtype= 1 > .parentidx = fff > .alignmentoptions= 20 > .alignment = 0 > .wraptext = false > .valignment= 2 > .justlast = 0 > .rotation = 0 > .indentionoptions= fffff400 > .indent = 0 > .shrinktoft= false > .mergecells= false > .readngordr= 0 > .formatflag= true > .fontflag = false > .prntalgnmt= true > .borderflag= true > .paternflag= true > .celloption= true > .borderoptns = 0 > .lftln = 0 > .rgtln = 0 > .topln = 0 > .btmln = 0 > .paleteoptns = 0 > .leftborder= 0 > .rghtborder= 0 > .diag = 0 > .paleteoptn2 = 0 > .topborder = 0 > .botmborder= 0 > .adtldiag = 0 > .diaglnstyl= 0 > .fillpattrn= 0 > .fillpaloptn = 20c0 > .foreground= 40 > .background= 41 > [/EXTENDEDFORMAT] > > Offset 0x5c4 (1476) > recordid = 0xe0, size = 20 > [EXTENDEDFORMAT] > STYLE_RECORD_TYPE > .fontindex = 0 > .formatindex = 0 > .celloptions = fffffff5 > .islocked = true > .ishidden = false > .recordtype= 1 > .parentidx = fff > .alignmentoptions= 20 > .alignment = 0 > .wraptext = false > .valignment= 2 > .justlast = 0 > .rotation = 0 > .indentionoptions= fffff400 > .indent = 0 > .shrinktoft= false > .mergecells= false > .readngordr= 0 > .formatflag= true > .fontflag = false > .prntalgnmt= true > .borderflag= true > .paternflag= true > .celloption= true > .borderoptns = 0 > .lftln = 0 > .rgtln = 0 > .topln = 0 > .btmln = 0 > .paleteoptns = 0 > .leftborder= 0 > .rghtborder= 0 > .diag = 0 > .paleteoptn2 = 0 > .topborder = 0 > .botmborder= 0 > .adtldiag = 0 > .diaglnstyl= 0 > .fillpattrn= 0 > .fillpaloptn = 20c0 > .foreground= 40 > .background= 41 > [/EXTENDEDFORMAT] > > Offset 0x5dc (1500) > recordid = 0xe0, size = 20 > [EXTENDEDFORMAT] > STYLE_RECORD_TYPE > .fontindex = 0 > .formatindex = 0 > .celloptions = fffffff5 > .islocked = true > .ishidden = false > .recordtype= 1 > .parentidx = fff > .alignmentoptions= 20 > .alignment = 0 > .wraptext = false > .valignment= 2 > .justlast = 0 > .rotation = 0 > .indentionoptions= fffff400 > .indent = 0 > .shrinktoft= false > .mergecells= false > .readngordr= 0 > .formatflag= true > .fontflag = false > .prntalgnmt= true > .borderflag= true > .paternflag= true > .celloption= true > .borderoptns = 0 > .lftln = 0 > .rgtln = 0 > .topln = 0 > .btmln = 0 > .paleteoptns = 0 > .leftborder= 0 > .rghtborder= 0 > .diag = 0 > .paleteoptn2 = 0 > .topborder = 0 > .botmborder= 0 > .adtldiag = 0 > .diaglnstyl= 0 > .fillpattrn= 0 > .fillpaloptn = 20c0 > .foreground= 40 > .background= 41 > [/EXTENDEDFORMAT] > > Offset 0x5f4 (1524) > recordid = 0xe0, size = 20 > [EXTENDEDFORMAT] > STYLE_RECORD_TYPE > .fontindex = 0 > .formatindex = 0 > .celloptions = fffffff5 > .islocked = true > .ishidden = false > .recordtype= 1 > .parentidx = fff > .alignmentoptions= 20 > .alignment = 0 > .wraptext = false > .valignment= 2 > .justlast = 0 > .rotation = 0 > .indentionoptions= fffff400 > .indent = 0 > .shrinktoft= false > .mergecells= false > .readngordr= 0 > .formatflag= true > .fontflag = false > .prntalgnmt= true > .borderflag= true > .paternflag= true > .celloption= true > .borderoptns = 0 > .lftln = 0 > .rgtln = 0 > .topln = 0 > .btmln = 0 > .paleteoptns = 0 > .leftborder= 0 > .rghtborder= 0 > .diag = 0 > .paleteoptn2 = 0 > .topborder = 0 > .botmborder= 0 > .adtldiag = 0 > .diaglnstyl= 0 > .fillpattrn= 0 > .fillpaloptn = 20c0 > .foreground= 40 > .background= 41 > [/EXTENDEDFORMAT] > > Offset 0x60c (1548) > recordid = 0xe0, size = 20 > [EXTENDEDFORMAT] > STYLE_RECORD_TYPE > .fontindex = 0 > .formatindex = 0 > .celloptions = fffffff5 > .islocked = true > .ishidden = false > .recordtype= 1 > .parentidx = fff > .alignmentoptions= 20 > .alignment = 0 > .wraptext = false > .valignment= 2 > .justlast = 0 > .rotation = 0 > .indentionoptions= fffff400 > .indent = 0 > .shrinktoft= false > .mergecells= false > .readngordr= 0 > .formatflag= true > .fontflag = false > .prntalgnmt= true > .borderflag= true > .paternflag= true > .celloption= true > .borderoptns = 0 > .lftln = 0 > .rgtln = 0 > .topln = 0 > .btmln = 0 > .paleteoptns = 0 > .leftborder= 0 > .rghtborder= 0 > .diag = 0 > .paleteoptn2 = 0 > .topborder = 0 > .botmborder= 0 > .adtldiag = 0 > .diaglnstyl= 0 > .fillpattrn= 0 > .fillpaloptn = 20c0 > .foreground= 40 > .background= 41 > [/EXTENDEDFORMAT] > > Offset 0x624 (1572) > recordid = 0xe0, size = 20 > [EXTENDEDFORMAT] > CELL_RECORD_TYPE > .fontindex = 0 > .formatindex = 0 > .celloptions = 1 > .islocked = true > .ishidden = false > .recordtype= 0 > .parentidx = 0 > .alignmentoptions= 20 > .alignment = 0 > .wraptext = false > .valignment= 2 > .justlast = 0 > .rotation = 0 > .indentionoptions= 0 > .indent = 0 > .shrinktoft= false > .mergecells= false > .readngordr= 0 > .formatflag= false > .fontflag = false > .prntalgnmt= false > .borderflag= false > .paternflag= false > .celloption= false > .borderoptns = 0 > .lftln = 0 > .rgtln = 0 > .topln = 0 > .btmln = 0 > .paleteoptns = 0 > .leftborder= 0 > .rghtborder= 0 > .diag = 0 > .paleteoptn2 = 0 > .topborder = 0 > .botmborder= 0 > .adtldiag = 0 > .diaglnstyl= 0 > .fillpattrn= 0 > .fillpaloptn = 20c0 > .foreground= 40 > .background= 41 > [/EXTENDEDFORMAT] > > Offset 0x63c (1596) > recordid = 0xe0, size = 20 > [EXTENDEDFORMAT] > STYLE_RECORD_TYPE > .fontindex = 1 > .formatindex = ab > .celloptions = fffffff5 > .islocked = true > .ishidden = false > .recordtype= 1 > .parentidx = fff > .alignmentoptions= 20 > .alignment = 0 > .wraptext = false > .valignment= 2 > .justlast = 0 > .rotation = 0 > .indentionoptions= fffff800 > .indent = 0 > .shrinktoft= false > .mergecells= false > .readngordr= 0 > .formatflag= false > .fontflag = true > .prntalgnmt= true > .borderflag= true > .paternflag= true > .celloption= true > .borderoptns = 0 > .lftln = 0 > .rgtln = 0 > .topln = 0 > .btmln = 0 > .paleteoptns = 0 > .leftborder= 0 > .rghtborder= 0 > .diag = 0 > .paleteoptn2 = 0 > .topborder = 0 > .botmborder= 0 > .adtldiag = 0 > .diaglnstyl= 0 > .fillpattrn= 0 > .fillpaloptn = 20c0 > .foreground= 40 > .background= 41 > [/EXTENDEDFORMAT] > > Offset 0x654 (1620) > recordid = 0xe0, size = 20 > [EXTENDEDFORMAT] > STYLE_RECORD_TYPE > .fontindex = 1 > .formatindex = a9 > .celloptions = fffffff5 > .islocked = true > .ishidden = false > .recordtype= 1 > .parentidx = fff > .alignmentoptions= 20 > .alignment = 0 > .wraptext = false > .valignment= 2 > .justlast = 0 > .rotation = 0 > .indentionoptions= fffff800 > .indent = 0 > .shrinktoft= false > .mergecells= false > .readngordr= 0 > .formatflag= false > .fontflag = true > .prntalgnmt= true > .borderflag= true > .paternflag= true > .celloption= true > .borderoptns = 0 > .lftln = 0 > .rgtln = 0 > .topln = 0 > .btmln = 0 > .paleteoptns = 0 > .leftborder= 0 > .rghtborder= 0 > .diag = 0 > .paleteoptn2 = 0 > .topborder = 0 > .botmborder= 0 > .adtldiag = 0 > .diaglnstyl= 0 > .fillpattrn= 0 > .fillpaloptn = 20c0 > .foreground= 40 > .background= 41 > [/EXTENDEDFORMAT] > > Offset 0x66c (1644) > recordid = 0xe0, size = 20 > [EXTENDEDFORMAT] > STYLE_RECORD_TYPE > .fontindex = 1 > .formatindex = aa > .celloptions = fffffff5 > .islocked = true > .ishidden = false > .recordtype= 1 > .parentidx = fff > .alignmentoptions= 20 > .alignment = 0 > .wraptext = false > .valignment= 2 > .justlast = 0 > .rotation = 0 > .indentionoptions= fffff800 > .indent = 0 > .shrinktoft= false > .mergecells= false > .readngordr= 0 > .formatflag= false > .fontflag = true > .prntalgnmt= true > .borderflag= true > .paternflag= true > .celloption= true > .borderoptns = 0 > .lftln = 0 > .rgtln = 0 > .topln = 0 > .btmln = 0 > .paleteoptns = 0 > .leftborder= 0 > .rghtborder= 0 > .diag = 0 > .paleteoptn2 = 0 > .topborder = 0 > .botmborder= 0 > .adtldiag = 0 > .diaglnstyl= 0 > .fillpattrn= 0 > .fillpaloptn = 20c0 > .foreground= 40 > .background= 41 > [/EXTENDEDFORMAT] > > Offset 0x684 (1668) > recordid = 0xe0, size = 20 > [EXTENDEDFORMAT] > STYLE_RECORD_TYPE > .fontindex = 1 > .formatindex = a8 > .celloptions = fffffff5 > .islocked = true > .ishidden = false > .recordtype= 1 > .parentidx = fff > .alignmentoptions= 20 > .alignment = 0 > .wraptext = false > .valignment= 2 > .justlast = 0 > .rotation = 0 > .indentionoptions= fffff800 > .indent = 0 > .shrinktoft= false > .mergecells= false > .readngordr= 0 > .formatflag= false > .fontflag = true > .prntalgnmt= true > .borderflag= true > .paternflag= true > .celloption= true > .borderoptns = 0 > .lftln = 0 > .rgtln = 0 > .topln = 0 > .btmln = 0 > .paleteoptns = 0 > .leftborder= 0 > .rghtborder= 0 > .diag = 0 > .paleteoptn2 = 0 > .topborder = 0 > .botmborder= 0 > .adtldiag = 0 > .diaglnstyl= 0 > .fillpattrn= 0 > .fillpaloptn = 20c0 > .foreground= 40 > .background= 41 > [/EXTENDEDFORMAT] > > Offset 0x69c (1692) > recordid = 0xe0, size = 20 > [EXTENDEDFORMAT] > STYLE_RECORD_TYPE > .fontindex = 1 > .formatindex = 9 > .celloptions = fffffff5 > .islocked = true > .ishidden = false > .recordtype= 1 > .parentidx = fff > .alignmentoptions= 20 > .alignment = 0 > .wraptext = false > .valignment= 2 > .justlast = 0 > .rotation = 0 > .indentionoptions= fffff800 > .indent = 0 > .shrinktoft= false > .mergecells= false > .readngordr= 0 > .formatflag= false > .fontflag = true > .prntalgnmt= true > .borderflag= true > .paternflag= true > .celloption= true > .borderoptns = 0 > .lftln = 0 > .rgtln = 0 > .topln = 0 > .btmln = 0 > .paleteoptns = 0 > .leftborder= 0 > .rghtborder= 0 > .diag = 0 > .paleteoptn2 = 0 > .topborder = 0 > .botmborder= 0 > .adtldiag = 0 > .diaglnstyl= 0 > .fillpattrn= 0 > .fillpaloptn = 20c0 > .foreground= 40 > .background= 41 > [/EXTENDEDFORMAT] > > Offset 0x6b4 (1716) > recordid = 0x293, size = 4 > [STYLE] > .xf_index_raw = ffff8010 > .type = 1 > .xf_index = 10 > .builtin_style = 3 > .outline_level = ffffffff > [/STYLE] > > Offset 0x6bc (1724) > recordid = 0x293, size = 4 > [STYLE] > .xf_index_raw = ffff8011 > .type = 1 > .xf_index = 11 > .builtin_style = 6 > .outline_level = ffffffff > [/STYLE] > > Offset 0x6c4 (1732) > recordid = 0x293, size = 4 > [STYLE] > .xf_index_raw = ffff8012 > .type = 1 > .xf_index = 12 > .builtin_style = 4 > .outline_level = ffffffff > [/STYLE] > > Offset 0x6cc (1740) > recordid = 0x293, size = 4 > [STYLE] > .xf_index_raw = ffff8013 > .type = 1 > .xf_index = 13 > .builtin_style = 7 > .outline_level = ffffffff > [/STYLE] > > Offset 0x6d4 (1748) > recordid = 0x293, size = 4 > [STYLE] > .xf_index_raw = ffff8000 > .type = 1 > .xf_index = 0 > .builtin_style = 0 > .outline_level = ffffffff > [/STYLE] > > Offset 0x6dc (1756) > recordid = 0x293, size = 4 > [STYLE] > .xf_index_raw = ffff8014 > .type = 1 > .xf_index = 14 > .builtin_style = 5 > .outline_level = ffffffff > [/STYLE] > > Offset 0x6e4 (1764) > recordid = 0x160, size = 2 > [USESELFS] > .flag = 0 > [/USESELFS] > > Offset 0x6ea (1770) > recordid = 0x85, size = 14 > [BOUNDSHEET] > .bof = 7cb > .optionflags = 0 > .sheetname length= 6 > .unicodeflag = 0 > .sheetname = Sheet1 > [/BOUNDSHEET] > > Offset 0x6fc (1788) > recordid = 0x85, size = 14 > [BOUNDSHEET] > .bof = 92a > .optionflags = 0 > .sheetname length= 6 > .unicodeflag = 0 > .sheetname = Sheet2 > [/BOUNDSHEET] > > Offset 0x70e (1806) > recordid = 0x8c, size = 4 > [COUNTRY] > .defaultcountry = 1 > .currentcountry = 20 > [/COUNTRY] > > Offset 0x716 (1814) > recordid = 0x1ae, size = 10 > [SUPBOOK] > numberosheets = 0 > flag = 5 > [/SUPBOOK] > > -----UNKNOWN---------------------------------- > 00000000 E2 7F 00 00 00 00 1B 00 4D 53 46 54 20 55 53 20 > ........MSFT US > 00000010 45 71 75 69 74 79 2C 5B 4C 41 53 54 5F 54 52 41 > Equity,[LAST_TRA > 00000020 44 45 5D DE] > > -----UNKNOWN---------------------------------- > -----UNKNOWN---------------------------------- > 00000000 EA 7F 00 00 00 00 0F 00 53 74 64 44 6F 63 75 6D > ........StdDocum > 00000010 65 6E 74 4E 61 6D 65 entName > > -----UNKNOWN---------------------------------- > Offset 0x766 (1894) > recordid = 0x1ae, size = 4 > [SUPBOOK] > numberosheets = 2 > flag = 1025 > [/SUPBOOK] > > Offset 0x76e (1902) > recordid = 0x17, size = 14 > [EXTERNSHEET] > numOfRefs = 2 > refrec #0 > supbookindex =0 > 1stsbindex =-2 > lastsbindex =-2 > ----refrec #0 > refrec #1 > supbookindex =1 > 1stsbindex =1 > lastsbindex =1 > ----refrec #1 > [/EXTERNSHEET] > > -----UNKNOWN---------------------------------- > 00000000 C1 01 00 00 60 69 01 00 ....`i.. > > -----UNKNOWN---------------------------------- > Offset 0x78c (1932) > recordid = 0xfc, size = 41 > [SST] > .numstrings = 5 > .uniquestrings = 3 > .string_0 = MSFT US Equity > .string_1 = LAST_TRADE > .string_2 = > [/SST] > > Offset 0x7b9 (1977) > recordid = 0xff, size = 10 > [EXTSST] > .dsst = 8 > .numInfoRecords = 1 > .inforecord = 0 > .streampos = 798 > .sstoffset = c > [/EXTSST] > > Offset 0x7c7 (1991) > recordid = 0xa, size = 0 > [EOF] > [/EOF] > > Offset 0x7cb (1995) > recordid = 0x809, size = 16 > [BOF RECORD] > .version = 600 > .type = 10 > .build = 1cfe > .buildyear = 1997 > .history = 40c9 > .requiredversion = 106 > [/BOF RECORD] > > Offset 0x7df (2015) > recordid = 0x20b, size = 20 > [INDEX] > .firstrow = 4 > .lastrowadd1 = 5 > .dbcell_0 = 8e9 > [/INDEX] > > Offset 0x7f7 (2039) > recordid = 0xd, size = 2 > [CALCMODE] > .calcmode = 1 > [/CALCMODE] > > Offset 0x7fd (2045) > recordid = 0xc, size = 2 > [CALCCOUNT] > .iterations = 64 > [/CALCCOUNT] > > Offset 0x803 (2051) > recordid = 0xf, size = 2 > [REFMODE] > .mode = 1 > [/REFMODE] > > Offset 0x809 (2057) > recordid = 0x11, size = 2 > [ITERATION] > .iteration = false > [/ITERATION] > > Offset 0x80f (2063) > recordid = 0x10, size = 8 > [DELTA] > .maxchange = 0.0010 > [/DELTA] > > Offset 0x81b (2075) > recordid = 0x5f, size = 2 > [SAVERECALC] > .recalc = true > [/SAVERECALC] > > Offset 0x821 (2081) > recordid = 0x2a, size = 2 > [PRINTHEADERS] > .printheaders = false > [/PRINTHEADERS] > > Offset 0x827 (2087) > recordid = 0x2b, size = 2 > [PRINTGRIDLINES] > .printgridlines = false > [/PRINTGRIDLINES] > > Offset 0x82d (2093) > recordid = 0x82, size = 2 > [GRIDSET] > .gridset = true > [/GRIDSET] > > Offset 0x833 (2099) > recordid = 0x80, size = 8 > [GUTS] > .leftgutter = 0 > .topgutter = 0 > .rowlevelmax = 0 > .collevelmax = 0 > [/GUTS] > > Offset 0x83f (2111) > recordid = 0x225, size = 4 > [DEFAULTROWHEIGHT] > .optionflags = 0 > .rowheight = ff > [/DEFAULTROWHEIGHT] > > Offset 0x847 (2119) > recordid = 0x81, size = 2 > [WSBOOL] > .wsbool1 = 4 > .autobreaks = false > .dialog = false > .rowsumsbelw= false > .rowsumsrigt= false > .wsbool2 = ffffffc1 > .fittopage = true > .displayguts= false > .alternateex= true > .alternatefo= true > [/WSBOOL] > > Offset 0x84d (2125) > recordid = 0x14, size = 0 > [HEADER] > .length = 0 > .header = null > [/HEADER] > > Offset 0x851 (2129) > recordid = 0x15, size = 0 > [FOOTER] > .footerlen = 0 > .footer = null > [/FOOTER] > > Offset 0x855 (2133) > recordid = 0x83, size = 2 > [HCENTER] > .hcenter = false > [/HCENTER] > > Offset 0x85b (2139) > recordid = 0x84, size = 2 > [VCENTER] > .vcenter = false > [/VCENTER] > > Offset 0x861 (2145) > recordid = 0xa1, size = 34 > [PRINTSETUP] > .papersize = 0 > .scale = 255 > .pagestart = 1 > .fitwidth = 1 > .fitheight = 1 > .options = 4 > .ltor = false > .landscape = false > .valid = true > .mono = false > .draft = false > .notes = false > .noOrientat = false > .usepage = false > .hresolution = 0 > .vresolution = 0 > .headermargin = 0.5 > .footermargin = 0.5 > .copies = 0 > [/PRINTSETUP] > > Offset 0x887 (2183) > recordid = 0x55, size = 2 > [DEFAULTCOLWIDTH] > .colwidth = 8 > [/DEFAULTCOLWIDTH] > > Offset 0x88d (2189) > recordid = 0x200, size = 14 > [DIMENSIONS] > .firstrow = 4 > .lastrow = 5 > .firstcol = 1 > .lastcol = 2 > .zero = 0 > [/DIMENSIONS] > > Offset 0x89f (2207) > recordid = 0x208, size = 16 > [ROW] > .rownumber = 4 > .firstcol = 1 > .lastcol = 2 > .height = ff > .optimize = 0 > .reserved = 0 > .optionflags = 100 > .outlinelvl = 0 > .colapsed = false > .zeroheight = false > .badfontheig= false > .formatted = false > .xfindex = f > [/ROW] > > Offset 0x8b3 (2227) > recordid = 0x6, size = 29 > [FORMULA] > .row = 4 > .column = 1 > .xf = f > .value (NaN) = 00000000 00 00 0C 00 85 07 FF FF > ........ > > .options = 0 > .zero = -52428800 > .expressionlength= 7 > .numptgsinarray = 1 > Formula 0=Ref3dPtg > Index to Extern Sheet = 1 > Row = 0 > Col = 1 > ColRowRel= true > ColRel = true > > 00000000 5A 01 00 00 00 01 C0 Z...... > > [/FORMULA] > > Offset 0x8d4 (2260) > recordid = 0x207, size = 17 > [STRING] > .string = MSFT US Equity > [/STRING] > > Offset 0x8e9 (2281) > recordid = 0xd7, size = 6 > [DBCELL] > .rowoffset = 4a > .cell_0 = 0 > [/DBCELL] > > Offset 0x8f3 (2291) > recordid = 0x23e, size = 18 > [WINDOW2] > .options = b6 > .dispformulas= false > .dispgridlins= true > .disprcheadin= true > .freezepanes = false > .displayzeros= true > .defaultheadr= true > .arabic = false > .displayguts = true > .frzpnsnosplt= false > .selected = false > .paged = false > .svdinpgbrkpv= false > .toprow = 0 > .leftcol = 0 > .headercolor = 40 > .pagebreakzoom = 0 > .normalzoom = 0 > .reserved = 0 > [/WINDOW2] > > Offset 0x909 (2313) > recordid = 0x1d, size = 15 > [SELECTION] > .pane = 3 > .activecellrow = 4 > .activecellcol = 1 > .activecellref = 0 > .numrefs = 1 > [/SELECTION] > > -----UNKNOWN---------------------------------- > 00000000 00 00 37 00 00 00 ..7... > > -----UNKNOWN---------------------------------- > Offset 0x926 (2342) > recordid = 0xa, size = 0 > [EOF] > [/EOF] > > Offset 0x92a (2346) > recordid = 0x809, size = 16 > [BOF RECORD] > .version = 600 > .type = 10 > .build = 1cfe > .buildyear = 1997 > .history = 40c9 > .requiredversion = 106 > [/BOF RECORD] > > Offset 0x93e (2366) > recordid = 0x20b, size = 20 > [INDEX] > .firstrow = 0 > .lastrowadd1 = 6 > .dbcell_0 = a8d > [/INDEX] > > Offset 0x956 (2390) > recordid = 0xd, size = 2 > [CALCMODE] > .calcmode = 1 > [/CALCMODE] > > Offset 0x95c (2396) > recordid = 0xc, size = 2 > [CALCCOUNT] > .iterations = 64 > [/CALCCOUNT] > > Offset 0x962 (2402) > recordid = 0xf, size = 2 > [REFMODE] > .mode = 1 > [/REFMODE] > > Offset 0x968 (2408) > recordid = 0x11, size = 2 > [ITERATION] > .iteration = false > [/ITERATION] > > Offset 0x96e (2414) > recordid = 0x10, size = 8 > [DELTA] > .maxchange = 0.0010 > [/DELTA] > > Offset 0x97a (2426) > recordid = 0x5f, size = 2 > [SAVERECALC] > .recalc = true > [/SAVERECALC] > > Offset 0x980 (2432) > recordid = 0x2a, size = 2 > [PRINTHEADERS] > .printheaders = false > [/PRINTHEADERS] > > Offset 0x986 (2438) > recordid = 0x2b, size = 2 > [PRINTGRIDLINES] > .printgridlines = false > [/PRINTGRIDLINES] > > Offset 0x98c (2444) > recordid = 0x82, size = 2 > [GRIDSET] > .gridset = true > [/GRIDSET] > > Offset 0x992 (2450) > recordid = 0x80, size = 8 > [GUTS] > .leftgutter = 0 > .topgutter = 0 > .rowlevelmax = 0 > .collevelmax = 0 > [/GUTS] > > Offset 0x99e (2462) > recordid = 0x225, size = 4 > [DEFAULTROWHEIGHT] > .optionflags = 0 > .rowheight = ff > [/DEFAULTROWHEIGHT] > > Offset 0x9a6 (2470) > recordid = 0x81, size = 2 > [WSBOOL] > .wsbool1 = 4 > .autobreaks = false > .dialog = false > .rowsumsbelw= false > .rowsumsrigt= false > .wsbool2 = ffffffc1 > .fittopage = true > .displayguts= false > .alternateex= true > .alternatefo= true > [/WSBOOL] > > Offset 0x9ac (2476) > recordid = 0x14, size = 0 > [HEADER] > .length = 0 > .header = null > [/HEADER] > > Offset 0x9b0 (2480) > recordid = 0x15, size = 0 > [FOOTER] > .footerlen = 0 > .footer = null > [/FOOTER] > > Offset 0x9b4 (2484) > recordid = 0x83, size = 2 > [HCENTER] > .hcenter = false > [/HCENTER] > > Offset 0x9ba (2490) > recordid = 0x84, size = 2 > [VCENTER] > .vcenter = false > [/VCENTER] > > Offset 0x9c0 (2496) > recordid = 0xa1, size = 34 > [PRINTSETUP] > .papersize = 1 > .scale = 100 > .pagestart = 1 > .fitwidth = 1 > .fitheight = 1 > .options = 2 > .ltor = false > .landscape = true > .valid = false > .mono = false > .draft = false > .notes = false > .noOrientat = false > .usepage = false > .hresolution = 300 > .vresolution = 300 > .headermargin = 0.5 > .footermargin = 0.5 > .copies = 0 > [/PRINTSETUP] > > Offset 0x9e6 (2534) > recordid = 0x55, size = 2 > [DEFAULTCOLWIDTH] > .colwidth = 8 > [/DEFAULTCOLWIDTH] > > Offset 0x9ec (2540) > recordid = 0x200, size = 14 > [DIMENSIONS] > .firstrow = 0 > .lastrow = 6 > .firstcol = 0 > .lastcol = 6 > .zero = 0 > [/DIMENSIONS] > > Offset 0x9fe (2558) > recordid = 0x208, size = 16 > [ROW] > .rownumber = 0 > .firstcol = 0 > .lastcol = 6 > .height = ff > .optimize = 0 > .reserved = 0 > .optionflags = 100 > .outlinelvl = 0 > .colapsed = false > .zeroheight = false > .badfontheig= false > .formatted = false > .xfindex = f > [/ROW] > > Offset 0xa12 (2578) > recordid = 0x208, size = 16 > [ROW] > .rownumber = 5 > .firstcol = 0 > .lastcol = 6 > .height = ff > .optimize = 0 > .reserved = 0 > .optionflags = 100 > .outlinelvl = 0 > .colapsed = false > .zeroheight = false > .badfontheig= false > .formatted = false > .xfindex = f > [/ROW] > > Offset 0xa26 (2598) > recordid = 0x6, size = 29 > [FORMULA] > .row = 0 > .column = 0 > .xf = f > .value (NaN) = 00000000 02 00 17 00 00 00 FF FF > ........ > > .options = 0 > .zero = -52428800 > .expressionlength= 7 > .numptgsinarray = 1 > Formula 0=class org.apache.poi.hssf.record.formula.NameXPtg > 00000000 59 00 00 01 00 00 00 Y...... > > [/FORMULA] > > Offset 0xa47 (2631) > recordid = 0xfd, size = 10 > [LABELSST] > .row = 0 > .column = 1 > .xfindex = f > .sstindex = 0 > [/LABELSST] > > Offset 0xa55 (2645) > recordid = 0xfd, size = 10 > [LABELSST] > .row = 0 > .column = 2 > .xfindex = f > .sstindex = 1 > [/LABELSST] > > Offset 0xa63 (2659) > recordid = 0xfd, size = 10 > [LABELSST] > .row = 5 > .column = 3 > .xfindex = f > .sstindex = 2 > [/LABELSST] > > Offset 0xa71 (2673) > recordid = 0xfd, size = 10 > [LABELSST] > .row = 5 > .column = 4 > .xfindex = f > .sstindex = 2 > [/LABELSST] > > Offset 0xa7f (2687) > recordid = 0xfd, size = 10 > [LABELSST] > .row = 5 > .column = 5 > .xfindex = f > .sstindex = 2 > [/LABELSST] > > Offset 0xa8d (2701) > recordid = 0xd7, size = 8 > [DBCELL] > .rowoffset = 8f > .cell_0 = 14 > .cell_1 = 3d > [/DBCELL] > > Offset 0xa99 (2713) > recordid = 0x23e, size = 18 > [WINDOW2] > .options = 6b6 > .dispformulas= false > .dispgridlins= true > .disprcheadin= true > .freezepanes = false > .displayzeros= true > .defaultheadr= true > .arabic = false > .displayguts = true > .frzpnsnosplt= false > .selected = true > .paged = true > .svdinpgbrkpv= false > .toprow = 0 > .leftcol = 0 > .headercolor = 40 > .pagebreakzoom = 0 > .normalzoom = 0 > .reserved = 0 > [/WINDOW2] > > Offset 0xaaf (2735) > recordid = 0x1d, size = 15 > [SELECTION] > .pane = 3 > .activecellrow = 1 > .activecellcol = 0 > .activecellref = 0 > .numrefs = 1 > [/SELECTION] > > -----UNKNOWN---------------------------------- > 00000000 00 00 37 00 00 00 ..7... > > -----UNKNOWN---------------------------------- > Offset 0xacc (2764) > recordid = 0xa, size = 0 > [EOF] > [/EOF] > > BUILD SUCCESSFUL (total time: 3 seconds) > > On 6/14/05, Avik Sengupta <[EMAIL PROTECTED]> wrote: > > >CAn this be > > > done in HSSF?Pls help. > > > > If its throwing an exception, then apparently not :) > > > > Whats a remote reference formula? Is that a pipe character? > What does it > > do? > > > > Can you provide the parsed result of such a formula (using > biffviewer?) > > > > On Tue, 2005-06-14 at 12:05 +0200, Nishant Chandra wrote: > > > POI HSSF doesnt seem to support remote reference > formula(supported by > > > excel). I am trying to do something like this: > > > > > > HSSFWorkbook wb = new HSSFWorkbook(); > > > HSSFSheet sheet = wb.createSheet("new sheet"); > > > > > > HSSFRow row = sheet.createRow((short) 0); > > > //Create a cell and put a value in it. > > > > > > HSSFCell mycell = row.createCell((short)0); > > > mycell.setCellType(HSSFCell.CELL_TYPE_FORMULA); > > > mycell.setCellFormula("BLP|M!MSFT"); //remote > reference formula > > > > > > I am getting the following error: > > > > > > java.lang.StringIndexOutOfBoundsException: String index > out of range: 0 > > > at java.lang.String.charAt(String.java:444) > > > at > org.apache.poi.hssf.util.CellReference.<init>(CellReference.java:44) > > > at > org.apache.poi.hssf.record.formula.ReferencePtg.<init>(Referen > cePtg.java:50) > > > at > org.apache.poi.hssf.model.FormulaParser.Ident(FormulaParser.java:320) > > > at > org.apache.poi.hssf.model.FormulaParser.Factor(FormulaParser.java:524) > > > at > org.apache.poi.hssf.model.FormulaParser.Term(FormulaParser.java:602) > > > at > org.apache.poi.hssf.model.FormulaParser.Expression(FormulaPars > er.java:651) > > > at > org.apache.poi.hssf.model.FormulaParser.parse(FormulaParser.java:756) > > > at > org.apache.poi.hssf.usermodel.HSSFCell.setCellFormula(HSSFCell > .java:689) > > > > > > > > > I can enter the formula manually in excel and it works. > CAn this be > > > done in HSSF?Pls help. > > > > > > > --------------------------------------------------------------------- > > > 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/ > > > > > -- > > > > > > > -- > Website: www.cse.iitb.ac.in/~nishantc > > --------------------------------------------------------------------- > 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/ > --------------------------------------------------------------------- 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/
