xlsx: external_links_at_risk misses worksheet-scoped names and aliases to external references

import sys, tempfile
from pathlib import Path
from openpyxl import Workbook
from openpyxl.workbook.defined_name import DefinedName
from openpyxl.workbook.external_link.external import ExternalLink, ExternalBook, ExternalSheetNames
from openpyxl.packaging.relationship import Relationship
sys.path.insert(0, str(Path.cwd() / "skills/xlsx/scripts"))
from recalc import external_links_at_risk

with tempfile.TemporaryDirectory() as tmp:
    for variant in ("direct", "alias", "local", "ordinary"):
        wb = Workbook()
        ws = wb.active
        ws.title = "Main"
        ext = ExternalLink(externalBook=ExternalBook(
            sheetNames=ExternalSheetNames(sheetName=["Sheet1"]), id="rId1"))
        ext.file_link = Relationship(
            Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/externalLinkPath",
            Target="file:///audit-missing-source.xlsx", TargetMode="External", Id="rId1")
        wb._external_links.append(ext)
        if variant == "ordinary":
            ws["A1"] = "=1+1"
        elif variant == "local":
            ws.defined_names.add(DefinedName("ExternalAmount",
                attr_text="'[1]Sheet1'!$A$1", localSheetId=0))
            ws["A1"] = "=ExternalAmount"
        else:
            wb.defined_names.add(DefinedName("ExternalAmount",
                attr_text="'[1]Sheet1'!$A$1"))
            if variant == "alias":
                wb.defined_names.add(DefinedName("AliasAmount", attr_text="ExternalAmount"))
                ws["A1"] = "=AliasAmount"
            else:
                ws["A1"] = "=ExternalAmount"
        path = Path(tmp) / (variant + ".xlsx")
        wb.save(path)
        print(variant, external_links_at_risk(path))

direct ['Main!A1']
alias []
local []
ordinary []