Bug 67402 - [PATCH] DATEVALUE function should return #VALUE! for a null or empty string argument
Summary: [PATCH] DATEVALUE function should return #VALUE! for a null or empty string a...
Status: RESOLVED FIXED
Alias: None
Product: POI
Classification: Unclassified
Component: SS Common (show other bugs)
Version: unspecified
Hardware: PC All
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-09-14 12:47 UTC by Jakub
Modified: 2023-09-17 16:37 UTC (History)
1 user (show)


Attachments
Patch for the DateValue and the TestDateValue classes to return #VALUE! for empty string (2.65 KB, text/plain)
2023-09-14 12:47 UTC, Jakub 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Jakub 2023-09-14 12:47:35 UTC 
Created attachment 39030 [details]
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.
Comment 1 PJ Fanning 2023-09-14 14:13:41 UTC 
thanks - merged with r1912313