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 243
    • Issues 243
    • 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
  • !390

timedelta bug fix

  • Review changes

  • Download
  • Email patches
  • Plain diff
Merged nmartensen requested to merge topic/3.0/timedelta into branch/3.0 Jan 28, 2021
  • Overview 5
  • Commits 4
  • Pipelines 3
  • Changes 3

(was initially the same as !389 (closed), but rebased on the 3.0 branch, and now dropped one commit)

This MR changes two minor details in the code for reading time/date values from xlsx:

  • 0 is turned into time(0,0) instead of a full datetime
  • Negative serial dates are always turned into full datetimes, never time only.

Both changes are in line with the xlsx specification. This MR makes it possible to reliably retrieve timedelta values from xlsx files using the 1904 date system, including negative timedeltas.

Edited Feb 05, 2021 by nmartensen
Assignee
Assign to
Reviewers
Request review from
Time tracking
Source branch: topic/3.0/timedelta