poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 48528] An Error in Date() function
Date Thu, 21 Jan 2010 08:06:57 GMT

Jaibabu <jaibabus@gmail.com> changed:

           What    |Removed                     |Added
             Status|NEEDINFO                    |NEW

--- Comment #5 from Jaibabu <jaibabus@gmail.com> 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.


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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

View raw message