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
  • !398

Timedelta and iso_dates

  • Review changes

  • Download
  • Email patches
  • Plain diff
Merged nmartensen requested to merge topic/3.0/iso_delta into branch/3.0 Feb 27, 2021
  • Overview 0
  • Commits 2
  • Pipelines 1
  • Changes 2

When iso_dates is set to True, openpyxl does not really know what to do with timedeltas since the XLSX specification does not provide a suitable string representation for them. It currently divides the duration by full days, discards the integer ratio and converts the fractional day remainder to time of day. This makes it impossible to roundtrip timedelta values through files using iso_dates=True, in particular timedeltas of more than 24 hours.

Instead of doing the lossy conversion from timedelta to time, perhaps we can ignore the iso_dates property when storing timedelta.

Assignee
Assign to
Reviewers
Request review from
Time tracking
Source branch: topic/3.0/iso_delta