Bug 62021 - XSSF fails to add time as String to date
Summary: XSSF fails to add time as String to date
Alias: None
Product: POI
Classification: Unclassified
Component: XSSF (show other bugs)
Version: 3.17-FINAL
Hardware: All All
: P2 enhancement (vote)
Target Milestone: ---
Assignee: POI Developers List
Depends on:
Reported: 2018-01-19 10:29 UTC by Nicolai Ehemann
Modified: 2021-10-12 21:50 UTC (History)
0 users


Note You need to log in before you can comment on or make changes to this bug.
Description Nicolai Ehemann 2018-01-19 10:29:39 UTC
Excel (at least Excel 2016, probably most older versions also) can add times to a datetime cell by adding a correctly formatted string, for example
A1 contains Datetime 1-Jan-17 12:00 PM
A2 contains Formula =A1+"1:30"
In Excel, this results in the content of A2 being 1-Jan-17 1:30 PM (as a Date).

In XSSF, this results in an error (#VALUE).
Comment 1 PJ Fanning 2021-10-12 21:50:43 UTC
this seems to work in the latest POI code - just added an XSSF test - r1894175