Hi Josh, Thanks a lot for the help and the quick response. This has been my first time that i raised a query at this forum and I really appreciate the urgency with which you have fixed this bug and resolved my issue. Thanks a lot for your help.
Just one more question. Do u plan to add implementation for all excel functions in 3.5FINAL? Just like SUMIF I can come across some other function which is not yet implemented in poi. Thanks & Regards, Sapan Josh Micich wrote: > > Hello Sapan, > >> ... In fact i solved this issue in a different way. I >> read all the formula cells in the excel, and added following code: >> ... >> String str = cell.getCellFormula(); >> cell.setCellFormula(str); > > If these 2 lines really make a difference, that would represent a bug in > POI. Can you please upload an example where this is the case? > > >> From the bug it seems it is fixed in version 3.0. But I am using version > 3.5 >> beta. > > I marked the bug as 'present in version 3.0'. Each fixed bugzilla usually > has a comment linking to the svn revision, which should tell you at > exactly > what point on the trunk the fix was applied. If there is no link, you can > make a guess from the fix date. > > >> Can you please send me all the related java files you have modified or >> the >> updated jar file or patch. > > There are generally 4 ways to get a recent POI fix. Here they are (in > order > of reliability): > 1 - Wait for the next release - in this case that would be 3.5FINAL, due > in > Feb > 2 - Get the next nightly build from > http://encore.torchbox.com/poi-svn-build/ > 3 - Check out the latest svn trunk, and build it yourself > 4 - Find the relevant changes to individual files, patch them into your > local copy and re-build > > If you really need to go the last route, Here are the two changes that > should do the trick: > http://svn.apache.org/viewvc?view=rev&revision=734243 > http://svn.apache.org/viewvc?view=rev&revision=734252 > > regards, > Josh > > -- View this message in context: http://www.nabble.com/SUMIF-function-does-not-work-with-POI-tp21431786p21471334.html Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
