Try taking it up with the OpenXML team first. I think this should be handled closer to the source. Tag the issue here, please.

It's already been logged with them. Please see dotnet/Open-XML-SDK#38

Wow thanks for linking and all :). Great work!

OpenXML v2.12.0+ introduced a workaround using OpenSettings.RelationshipErrorRewriter with pull request Add a relationship rewriter to help sanitize malformed URIs. Are there any plans to add/implement this workaround to ClosedXML?

I have limited capacity, but we welcome pull requests.

I had an issue like this and it turns out upgrading OpenXML to 2.12.x and write the fix ourselves is very easy. It's just a couple of LOCs to rewrite the input stream.

            var settings = new OpenSettings
            {
                RelationshipErrorHandlerFactory = package =>
                {
                    return new UriRelationShipErrorHandler();
                },
            };


            var outputStream = new MemoryStream();
            stream.CopyTo(outputStream);
            stream.Position = 0;

            using (var doc = SpreadsheetDocument.Open(outputStream, true, settings))
            {
                doc.Save();
            }
            outputStream.Position = 0;
            // At this point, outputStream is ready for use by ClosedXML
            using (var workbook = new XLWorkbook(outStream))
            

@igitur Could we just accept OpenSettings as a constructor argument of ClosedXML's XLWorkbook? Does that makes solving future similar problems easier?

@hieuxlu See #1619

I had an issue like this and it turns out upgrading OpenXML to 2.12.x and write the fix ourselves is very easy. It's just a couple of LOCs to rewrite the input stream.

            var settings = new OpenSettings
            {
                RelationshipErrorHandlerFactory = package =>
                {
                    return new UriRelationShipErrorHandler();
                },
            };


            var outputStream = new MemoryStream();
            stream.CopyTo(outputStream);
            stream.Position = 0;

            using (var doc = SpreadsheetDocument.Open(outputStream, true, settings))
            {
                doc.Save();
            }
            outputStream.Position = 0;
            // At this point, outputStream is ready for use by ClosedXML
            using (var workbook = new XLWorkbook(outStream))
            

@igitur Could we just accept OpenSettings as a constructor argument of ClosedXML's XLWorkbook? Does that makes solving future similar problems easier?

@hieuxlu ,
workbook.Save() is not saving any changes performed in the worksheet in the ClosedXML.
When I used "outputStream is ready for use by ClosedXML" code-shared by you.
WorkBook.SaveAs(filename) is working however I want to achieve the modifications in the same workbook without creating the new workbook.

Hello @igitur, @hieuxlu, and @santerinogelainen, I am also facing the same exception though I am using version 2.13.0 of DocumentFormat.OpenXml Package. Can you please tell me the ETA when this issue will be resolved in the package?

Hello @TrueBytes, Can you please help me with what you are passing and executing in the "UriRelationShipErrorHandler()" method.

Hello @RajdeepRay0411 , following @hieuxlu tip you need to create a class that overrides Rewrite:

using DocumentFormat.OpenXml.Packaging;
using System;

public class UriRelationshipErrorHandler : RelationshipErrorHandler
{
    public override string Rewrite(Uri partUri, string id, string uri)
    {
        return "http://link-invalido";
    }
}

Example of use:

        var openSettings = new OpenSettings()
        {
            RelationshipErrorHandlerFactory = package =>
            {
                return new UriRelationshipErrorHandler();
            }
        };

        using (var outputStream = File.Open(excelPath, FileMode.OpenOrCreate, FileAccess.ReadWrite, FileShare.ReadWrite))
        {
            using (var xls = SpreadsheetDocument.Open(outputStream, true, openSettings))
            {
                xls.Save();
            }

            var workbook = new XLWorkbook(outputStream);
           .......

        }

Refereces:

https://stackoverflow.com/questions/29970814/openxml-excel-throw-error-in-any-word-after-mail-address