Skip to content
GitLab
Projects Groups Snippets
  • /
  • Help
    • Help
    • Support
    • Community forum
    • Submit feedback
    • Contribute to GitLab
  • Sign in / Register
  • O openpyxl
  • Project information
    • Project information
    • Activity
    • Labels
    • Members
  • Repository
    • Repository
    • Files
    • Commits
    • Branches
    • Tags
    • Contributors
    • Graph
    • Compare
  • Issues 248
    • Issues 248
    • List
    • Boards
    • Service Desk
    • Milestones
  • Merge requests 5
    • Merge requests 5
  • CI/CD
    • CI/CD
    • Pipelines
    • Jobs
    • Schedules
  • Deployments
    • Deployments
    • Environments
    • Releases
  • Packages and registries
    • Packages and registries
    • Container Registry
  • Monitor
    • Monitor
    • Incidents
  • Analytics
    • Analytics
    • Value stream
    • CI/CD
    • Repository
  • Snippets
    • Snippets
  • Activity
  • Graph
  • Create a new issue
  • Jobs
  • Commits
  • Issue Boards
Collapse sidebar

April 05-07 - Mercurial Paris Conference 2023 - One day of workshop dedicated to Heptapod and Mercurial usage and workflow. There are still places available for both workshops and talks!

  • openpyxl
  • openpyxl
  • Merge requests
  • !391

Datetime updates

  • Review changes

  • Download
  • Email patches
  • Plain diff
Closed nmartensen requested to merge topic/3.0/datetime_updates into branch/3.0 Feb 08, 2021
  • Overview 5
  • Commits 4
  • Pipelines 2
  • Changes 2

This MR has two parts:

  1. Round datetimes returned by from_excel() to milliseconds, which according to the specification is the recommended baseline precision.
  2. Deserialize 1 to 1900-01-01 (instead of 1899-12-31) in the 1900 date system, to avoid jumping dates when moving to 1+ε, and to increase compatibility with Excel.
Edited Feb 09, 2021 by nmartensen
Assignee
Assign to
Reviewers
Request review from
Time tracking
Source branch: topic/3.0/datetime_updates