xlsx_names does not see some named ranges

[bczucz]

Hi,
according to the Name Manager, this xlsx file contains ~30 named ranges, but xlsx_names() does not seem to be able to see any of them. What can be going on here?
Thanks a lot,
Balint

[nacnudus]

Unfortunately, I no longer have access to Microsoft Excel to check this. LibreOffice Calc doesn't show any named ranges. Unzipping the file, and looking in xl/workbook.xml, there is no node called definedNames, which is where tidyxl looks for them. I would have to consult the spec again to be sure that named ranges aren't ever recorded anywhere else. What is the name of one range that I could look for in the file?

[bczucz]

Thank you for looking into this.
Here are the names (and other properties) of the first ~15 ranges seen by Microsoft Excel for Windows (Microsoft 365 MSO Version 2506 Build 16.0.18925.20216 64-bit) in this file. Apparently there must still be another node somewhere in the xml that Excel recognises as named ranges. I hope that this list can help you to diagnose the file... and let me know if I can help you with more info.

[nacnudus]

Thanks. These are tables, which it turns out aren't included with the other named ranges.

#96 is related.

I'm really sorry, but I'm not likely to work on this. If you (or anyone reading this) would like to have a go at it, then the key things to know are:

• A worksheet can have a tableParts tag, containing tablePart tags, e.g. <tablePart r:id="rId30"/>.
• Each worksheet has a _rels file, e.g. xl/worksheets/_rels/sheet15.xml.rels, which contains a Relationships tag, which contains relationship tags, e.g. <Relationship Id="rId30" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/table" Target="../tables/table30.xml"/>. The Target attribute is a path to the file that describes the table. To find the _rels file of the worksheet, consider doing something similar to

  tidyxl/src/tidyxl.cpp

  Line 88 in f8e5928

  comments_paths.insert({id, comments_path_(path, target)});

  .
• The table's file has a tag table with attributes including name, displayName and ref (A1-style).

[bczucz]

Thanks, @nacnudus for having looked into this.
Unfortunately I don't have enough skills for this. I hope that there will be someone better skilled who can have a go. 🤞