Skip to content

Get OA dates as double instead of converted to DateTime/TimeSpan? #545

@jbrockerville

Description

@jbrockerville

Hi,

Incredibly useful library! However, like some other users, I have a date-time issue. The ones I looked at, and mine, seem to stem from the fact that the worksheet implementations detect and convert OA dates to DateTime or TimeSpan objects. For example, the XlsxWorksheet. From there, the problems seem like issues with system region formatting and Excel formatting and their interplay. This was my issue too until I figured out that the library was doing a conversion before the system region formatting came into play. I worked through it by understanding it. Cool. But I have found instances where I simply do not want any conversion whatsoever. I want to take Excel's and the system's formatting completely out of the equation and work with the raw double. Unfortunately, there does not seem to be an option to simply not do this and return the raw OA date double value, or at least none that I could find. Can you do that? Just return the OA date double? If not, could you please add the option to do so?

Thanks!
-jb

Metadata

Metadata

Assignees

No one assigned

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions