Skip to content

How to avoid Excel date and date-time format? #334

@livingstone1

Description

@livingstone1

My options:
PoijiOptions options = PoijiOptions.PoijiOptionsBuilder.settings() .preferNullOverDefault(true) .dateTimeFormatter(DateTimeFormatter.ofPattern("dd.MM.yyyy HH:mm:ss")) .build();

Known, that excel stores date and date-time values as doubles..
I set custom dateTimeFormatter and expect it in PoijiDataFormatter#formatRawCellContents, but this method uses format from Excel
Image

And DefaultCasting#localDateTimeValue method will try to parse string with Excel-format to my own
Image

Don't you think that using dateTimeFormatter from PoijiOptions in PoijiDataFormatter#formatRawCellContents for date and date-time cells will improve dev experience?

Metadata

Metadata

Assignees

No one assigned

    Labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions