https://issues.apache.org/bugzilla/show_bug.cgi?id=48528
Summary: An Error in Date() function
Product: POI
Version: 3.5-FINAL
Platform: PC
OS/Version: Windows XP
Status: NEW
Severity: major
Priority: P2
Component: XSSF
AssignedTo: [email protected]
ReportedBy: [email protected]
Hai Experts,
While creating an Excel Template with POI 3.5-FINAL API the DATE()
function works abnormally. I used the following function
DATE(YEAR(A20),MONTH(A20)-1,DAY(A20))
ie., DATE(YEAR(previouscolumn value),MONTH(PreviousColumn Value)-1,
DAY(PreviousCOlumn
Value))
The above formula is working for some date ranges. If the previous column
value is "February-09" it is correctly calculating the next value as
"January-09"
using the above formula. But it fails after that. After "January-09" the next
evaluation of the formula is not working properly saying "#Value" in the column
with out any error such as "Not Yet Implemented". If i keep the cursor in the
particular cell and i press enter without changing the value or formula then
the excel calculates the value correctly. Hope this is a bug in POI 3.5-Final
API. How can i overcome this.
Thanks
Jaibabu
--
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]
