Skip to content

Off-by-one error for xlsx time cells 12:34:13 PM #310

@mlrus

Description

@mlrus

https://gist.github.com/mlrus/32fef531c69d74c2e94d377456e75003

The value of xlsx.cell(1,1) is off-by-one for cell 12:23:13 PM. Methods #to_yaml and #to_csv report the incorrect value 12:34:12, and method #cell reports the incorrect 45252 instead of 45253.

The xlsx cell representation of 12:23:13 PM is 0.523761574074074 (days). On transforming to seconds the floating-point value should be rounded for consistency with the cell's external value, 12:23:13 (45253).

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions