Wow. That loooks like a lot of work. Thanks for the info. Harsh. -----Original Message----- From: Daniel Noll [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 14, 2006 6:13 PM To: POI Users List Subject: Re: Turn off warning in POI
Chaudhary, Harsh wrote: > 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. To take one example, we found that % signs in formulas weren't handled by POI, and were causing a large number of warnings (formulas such as A3*10% are remarkably common when spreadsheets are being used for taxation or interest calculations.) So we had to implement a PercentPtg class, which turned out to be fairly simple. Code also had to be added to Ptg.java to create the PercentPtg object when the ID matched PercentPtg.sid. Cell reference code may be harder (or more interesting) than percent formulas, but existing classes like Ref3DPtg can probably go a long way toward figuring out what code is needed. The hardest part is figuring out how "big" the Ptg is (PercentPtg was 1, Ref3DPtg is 7, etc), for which you would need to refer to whatever format documentation you can dig 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/
