poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Avik Sengupta <avik.sengu...@itellix.com>
Subject Re:Turn off warning in POI
Date Tue, 13 Jun 2006 07:07:24 GMT
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: 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/


Mime
View raw message