Defined names not found when they are protected/locked
I have an Excel sheet with multiple defined names (I can confirm and access them using "Name Manager", under Formulas). When using openpyxl
to read in the Workbook and access the defined names (wb = load_workbook(filename="my_excel_file.xlsx"); wb.defined_names
), it prints only the defined names that are not protected (not greyed out in Name Manager).
Is this a bug? I cannot for the life of me find an option to actively include protected names, but would assume that all defined names should show up regardless this way in Python?
Technical details: Windows 10, Python 3.8.5, openpyxl 3.0.4 (I downgraded because of a bug in 3.0.5 that didn't read in my Excel file)
Thanks!