Throws KeyNotFoundException when getting the count of drawings.

[robincodex]

EPPlus usage

Personal use

Environment

Windows

Epplus version

7.4.0

Spreadsheet application

Microsoft365 Excel

Description

This error appears after version 7.4.0, version 4.3.2 doesn't have this problem.

test.xlsx

This error occurs when sheet.Drawings.Count

System.Collections.Generic.KeyNotFoundException: The given key '' was not present in the dictionary.
   at System.Collections.Generic.Dictionary`2.get_Item(TKey key)
   at OfficeOpenXml.Packaging.ZipPackageRelationshipCollection.get_Item(String id)
   at OfficeOpenXml.Packaging.ZipPackagePartBase.GetRelationship(String id)
   at OfficeOpenXml.Drawing.ExcelPicture..ctor(ExcelDrawings drawings, XmlNode node, ExcelGroupShape shape)
   at OfficeOpenXml.Drawing.ExcelDrawing.GetDrawingFromNode(ExcelDrawings drawings, XmlNode node, XmlElement drawNode, ExcelGroupShape parent)
   at OfficeOpenXml.Drawing.ExcelDrawing.GetDrawing(ExcelDrawings drawings, XmlNode node)
   at OfficeOpenXml.Drawing.ExcelDrawings.AddDrawings()
   at OfficeOpenXml.Drawing.ExcelDrawings..ctor(ExcelPackage xlPackage, ExcelWorksheet sheet)
   at OfficeOpenXml.ExcelWorksheet.LoadDrawings()
   at OfficeOpenXml.ExcelWorksheet.get_Drawings()

[swmal]

Thanks for reporting, we will have a look at this.

[OssianEPPlus]

That's because we only recently added support for Linked Images, before we did not check the "linked" property.
Your file has a Link attribute but it contained no value.
Drawings1.xml:

We have added a fix for this. It should be in Our NuGet Develop Feed within a few days.

Out of curiosity, how did you add your image/create your workbook?
Microsoft365 Excel does not generate xml that way when I attempt to.

[robincodex]

That's because we only recently added support for Linked Images, before we did not check the "linked" property. Your file has a Link attribute but it contained no value. Drawings1.xml:

We have added a fix for this. It should be in Our NuGet Develop Feed within a few days.

Out of curiosity, how did you add your image/create your workbook? Microsoft365 Excel does not generate xml that way when I attempt to.

This file was exported from Tencent Cloud Documents, similar to Google Docs, so it seems I shouldn't have given feedback on this issue, it's an error caused by Cloud Documents not adhering to standards.

Thank you for resolving this; I apologize for any inconvenience caused.