https://issues.apache.org/bugzilla/show_bug.cgi?id=48528
Jaibabu <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEEDINFO |NEW --- Comment #5 from Jaibabu <[email protected]> 2010-01-21 00:06:56 UTC --- Hai Josh, Thanks for your response. I herewith attaching the Java file i used for writing Excel file using POI. (The java code reads a template excel file and generates the new Excel file with new values.) I am also attaching the "DemoTemplateFile.xlsx" which is used as a template file(from which the POI reads the format and formula) and "sampledemo.xlsx" file that POI generates using java code. In sampledemo.xlsx file please check the column "B12-B19" the Date formula is not evaluated correctly. But it evaluates the Date formula above that cell (B7-B11) correctly. The formula used in that column is DATE( YEAR( B6 ), MONTH( B6 )-1, DAY( B6 ) ) Assuming -1 is the problem in evaluation. If suppose if i use +1 instead it is evaluating correctly. Please refer Column (A7-A19). I used formula Evaluator to evaluate the formula cells in the Sheet. But i get the same result. Hope this may be useful for you. Thanks Jaibabu.J -- Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
