Like you pointed out, I care for just the results of a formula and not the formaula itself.
But just out of curiosity, how do you go about fixing and debugging something like this. I don't think the debugger is a good place as the sheet representation is usually very large. Also, if the cells which contain the formula are not recognized or handeled by POI, what can I do in : 1. POI 2. The excel sheet to take care of this? Its not something I need to know urgently, but I am very interested to know. As I said yesterday, I have written some VB code which creates new sheets and dumps just the data in. Thanks, Harsh. -----Original Message----- From: Daniel Noll [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 13, 2006 10:00 PM To: POI Users List Subject: Re: Turn off warning in POI Chaudhary, Harsh wrote: > 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. Actually, it is often possible to ignore this, but it depends how much information you need. If you need to know what the formula string was, then you'll have to deal with everything your formulas ever encounter. (Our own application leans towards this preference, but we have only implemented missing formula parts in the event that there are too many warnings being displayed in the logs. However, if all you need to know is the result of the formula (which is probably all most people need) then you don't need to worry about this kind of error at all. As for what Ptg stands for... allegedly it stands for "parse thing", though I don't see a mention of this in the javadocs for the Ptg class so maybe that was made up. :-) Daniel -- Daniel Noll Nuix Pty Ltd Suite 79, 89 Jones St, Ultimo NSW 2007, Australia Ph: +61 2 9280 0699 Web: http://www.nuix.com.au/ Fax: +61 2 9212 6902 This message is intended only for the named recipient. If you are not the intended recipient you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this message or attachment is strictly prohibited. --------------------------------------------------------------------- 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/
