You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by Nishant Chandra <ni...@gmail.com> on 2005/06/14 12:05:06 UTC
Remote reference formula support
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: poi-user-unsubscribe@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
Re: Remote reference formula support
Posted by Nishant Chandra <ni...@gmail.com>.
Avik Sengupta <avik.sengupta <at> itellix.com> writes:
>
> >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: poi-user-unsubscribe <at> jakarta.apache.org
> > Mailing List: http://jakarta.apache.org/site/mail2.html#poi
> > The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
> >
This is what the excel help has to say:
you can enter a remote reference formula that refers to the data. The data is
displayed on your worksheet as the result of the formula.
The formula has three parts: the name of the application; the file name or
topic; and the cell range, value, field, or data that's referred to. The
following illustration shows the parts of a remote reference formula and the
required separator characters.
BLP|M!MSFT
A pipe character (|) separates the program name from the document or topic name.
An exclamation point (!) separates the document or topic name from the cell
range, value, field, or data referred to.
When to use single quotation marks If the name of the application, document,
topic, or data item contains spaces or characters such as colons (:) or minus
signs ( – ) that have special uses in a formula, or if a name resembles a cell
reference, enclose the name in single quotation marks.
DDE support required The program that contains the data you want to link must
support Dynamic Data Exchange (DDE). To determine whether your program supports
DDE or to learn the DDE name and topic information for the program, contact the
software vendor of the program. For more information about DDE, see the
Microsoft Office 2000 Resource Kit.
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
Re: Remote reference formula support
Posted by Nishant Chandra <ni...@gmail.com>.
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"_-;_-@_-
[/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_-;_-@_-
[/FORMAT]
Offset 0x2a8 (680)
recordid = 0x41e, size = 70
[FORMAT]
.indexcode = 2c
.unicode length = 41
.isUnicode = false
.formatstring = _-* #,##0.00\ "BF"_-;\-* #,##0.00\ "BF"_-;_-*
"-"??\ "BF"_-;_-@_-
[/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_-;_-@_-
[/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 <av...@itellix.com> 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: poi-user-unsubscribe@jakarta.apache.org
> > 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: poi-user-unsubscribe@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
Re: Remote reference formula support
Posted by Avik Sengupta <av...@itellix.com>.
>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: poi-user-unsubscribe@jakarta.apache.org
> Mailing List: http://jakarta.apache.org/site/mail2.html#poi
> The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
>
--
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
Re: Remote reference formula support
Posted by Thierry Morel <th...@free.fr>.
It is more than ok !!
Thank U again Nishant
I contact U back on monday
Thy
----- Original Message -----
From: "Nishant Chandra" <ni...@gmail.com>
To: "POI Users List" <po...@jakarta.apache.org>
Sent: Thursday, December 08, 2005 3:07 PM
Subject: Re: Remote reference formula support
i can do it by this weekend.is that ok?
Nishant
On 12/8/05, Thierry Morel <th...@free.fr> wrote:
> Thank U again Chandra for taking time for this.
> I'm already late in fact... but I have no choice...
> I just have to explain that to my boss !
> How much time do U need to get your code back on your side ?
> Thy
>
>
> Hi,
> well i modified 3-4 files which handles parsing and deals with low
> level record generation for formulas. I have the code but its not
> immediately accesible to me.
> i dont rem xactly what i did cos its been some time now. how much time
> do u have?
>
> nishant
>
> On 12/8/05, Thierry Morel <th...@free.fr> wrote:
> > Hi Chandra, thank U very much for your answer, I saw U had been the same
> pb
> > some time ago,
> > I'm very lucky you're online.
> > But I'm a little bit scared to modify the parsing, it seems to me pretty
> > tricky, and I wonder if U
> > remember the way U did that ?
> > Did U recompile POI, or just called a setParser method ? Or would U have
> > some lines of code ?
> > I know it is not veru kind to ask for code, but I'm really under
water....
> >
> > Have a nice day
> > Thy
> >
> >
> > ----- Original Message -----
> > From: "Nishant Chandra" <ni...@gmail.com>
> > To: "POI Users List" <po...@jakarta.apache.org>
> > Sent: Thursday, December 08, 2005 1:22 PM
> > Subject: Re: Remote reference formula support
> >
> >
> > Well i think this is a bug. I solved this problem by modifying the way
> > the formula is parsed.
> >
> > Nishant
> >
> > On 12/8/05, Thy <th...@free.fr> wrote:
> > > Hi all,
> > > exactly the same pb as Chandra with
> > cell.setCellFormula(AC129+$Sheet1.AC131)
> > >
> > > but not found any answer through the web for hours...
> > > I've found many similar posts but no solution.
> > > Is there any solution ?
> > > I've tried with Poi2.5, 2.5.1 and 3.0alpha, no difference.
> > > Thank U very much in advance for a tip !
> > > Thy
> > >
> > > StackTrace :
> > > java.lang.StringIndexOutOfBoundsException: String index out of range:
0
> > >
> > > at java.lang.String.charAt(String.java:558)
> > >
> > > 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:291)
> > >
> > > at org.apache.poi.hssf.model.FormulaParser.Factor
> > > (FormulaParser.java:474)
> > >
> > > at
> > org.apache.poi.hssf.model.FormulaParser.Term(FormulaParser.java:548)
> > >
> > > at
> > org.apache.poi.hssf.model.FormulaParser.Add(FormulaParser.java:562)
> > >
> > > at org.apache.poi.hssf.model.FormulaParser.Expression
> > > (FormulaParser.java:598)
> > >
> > > at
> > org.apache.poi.hssf.model.FormulaParser.parse(FormulaParser.java:700)
> > >
> > > at org.apache.poi.hssf.usermodel.HSSFCell.setCellFormula
> > > (HSSFCell.java:678)
> > >
> > > Nishant Chandra <nishant.chandra <at> gmail.com> writes:
> > >
> > >
> > >
> > > ---------------------------------------------------------------------
> > > To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> > > 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
> > I thought that I had no time for faith nor time to pray,
> > then I saw an armless man saying his Rosary with his feet.
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> > Mailing List: http://jakarta.apache.org/site/mail2.html#poi
> > The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
> >
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> > 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
> I thought that I had no time for faith nor time to pray,
> then I saw an armless man saying his Rosary with his feet.
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> Mailing List: http://jakarta.apache.org/site/mail2.html#poi
> The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> 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
I thought that I had no time for faith nor time to pray,
then I saw an armless man saying his Rosary with his feet.
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
Re: Remote reference formula support
Posted by Thierry Morel <th...@free.fr>.
Hi Nishant,
sorry to be so late, I had to travel to England up to now without having
easy web access.
So I apologize and wonder if you found your sample code by this week end, it
could really help me.
Thy
----- Original Message -----
From: "Nishant Chandra" <ni...@gmail.com>
To: "POI Users List" <po...@jakarta.apache.org>
Sent: Thursday, December 08, 2005 3:07 PM
Subject: Re: Remote reference formula support
i can do it by this weekend.is that ok?
Nishant
On 12/8/05, Thierry Morel <th...@free.fr> wrote:
> Thank U again Chandra for taking time for this.
> I'm already late in fact... but I have no choice...
> I just have to explain that to my boss !
> How much time do U need to get your code back on your side ?
> Thy
>
>
> Hi,
> well i modified 3-4 files which handles parsing and deals with low
> level record generation for formulas. I have the code but its not
> immediately accesible to me.
> i dont rem xactly what i did cos its been some time now. how much time
> do u have?
>
> nishant
>
> On 12/8/05, Thierry Morel <th...@free.fr> wrote:
> > Hi Chandra, thank U very much for your answer, I saw U had been the same
> pb
> > some time ago,
> > I'm very lucky you're online.
> > But I'm a little bit scared to modify the parsing, it seems to me pretty
> > tricky, and I wonder if U
> > remember the way U did that ?
> > Did U recompile POI, or just called a setParser method ? Or would U have
> > some lines of code ?
> > I know it is not veru kind to ask for code, but I'm really under
water....
> >
> > Have a nice day
> > Thy
> >
> >
> > ----- Original Message -----
> > From: "Nishant Chandra" <ni...@gmail.com>
> > To: "POI Users List" <po...@jakarta.apache.org>
> > Sent: Thursday, December 08, 2005 1:22 PM
> > Subject: Re: Remote reference formula support
> >
> >
> > Well i think this is a bug. I solved this problem by modifying the way
> > the formula is parsed.
> >
> > Nishant
> >
> > On 12/8/05, Thy <th...@free.fr> wrote:
> > > Hi all,
> > > exactly the same pb as Chandra with
> > cell.setCellFormula(AC129+$Sheet1.AC131)
> > >
> > > but not found any answer through the web for hours...
> > > I've found many similar posts but no solution.
> > > Is there any solution ?
> > > I've tried with Poi2.5, 2.5.1 and 3.0alpha, no difference.
> > > Thank U very much in advance for a tip !
> > > Thy
> > >
> > > StackTrace :
> > > java.lang.StringIndexOutOfBoundsException: String index out of range:
0
> > >
> > > at java.lang.String.charAt(String.java:558)
> > >
> > > 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:291)
> > >
> > > at org.apache.poi.hssf.model.FormulaParser.Factor
> > > (FormulaParser.java:474)
> > >
> > > at
> > org.apache.poi.hssf.model.FormulaParser.Term(FormulaParser.java:548)
> > >
> > > at
> > org.apache.poi.hssf.model.FormulaParser.Add(FormulaParser.java:562)
> > >
> > > at org.apache.poi.hssf.model.FormulaParser.Expression
> > > (FormulaParser.java:598)
> > >
> > > at
> > org.apache.poi.hssf.model.FormulaParser.parse(FormulaParser.java:700)
> > >
> > > at org.apache.poi.hssf.usermodel.HSSFCell.setCellFormula
> > > (HSSFCell.java:678)
> > >
> > > Nishant Chandra <nishant.chandra <at> gmail.com> writes:
> > >
> > >
> > >
> > > ---------------------------------------------------------------------
> > > To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> > > 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
> > I thought that I had no time for faith nor time to pray,
> > then I saw an armless man saying his Rosary with his feet.
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> > Mailing List: http://jakarta.apache.org/site/mail2.html#poi
> > The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
> >
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> > 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
> I thought that I had no time for faith nor time to pray,
> then I saw an armless man saying his Rosary with his feet.
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> Mailing List: http://jakarta.apache.org/site/mail2.html#poi
> The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> 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
I thought that I had no time for faith nor time to pray,
then I saw an armless man saying his Rosary with his feet.
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
Re: Remote reference formula support
Posted by Thierry Morel <th...@free.fr>.
Does your code deal with the org.apache.poi.hssf.model.FormulaParser class ?
http://jakarta.apache.org/poi/apidocs/org/apache/poi/hssf/model/FormulaParser.html
This could be a way to avoid the compilation of POI, don't u think ?
Thy
----- Original Message -----
From: "Nishant Chandra" <ni...@gmail.com>
To: "POI Users List" <po...@jakarta.apache.org>
Sent: Thursday, December 08, 2005 3:07 PM
Subject: Re: Remote reference formula support
i can do it by this weekend.is that ok?
Nishant
On 12/8/05, Thierry Morel <th...@free.fr> wrote:
> Thank U again Chandra for taking time for this.
> I'm already late in fact... but I have no choice...
> I just have to explain that to my boss !
> How much time do U need to get your code back on your side ?
> Thy
>
>
> Hi,
> well i modified 3-4 files which handles parsing and deals with low
> level record generation for formulas. I have the code but its not
> immediately accesible to me.
> i dont rem xactly what i did cos its been some time now. how much time
> do u have?
>
> nishant
>
> On 12/8/05, Thierry Morel <th...@free.fr> wrote:
> > Hi Chandra, thank U very much for your answer, I saw U had been the same
> pb
> > some time ago,
> > I'm very lucky you're online.
> > But I'm a little bit scared to modify the parsing, it seems to me pretty
> > tricky, and I wonder if U
> > remember the way U did that ?
> > Did U recompile POI, or just called a setParser method ? Or would U have
> > some lines of code ?
> > I know it is not veru kind to ask for code, but I'm really under
water....
> >
> > Have a nice day
> > Thy
> >
> >
> > ----- Original Message -----
> > From: "Nishant Chandra" <ni...@gmail.com>
> > To: "POI Users List" <po...@jakarta.apache.org>
> > Sent: Thursday, December 08, 2005 1:22 PM
> > Subject: Re: Remote reference formula support
> >
> >
> > Well i think this is a bug. I solved this problem by modifying the way
> > the formula is parsed.
> >
> > Nishant
> >
> > On 12/8/05, Thy <th...@free.fr> wrote:
> > > Hi all,
> > > exactly the same pb as Chandra with
> > cell.setCellFormula(AC129+$Sheet1.AC131)
> > >
> > > but not found any answer through the web for hours...
> > > I've found many similar posts but no solution.
> > > Is there any solution ?
> > > I've tried with Poi2.5, 2.5.1 and 3.0alpha, no difference.
> > > Thank U very much in advance for a tip !
> > > Thy
> > >
> > > StackTrace :
> > > java.lang.StringIndexOutOfBoundsException: String index out of range:
0
> > >
> > > at java.lang.String.charAt(String.java:558)
> > >
> > > 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:291)
> > >
> > > at org.apache.poi.hssf.model.FormulaParser.Factor
> > > (FormulaParser.java:474)
> > >
> > > at
> > org.apache.poi.hssf.model.FormulaParser.Term(FormulaParser.java:548)
> > >
> > > at
> > org.apache.poi.hssf.model.FormulaParser.Add(FormulaParser.java:562)
> > >
> > > at org.apache.poi.hssf.model.FormulaParser.Expression
> > > (FormulaParser.java:598)
> > >
> > > at
> > org.apache.poi.hssf.model.FormulaParser.parse(FormulaParser.java:700)
> > >
> > > at org.apache.poi.hssf.usermodel.HSSFCell.setCellFormula
> > > (HSSFCell.java:678)
> > >
> > > Nishant Chandra <nishant.chandra <at> gmail.com> writes:
> > >
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
Re: Remote reference formula support
Posted by Nishant Chandra <ni...@gmail.com>.
i can do it by this weekend.is that ok?
Nishant
On 12/8/05, Thierry Morel <th...@free.fr> wrote:
> Thank U again Chandra for taking time for this.
> I'm already late in fact... but I have no choice...
> I just have to explain that to my boss !
> How much time do U need to get your code back on your side ?
> Thy
>
>
> Hi,
> well i modified 3-4 files which handles parsing and deals with low
> level record generation for formulas. I have the code but its not
> immediately accesible to me.
> i dont rem xactly what i did cos its been some time now. how much time
> do u have?
>
> nishant
>
> On 12/8/05, Thierry Morel <th...@free.fr> wrote:
> > Hi Chandra, thank U very much for your answer, I saw U had been the same
> pb
> > some time ago,
> > I'm very lucky you're online.
> > But I'm a little bit scared to modify the parsing, it seems to me pretty
> > tricky, and I wonder if U
> > remember the way U did that ?
> > Did U recompile POI, or just called a setParser method ? Or would U have
> > some lines of code ?
> > I know it is not veru kind to ask for code, but I'm really under water....
> >
> > Have a nice day
> > Thy
> >
> >
> > ----- Original Message -----
> > From: "Nishant Chandra" <ni...@gmail.com>
> > To: "POI Users List" <po...@jakarta.apache.org>
> > Sent: Thursday, December 08, 2005 1:22 PM
> > Subject: Re: Remote reference formula support
> >
> >
> > Well i think this is a bug. I solved this problem by modifying the way
> > the formula is parsed.
> >
> > Nishant
> >
> > On 12/8/05, Thy <th...@free.fr> wrote:
> > > Hi all,
> > > exactly the same pb as Chandra with
> > cell.setCellFormula(AC129+$Sheet1.AC131)
> > >
> > > but not found any answer through the web for hours...
> > > I've found many similar posts but no solution.
> > > Is there any solution ?
> > > I've tried with Poi2.5, 2.5.1 and 3.0alpha, no difference.
> > > Thank U very much in advance for a tip !
> > > Thy
> > >
> > > StackTrace :
> > > java.lang.StringIndexOutOfBoundsException: String index out of range: 0
> > >
> > > at java.lang.String.charAt(String.java:558)
> > >
> > > 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:291)
> > >
> > > at org.apache.poi.hssf.model.FormulaParser.Factor
> > > (FormulaParser.java:474)
> > >
> > > at
> > org.apache.poi.hssf.model.FormulaParser.Term(FormulaParser.java:548)
> > >
> > > at
> > org.apache.poi.hssf.model.FormulaParser.Add(FormulaParser.java:562)
> > >
> > > at org.apache.poi.hssf.model.FormulaParser.Expression
> > > (FormulaParser.java:598)
> > >
> > > at
> > org.apache.poi.hssf.model.FormulaParser.parse(FormulaParser.java:700)
> > >
> > > at org.apache.poi.hssf.usermodel.HSSFCell.setCellFormula
> > > (HSSFCell.java:678)
> > >
> > > Nishant Chandra <nishant.chandra <at> gmail.com> writes:
> > >
> > >
> > >
> > > ---------------------------------------------------------------------
> > > To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> > > 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
> > I thought that I had no time for faith nor time to pray,
> > then I saw an armless man saying his Rosary with his feet.
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> > Mailing List: http://jakarta.apache.org/site/mail2.html#poi
> > The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
> >
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> > 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
> I thought that I had no time for faith nor time to pray,
> then I saw an armless man saying his Rosary with his feet.
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> Mailing List: http://jakarta.apache.org/site/mail2.html#poi
> The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> 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
I thought that I had no time for faith nor time to pray,
then I saw an armless man saying his Rosary with his feet.
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
Re: Remote reference formula support
Posted by Thierry Morel <th...@free.fr>.
Thank U again Chandra for taking time for this.
I'm already late in fact... but I have no choice...
I just have to explain that to my boss !
How much time do U need to get your code back on your side ?
Thy
Hi,
well i modified 3-4 files which handles parsing and deals with low
level record generation for formulas. I have the code but its not
immediately accesible to me.
i dont rem xactly what i did cos its been some time now. how much time
do u have?
nishant
On 12/8/05, Thierry Morel <th...@free.fr> wrote:
> Hi Chandra, thank U very much for your answer, I saw U had been the same
pb
> some time ago,
> I'm very lucky you're online.
> But I'm a little bit scared to modify the parsing, it seems to me pretty
> tricky, and I wonder if U
> remember the way U did that ?
> Did U recompile POI, or just called a setParser method ? Or would U have
> some lines of code ?
> I know it is not veru kind to ask for code, but I'm really under water....
>
> Have a nice day
> Thy
>
>
> ----- Original Message -----
> From: "Nishant Chandra" <ni...@gmail.com>
> To: "POI Users List" <po...@jakarta.apache.org>
> Sent: Thursday, December 08, 2005 1:22 PM
> Subject: Re: Remote reference formula support
>
>
> Well i think this is a bug. I solved this problem by modifying the way
> the formula is parsed.
>
> Nishant
>
> On 12/8/05, Thy <th...@free.fr> wrote:
> > Hi all,
> > exactly the same pb as Chandra with
> cell.setCellFormula(AC129+$Sheet1.AC131)
> >
> > but not found any answer through the web for hours...
> > I've found many similar posts but no solution.
> > Is there any solution ?
> > I've tried with Poi2.5, 2.5.1 and 3.0alpha, no difference.
> > Thank U very much in advance for a tip !
> > Thy
> >
> > StackTrace :
> > java.lang.StringIndexOutOfBoundsException: String index out of range: 0
> >
> > at java.lang.String.charAt(String.java:558)
> >
> > 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:291)
> >
> > at org.apache.poi.hssf.model.FormulaParser.Factor
> > (FormulaParser.java:474)
> >
> > at
> org.apache.poi.hssf.model.FormulaParser.Term(FormulaParser.java:548)
> >
> > at
> org.apache.poi.hssf.model.FormulaParser.Add(FormulaParser.java:562)
> >
> > at org.apache.poi.hssf.model.FormulaParser.Expression
> > (FormulaParser.java:598)
> >
> > at
> org.apache.poi.hssf.model.FormulaParser.parse(FormulaParser.java:700)
> >
> > at org.apache.poi.hssf.usermodel.HSSFCell.setCellFormula
> > (HSSFCell.java:678)
> >
> > Nishant Chandra <nishant.chandra <at> gmail.com> writes:
> >
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> > 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
> I thought that I had no time for faith nor time to pray,
> then I saw an armless man saying his Rosary with his feet.
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> Mailing List: http://jakarta.apache.org/site/mail2.html#poi
> The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> 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
I thought that I had no time for faith nor time to pray,
then I saw an armless man saying his Rosary with his feet.
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
Re: Remote reference formula support
Posted by Nishant Chandra <ni...@gmail.com>.
Hi,
well i modified 3-4 files which handles parsing and deals with low
level record generation for formulas. I have the code but its not
immediately accesible to me.
i dont rem xactly what i did cos its been some time now. how much time
do u have?
nishant
On 12/8/05, Thierry Morel <th...@free.fr> wrote:
> Hi Chandra, thank U very much for your answer, I saw U had been the same pb
> some time ago,
> I'm very lucky you're online.
> But I'm a little bit scared to modify the parsing, it seems to me pretty
> tricky, and I wonder if U
> remember the way U did that ?
> Did U recompile POI, or just called a setParser method ? Or would U have
> some lines of code ?
> I know it is not veru kind to ask for code, but I'm really under water....
>
> Have a nice day
> Thy
>
>
> ----- Original Message -----
> From: "Nishant Chandra" <ni...@gmail.com>
> To: "POI Users List" <po...@jakarta.apache.org>
> Sent: Thursday, December 08, 2005 1:22 PM
> Subject: Re: Remote reference formula support
>
>
> Well i think this is a bug. I solved this problem by modifying the way
> the formula is parsed.
>
> Nishant
>
> On 12/8/05, Thy <th...@free.fr> wrote:
> > Hi all,
> > exactly the same pb as Chandra with
> cell.setCellFormula(AC129+$Sheet1.AC131)
> >
> > but not found any answer through the web for hours...
> > I've found many similar posts but no solution.
> > Is there any solution ?
> > I've tried with Poi2.5, 2.5.1 and 3.0alpha, no difference.
> > Thank U very much in advance for a tip !
> > Thy
> >
> > StackTrace :
> > java.lang.StringIndexOutOfBoundsException: String index out of range: 0
> >
> > at java.lang.String.charAt(String.java:558)
> >
> > 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:291)
> >
> > at org.apache.poi.hssf.model.FormulaParser.Factor
> > (FormulaParser.java:474)
> >
> > at
> org.apache.poi.hssf.model.FormulaParser.Term(FormulaParser.java:548)
> >
> > at
> org.apache.poi.hssf.model.FormulaParser.Add(FormulaParser.java:562)
> >
> > at org.apache.poi.hssf.model.FormulaParser.Expression
> > (FormulaParser.java:598)
> >
> > at
> org.apache.poi.hssf.model.FormulaParser.parse(FormulaParser.java:700)
> >
> > at org.apache.poi.hssf.usermodel.HSSFCell.setCellFormula
> > (HSSFCell.java:678)
> >
> > Nishant Chandra <nishant.chandra <at> gmail.com> writes:
> >
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> > 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
> I thought that I had no time for faith nor time to pray,
> then I saw an armless man saying his Rosary with his feet.
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> Mailing List: http://jakarta.apache.org/site/mail2.html#poi
> The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> 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
I thought that I had no time for faith nor time to pray,
then I saw an armless man saying his Rosary with his feet.
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
Re: Remote reference formula support
Posted by Thierry Morel <th...@free.fr>.
Hi Chandra, thank U very much for your answer, I saw U had been the same pb
some time ago,
I'm very lucky you're online.
But I'm a little bit scared to modify the parsing, it seems to me pretty
tricky, and I wonder if U
remember the way U did that ?
Did U recompile POI, or just called a setParser method ? Or would U have
some lines of code ?
I know it is not veru kind to ask for code, but I'm really under water....
Have a nice day
Thy
----- Original Message -----
From: "Nishant Chandra" <ni...@gmail.com>
To: "POI Users List" <po...@jakarta.apache.org>
Sent: Thursday, December 08, 2005 1:22 PM
Subject: Re: Remote reference formula support
Well i think this is a bug. I solved this problem by modifying the way
the formula is parsed.
Nishant
On 12/8/05, Thy <th...@free.fr> wrote:
> Hi all,
> exactly the same pb as Chandra with
cell.setCellFormula(AC129+$Sheet1.AC131)
>
> but not found any answer through the web for hours...
> I've found many similar posts but no solution.
> Is there any solution ?
> I've tried with Poi2.5, 2.5.1 and 3.0alpha, no difference.
> Thank U very much in advance for a tip !
> Thy
>
> StackTrace :
> java.lang.StringIndexOutOfBoundsException: String index out of range: 0
>
> at java.lang.String.charAt(String.java:558)
>
> 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:291)
>
> at org.apache.poi.hssf.model.FormulaParser.Factor
> (FormulaParser.java:474)
>
> at
org.apache.poi.hssf.model.FormulaParser.Term(FormulaParser.java:548)
>
> at
org.apache.poi.hssf.model.FormulaParser.Add(FormulaParser.java:562)
>
> at org.apache.poi.hssf.model.FormulaParser.Expression
> (FormulaParser.java:598)
>
> at
org.apache.poi.hssf.model.FormulaParser.parse(FormulaParser.java:700)
>
> at org.apache.poi.hssf.usermodel.HSSFCell.setCellFormula
> (HSSFCell.java:678)
>
> Nishant Chandra <nishant.chandra <at> gmail.com> writes:
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> 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
I thought that I had no time for faith nor time to pray,
then I saw an armless man saying his Rosary with his feet.
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
Re: Remote reference formula support
Posted by Nishant Chandra <ni...@gmail.com>.
Well i think this is a bug. I solved this problem by modifying the way
the formula is parsed.
Nishant
On 12/8/05, Thy <th...@free.fr> wrote:
> Hi all,
> exactly the same pb as Chandra with cell.setCellFormula(AC129+$Sheet1.AC131)
>
> but not found any answer through the web for hours...
> I've found many similar posts but no solution.
> Is there any solution ?
> I've tried with Poi2.5, 2.5.1 and 3.0alpha, no difference.
> Thank U very much in advance for a tip !
> Thy
>
> StackTrace :
> java.lang.StringIndexOutOfBoundsException: String index out of range: 0
>
> at java.lang.String.charAt(String.java:558)
>
> 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:291)
>
> at org.apache.poi.hssf.model.FormulaParser.Factor
> (FormulaParser.java:474)
>
> at org.apache.poi.hssf.model.FormulaParser.Term(FormulaParser.java:548)
>
> at org.apache.poi.hssf.model.FormulaParser.Add(FormulaParser.java:562)
>
> at org.apache.poi.hssf.model.FormulaParser.Expression
> (FormulaParser.java:598)
>
> at org.apache.poi.hssf.model.FormulaParser.parse(FormulaParser.java:700)
>
> at org.apache.poi.hssf.usermodel.HSSFCell.setCellFormula
> (HSSFCell.java:678)
>
> Nishant Chandra <nishant.chandra <at> gmail.com> writes:
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> 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
I thought that I had no time for faith nor time to pray,
then I saw an armless man saying his Rosary with his feet.
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
Re: Remote reference formula support
Posted by Thy <th...@free.fr>.
Hi all,
exactly the same pb as Chandra with cell.setCellFormula(AC129+$Sheet1.AC131)
but not found any answer through the web for hours...
I've found many similar posts but no solution.
Is there any solution ?
I've tried with Poi2.5, 2.5.1 and 3.0alpha, no difference.
Thank U very much in advance for a tip !
Thy
StackTrace :
java.lang.StringIndexOutOfBoundsException: String index out of range: 0
at java.lang.String.charAt(String.java:558)
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:291)
at org.apache.poi.hssf.model.FormulaParser.Factor
(FormulaParser.java:474)
at org.apache.poi.hssf.model.FormulaParser.Term(FormulaParser.java:548)
at org.apache.poi.hssf.model.FormulaParser.Add(FormulaParser.java:562)
at org.apache.poi.hssf.model.FormulaParser.Expression
(FormulaParser.java:598)
at org.apache.poi.hssf.model.FormulaParser.parse(FormulaParser.java:700)
at org.apache.poi.hssf.usermodel.HSSFCell.setCellFormula
(HSSFCell.java:678)
Nishant Chandra <nishant.chandra <at> gmail.com> writes:
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/