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
