poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 55295] New: DateUtil.isCellDateFormatted should probably handle data format "reserved-0x1c"
Date Tue, 23 Jul 2013 07:27:05 GMT

            Bug ID: 55295
           Summary: DateUtil.isCellDateFormatted should probably handle
                    data format "reserved-0x1c"
           Product: POI
           Version: 3.9
          Hardware: All
                OS: All
            Status: NEW
          Severity: normal
          Priority: P2
         Component: HSSF
          Assignee: dev@poi.apache.org
          Reporter: thilo@cpan.org

I have an Excel file with dates in them. The internal numeric value can be
retrieved correctly, but DateUtil.isCellDateFormatted does not recognize it as
a date format.

Debugging, it fails at

public static boolean isADateFormat(int formatIndex, String formatString) {

where formatString is "reserved-0x1c"

I could find no good documentation on that format string (and unfortunately
cannot share the file in question), but it seems to be a date format used by
Chinese versions of Excel.

LibreOffice correctly shows it as a date (but OS X Preview does not -- shows up
as a number).

You are receiving this mail because:
You are the assignee for the bug.

To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

View raw message