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 265
    • Issues 265
    • List
    • Boards
    • Service Desk
    • Milestones
  • Merge requests 6
    • Merge requests 6
  • 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
  • openpyxl
  • openpyxl
  • Issues
  • #2014
Closed
Open
Issue created Apr 18, 2023 by Lennart Brinkmann@lebrinkmaDeveloper

custom format for accouting value detected as date

Using openpyxl version 3.0.10 the following custom numeric format for an accounting value is detected as a date format:

#,##0.00\ _M"H"_);[Red]#,##0.00\ _M"S"_)

For example a numeric value of 10000 should be displayed as 10.000,00 H and -10000 as 10.000,00 S .

Minimal testfile attached.Test.xlsx

related to #1413 (closed).

Edited Apr 18, 2023 by Lennart Brinkmann
To upload designs, you'll need to enable LFS and have an admin enable hashed storage. More information
Assignee
Assign to
Time tracking