Skip to content
GitLab
Projects Groups Topics Snippets
  • /
  • Help
    • Help
    • Support
    • Community forum
    • Submit feedback
    • Contribute to GitLab
  • Register
  • Sign in
  • O openpyxl
  • Project information
    • Project information
    • Activity
    • Labels
    • Members
  • Repository
    • Repository
    • Files
    • Commits
    • Branches
    • Tags
    • Contributor statistics
    • Graph
    • Compare revisions
  • Issues 284
    • Issues 284
    • List
    • Boards
    • Service Desk
    • Milestones
  • Merge requests 7
    • Merge requests 7
  • 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
  • #1947
Closed
Open
Issue created Feb 01, 2023 by IkeKazan@IkeKazan

Missing local defined names in loaded spreadsheet in 3.1.0

When using openpyxl.load_workbook():

with openpyxl 3.1.0.

  1. Local (for specific Sheet) defined names are not stored in Worksheet.defined_names dict (empty dict)
  2. Global defined names are stored in Workbook.defined_names dict with one key.

with openpyxl 3.0.10

  1. All defined names are stored correctly in Workbook.defined_names.definedName

Test workbook

TestWB.xlsx

image

Code

test.py

Debug

openpyxl 3.0.10 image

openpyxl 3.1.0 image

python 3.10.5

openpyxl 3.0.10 & 3.1.0

VS code

Windows 10

Updated:

Global defined names in 3.1.0 are stored correctly

Edited Feb 01, 2023 by IkeKazan
To upload designs, you'll need to enable LFS and have an admin enable hashed storage. More information
Assignee
Assign to
Time tracking