> -----Original Message----- > From: Andrew C. Oliver [mailto:acoliver@;apache.org] > Sent: Tuesday, November 05, 2002 12:07 PM > To: POI Users List > Subject: Re: CellReference vs. RangeAddress (was RE: ExtenXLS > Feature Matrix - compares to POI) > > > > >Cell ref = Summary!$D$31 > >java.lang.NumberFormatException: D$31 > > at java.lang.Integer.parseInt(Integer.java:426) > > at java.lang.Integer.parseInt(Integer.java:476) > > at > >org.apache.poi.hssf.util.CellReference.<init>(CellReference.java:82) > > > >because it doesn't seem to be parsing the string right (it > doesn't pass > >over the sheet name before trying to parse row/col information out. > > > > > It doesn't know about $ format yet.
Actually, it knows about $, it just wasn't skipping over "sheetname!" before parsing the row/col. I submitted a patch. It works for me now. -- To unsubscribe, e-mail: <mailto:poi-user-unsubscribe@;jakarta.apache.org> For additional commands, e-mail: <mailto:poi-user-help@;jakarta.apache.org>
