Summary: | Java BC Dates don't seem to become AD dates when converted to Excel | ||
---|---|---|---|
Product: | POI | Reporter: | Matthew Carey <matthew> |
Component: | HSSF | Assignee: | POI Developers List <dev> |
Status: | RESOLVED WONTFIX | ||
Severity: | normal | ||
Priority: | P2 | ||
Version: | 3.9-FINAL | ||
Target Milestone: | --- | ||
Hardware: | PC | ||
OS: | Linux |
Description
Matthew Carey
2013-03-22 17:47:13 UTC
There is a chance that this is a LibreOffice issue. You might have a slight - well large - problem here. As far as I am aware, Excel is not able to handle dates prior to 1900AD without special add ins. Just what they are, I do not know and feel that you need to consult an Excel specialist - try one of the on-line forums for Excel users as a start - to discover this information. Commonly, users who need to enter such dates keep them in a simple text format. This will only work if you do not need to perform date arithmetic using such values. If you just wish to show the year - 1066 AD or 500 BC - then there is a format trick that I found. Take a look here - http://answers.microsoft.com/en-us/office/forum/office_2007-excel/using-bc-and-ad-years-in-an-excel-spreadsheet/24f7ec42-de34-4bd0-b284-292a1770b8f7 Thanks, I can live with this as the customer wants reports on a database in excel format, they will have to put up with fields that contain remote dates being rendered as strings. But it useful to see the workaround suggested. I dont think we will plan to put anything into poi directly, there seem to be workarounds possible if needed. |