https://bz.apache.org/bugzilla/show_bug.cgi?id=67402
Bug ID: 67402 Summary: [PATCH] DATEVALUE function should return #VALUE! for a null or empty string argument Product: POI Version: unspecified Hardware: PC Status: NEW Severity: normal Priority: P2 Component: SS Common Assignee: dev@poi.apache.org Reporter: jakub.vojti...@gmail.com Target Milestone: --- Created attachment 39030 --> https://bz.apache.org/bugzilla/attachment.cgi?id=39030&action=edit Patch for the DateValue and the TestDateValue classes to return #VALUE! for empty string The DATEVALUE function in Excel evaluates to #VALUE! when a blank or empty string argument is passed in. POI implementation returns a blank value which is then displayed as 0. Patch for the DateValue and the TestDateValue is attached. Please let me know if anything in this bug or the patch can be improved as I'd like to submit (and possibly fix) more bugs. -- You are receiving this mail because: You are the assignee for the bug. --------------------------------------------------------------------- To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org