Thanks for the quick response. I'll file a bug report as 1st step.
On quick look at the code, I'm assuming one area that will need adjustment is the createPtg method in the Ptg class? I'm thinking of adding a new "case" test and write a new Ptg class. This should address these warnings: [WARNING] Unknown Ptg 3c (60) [WARNING] Unknown Ptg 3c (60) [WARNING] Unknown Ptg 60 (96) [WARNING] Unknown Ptg 60 (96) Am I on the right path? -Todd Quoting "Andrew C. Oliver" <[EMAIL PROTECTED]>: > It means it is a token for formulas that we haven't implemented. Since > formula tokens are variable length this is a fairly serious warning (and > cannot be suppressed as a result). Its just going to be a matter of someone > picking up a hammer and implementing the few remaining things we can't do in > formulas. > > If you're not happy writing parsers and playing with hex dumps, you can > still contribute to the cause by filing a bug report and attaching a sample > sheet. > > -Andy > -- > Andrew C. Oliver > http://www.superlinksoftware.com/poi.jsp > Custom enhancements and Commercial Implementation for Jakarta POI > > http://jakarta.apache.org/poi > For Java and Excel, Got POI? > > The views expressed in this email are those of the author and are almost > definitely not shared by the Apache Software Foundation, its board or its > general membership. In fact they probably most definitively disagree with > everything espoused in the above email. > > > From: Todd McGrath <[EMAIL PROTECTED]> > > Reply-To: "POI Users List" <[EMAIL PROTECTED]> > > Date: Mon, 23 Feb 2004 12:23:07 -0800 > > To: POI Users List <[EMAIL PROTECTED]> > > Subject: tracking down "Unknown Ptg" errors > > > > Hello, > > Long time listener, 1st time caller. > > > > I'm experiencing the issue described here: > > http://www.mail-archive.com/[EMAIL PROTECTED]/msg03074.html > > > > In short, I read in an existing Excel, set some cell data using POI 2.0 > Final > > 20040126 and then write back out to a different name. Console is showing: > > > > [WARNING] Unknown Ptg 3c (60) > > [WARNING] Unknown Ptg 3c (60) > > [WARNING] Unknown Ptg 60 (96) > > [WARNING] Unknown Ptg 60 (96) > > [WARNING] Unknown Ptg 11 (17) at cell (3,20) > > [WARNING] Unknown Ptg 11 (17) at cell (15,22) > > [WARNING] Unknown Ptg 11 (17) at cell (15,24) > > [WARNING] Unknown Ptg 11 (17) at cell (16,22) > > [WARNING] Unknown Ptg 11 (17) at cell (16,24) > > [WARNING] Unknown Ptg 11 (17) at cell (18,22) > > [WARNING] Unknown Ptg 11 (17) at cell (19,22) > > > > The new file opens fine in Excel 2000, but when I try to save, Excel > crashes. > > > > Can someone point me in the right direction for tracking these Unknown Ptg > > errors down? For example, does "Unknown Ptg 3c (60)" give me a indication > on > > where the problem is occuring; does "Unknown Ptg 11 (17) at cell (3,20)" > mean > > the problem is occurring at sheet 17, column 3, row 20? > > > > I'm not the author the input spreadsheet. I'm hoping to make changes in > the > > spreadsheet to resolve. (Similar to the link I sent above). > > > > Thank you, > > Todd > > > > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
