Error opening xlsx, __init__() got an unexpected keyword argument 'fLocksText'

[Anna Coleman]

Strange error on load_workbook(), win 10 x64, python 3.7, openpyxl==2.5.8:

wb = load_workbook(input_file)
  File "D:\Miniconda3\lib\site-packages\openpyxl-2.5.8-py3.7.egg\openpyxl\reader\excel.py", line 276, in load_workbook
    for c in find_charts(archive, rel.target):
  File "D:\Miniconda3\lib\site-packages\openpyxl-2.5.8-py3.7.egg\openpyxl\chart\reader.py", line 50, in find_charts
    drawing = SpreadsheetDrawing.from_tree(tree)
  File "D:\Miniconda3\lib\site-packages\openpyxl-2.5.8-py3.7.egg\openpyxl\descriptors\serialisable.py", line 84, in from_tree
    obj = desc.expected_type.from_tree(el)
  File "D:\Miniconda3\lib\site-packages\openpyxl-2.5.8-py3.7.egg\openpyxl\descriptors\serialisable.py", line 84, in from_tree
    obj = desc.expected_type.from_tree(el)
  File "D:\Miniconda3\lib\site-packages\openpyxl-2.5.8-py3.7.egg\openpyxl\descriptors\serialisable.py", line 100, in from_tree
    return cls(**attrib)
TypeError: __init__() got an unexpected keyword argument 'fLocksText'

[Anna Coleman]

Also tried with openpyxl==2.6.0.dev0 branch, same error.

[Anna Coleman]

2.5.0 - error

2.4.11 - works, so, for googlers, temp solution for this (if your file don't need 2.5-2.6 functionality):

pip uninstall openpyxl
conda uninstall openpyxl
pip install openpyxl==2.4.11

[CharlieC]

Thanks for the report and the file. The problem is related to a shape in the worksheet. 2.5 and later try to load images and charts but earlier versions don't which is why you're seeing the behaviour you are.

[CharlieC]

Add missing attribute definition. Resolves #1106

→ <<cset 78e518fd07b7>>

[Brandon Marks]

Is there any plan to fix this for future versions? This works for now but could be problematic moving forward…