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>(ReferencePtg.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(FormulaParser.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/
