diff options
| author | PJ Fanning <fanningpj@apache.org> | 2021-08-06 15:22:32 +0000 |
|---|---|---|
| committer | PJ Fanning <fanningpj@apache.org> | 2021-08-06 15:22:32 +0000 |
| commit | b864503d477b114d00b6f7b078f906a3ccb1f55f (patch) | |
| tree | 8e6e54085b1cadb214377f61cf90888a448df3c9 /poi | |
| parent | eecb44281e5106d690d7dada9183910369419980 (diff) | |
| download | poi-b864503d477b114d00b6f7b078f906a3ccb1f55f.tar.gz poi-b864503d477b114d00b6f7b078f906a3ccb1f55f.zip | |
extend tests
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1892042 13f79535-47bb-0310-9956-ffa450edef68
Diffstat (limited to 'poi')
| -rw-r--r-- | poi/src/test/java/org/apache/poi/ss/formula/functions/TestDateValue.java | 7 |
1 files changed, 6 insertions, 1 deletions
diff --git a/poi/src/test/java/org/apache/poi/ss/formula/functions/TestDateValue.java b/poi/src/test/java/org/apache/poi/ss/formula/functions/TestDateValue.java index 95e518de2b..a36a714d14 100644 --- a/poi/src/test/java/org/apache/poi/ss/formula/functions/TestDateValue.java +++ b/poi/src/test/java/org/apache/poi/ss/formula/functions/TestDateValue.java @@ -74,10 +74,15 @@ final class TestDateValue { // // EXCEL confirmDateValue(new StringEval("8/22/2011"), 40777); // Serial number of a date entered as text. - confirmDateValue(new StringEval("8/22/2011 12:00"), 40777); // Serial number of a date entered as text. confirmDateValue(new StringEval("22-MAY-2011"), 40685); // Serial number of a date entered as text. confirmDateValue(new StringEval("2011/02/23"), 40597); // Serial number of a date entered as text. + //ignore time parts + confirmDateValue(new StringEval("8/22/2011 12:00"), 40777); // Serial number of a date entered as text. + confirmDateValue(new StringEval("8/22/2011 6:02:23 PM"), 40777); // Serial number of a date entered as text. + confirmDateValue(new StringEval("22-AUG-2011 6:02:23PM"), 40777); // Serial number of a date entered as text. + confirmDateValue(new StringEval("22-AUG-2011 6:02:23AM"), 40777); // Serial number of a date entered as text. + // LibreOffice compatibility confirmDateValue(new StringEval("1954-07-20"), 19925); } finally { |