Thanks a lot, Daniel and Avik. I kind of understand it now. Not completely though. I will try and dig up some more info on this. I have some questions about your replies.
1. What is a ptg? 2. From Daniel's email: "The first and second dimensions are the row and column. For example, "A5" is a 2D cell reference. The third dimension is the multiple sheets. For example, "Sheet1!A5" is a 3D cell reference." Does that mean for the message: [WARNING] Unknown Ptg 3d (61), the problem lies in row 3 and column D. Is the 3rd dimension '61'? I do not understand that at all. Is this consistent with what Avik said about ptgError3d? I know for a fact that no sheet on my workbook has a cell 3D with anything in it. However, I do have a ton of cells on all sheets which make cross sheet references. I don't think I can get rid of them. These sheets are more than a year old and have been edited by many people. I just got them and I can't change them in any way, I can just read data from them. 3. Are these warning serious or something I could ignore with some degree of confidence? I can't compile from source as we have some rules in our company about which jars to use. If this continues to be a problem, I am thinking of writing some VB code which will take all relevant cell data from each sheet and create new workbooks with just the data I need, no formulas, no formatting, no cell references just like a dump. Then use this cleaner sheet and read it from POI. Harsh. -----Original Message----- From: Avik Sengupta [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 13, 2006 2:07 AM To: [email protected] Subject: Re:Turn off warning in POI yup, hex 3d (decimal 61) is the ID for ptgAreaError3d . So what you should be looking for is a #REF in your sheets on a cell with a sheet reference. Since Ptg's dont contain size fields in the records, one unknown ptg can cause subsequent ptgs to be unrecognised. Usually, however, the error is contained within that particular cell. At the very least, therefore, that cell will have some junk written in if you write the sheet back. The best thing to do is to remove such objects from your sheets. Alternatively, this is a very simple ptg, and you should be able to implement it quite easily. The warning is itself written to std err. Its not a configurable thing. If you dont want to see it in your environment, just comment it out in source, and recompile... it'll be a two minute job... Regards - Avik On Tuesday 13 June 2006 05:47, Daniel Noll wrote: > Chaudhary, Harsh wrote: > > Hi all, > > While using POI to access a spreadsheet, I get the following warning: > > > > [WARNING] Unknown Ptg 3d (61) > > > > [WARNING] Unknown Ptg 3d (61) > > > > I would appreciate it if someone could tell me what that means. I did > > some searching and I believe that this has something to do with 3D > > objects. I don't have such an object in my sheet, not even a chart, but > > it is possible someone at some point in time inserted one in there. > > Unless I am wrong about the cause of this warning. > > The first and second dimensions are the row and column. For example, > "A5" is a 2D cell reference. The third dimension is the multiple > sheets. For example, "Sheet1!A5" is a 3D cell reference. > > So all it means is that a formula on one of your sheets has a reference > to another sheet. > > Daniel --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
