Description and reproduction
Running the script
axlsx_print_area.rb (provided at end of issue) will produce an Excel workbook that, when unzipped, contains the
workbook.xml contents; also provided below. It can be observed that the name attributes of the
<definedName> nodes have been altered from their original form. This has a couple of undesirable side-effects.
It breaks behavior specified in the examples (repeating headers). Repeating headers are not actually produced.
Tangentially, it prevents one from using any of the built-in names specified in the source of
It mangles valid defined names, leading to confusion. For example, if the defined name "Example_Range" is specified, it will be converted to "ExampleRange".