Defensive change to avoid crashing on weird large Excel files

In file openpyxl / workbook / names / named_range.py line 127:

• node_text = name_node.text
• node_text = name_node.text or ''

This change avoided a crash and the data loaded from the files without further problems. Can not reproduce with other files and the ones that produce the bug are confidential :)

Thanks but what are we supposed to do with this?

definedNames are scheduled for a complete rewrite in 2.4 so this won't be relevant. How about a PR (with tests!) for 2.3?

I'll see what I can do about that next week. Prevented from actually contributing by an arcane copyright assignment clause right now :(

Thanks. I know it's a trivial change but doing it myself means having to think up a test case.

This is resolved in 2.4.

Removing version: 2.3.x (automated comment)