Missing local defined names in loaded spreadsheet in 3.1.0
When using openpyxl.load_workbook():
with openpyxl 3.1.0.
- Local (for specific Sheet) defined names are not stored in Worksheet.defined_names dict (empty dict)
Global defined names are stored in Workbook.defined_names dict with one key.
with openpyxl 3.0.10
- All defined names are stored correctly in Workbook.defined_names.definedName
Test workbook
Code
Debug
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 by IkeKazan