Lost openXML export options on upgrade

[Scott Buchanan]

I upgraded from Telerik Reporting R3 2017 (version 11.2.17.913) to Telerik Reporting R3 2017 SP1 (version 11.2.17.1025)

The export options for Excel and Word are no longer present (but were available before the upgrade.

My project has references to both DocumentFormat.OpenXml v2.5.5631.0 and Telerik.Reporting.OpenXmlRendering v11.2.17.1025, both have CopyLocal = true

My web config has the following sections

<Telerik.Reporting>
  <assemblyReferences>
    <add name="ComplianceRisk.Data" />
  </assemblyReferences>
  <Extensions>
    <Render>
      <Extension name="IMAGE" visible="false" />
      <Extension name="MHTML" visible="false" />
      <Extension name="PPTX" visible="false" />
      <Extension name="RTF" visible="false" />
      <Extension name="XLS" visible="false" />
      <Extension name="XPS" visible="false" />
      <!--http://www.telerik.com/support/kb/reporting/details/outofmemoryexception-on-exporting-or-printing-telerik-report-from-azure-websites -->
      <Extension name="DOCX">
        <Parameters>
          <Parameter name="UseMetafile" value="false" />
        </Parameters>
      </Extension>
      <Extension name="XLSX">
        <Parameters>
          <Parameter name="UseMetafile" value="false" />
        </Parameters>
      </Extension>
    </Render>
  </Extensions>
</Telerik.Reporting>

 

<dependentAssembly>
  <assemblyIdentity name="DocumentFormat.OpenXml" publicKeyToken="31bf3856ad364e35" culture="neutral" />
  <bindingRedirect oldVersion="2.0.5022.0" newVersion="2.5.5631.0" />
</dependentAssembly>

 

I don't see anything in the release notes, so wondering what I might need to do to get this working again...

Best,
Scott

 

 

[Katia]

Hello Scott,

DocumentFormat.OpenXml NuGet package changed the assembly public key token in version 2.7.1. Thus to add support for the newer and older DocumentFormat.OpenXml we are now providing two Telerik.Reporting.OpenXmlRendering assemblies options:

Telerik.Reporting.OpenXmlRendering.dll (11.2.17.1025) supports DocumentFormat.OpenXml.dll 2.0.5022.0 and 2.5.5631.0
Telerik.Reporting.OpenXmlRendering.2.7.2.dll (11.2.17.1025) supports DocumentFormat.OpenXml.dll 2.7.2.0 and newer

For more details check Open XML SDK for Microsoft Office help article.

Make sure the correct combination of assemblies are used in your project. Both versions can be found in product installation folder: [installation folder]\Progress\Telerik Reporting R3 2017\Bin\OpenXmlRendering.

In case the issue persists send us the problematic project in a support ticket so we can check its settings locally.


Regards,
Katia
Progress Telerik

[Scott Buchanan]

Katia,

That is very good information, and when I update DocumentFormat.OpenXml.dll to version 2.7.2 I will keep this in mind.

Meanwhile, I am using DocumentFormat.OpenXml.dll version 2.5.5631.0, which the article says should be supported by Telerik.Reporting.OpenXmlRendering.dll, which is the DLL my project references.

Any other ideas as to why I might encounter this issue when upgrading Telerik Reporting from version 11.2.17.913 to 11.2.17.1025?

 

Best,

Scott

[Katia]

Hello Scott,

It was an issue in version 11.2.17.1025 with the rendering engine loading inappropriate Telerik.Reporting.OpenXmlRendering assembly when referencing DocumentFormat.OpenXml 2.5.5631.0.
It was fixed in our latest internal build - download link.

You can find release notes for the latest internal build here.


Regards,
Katia
Progress Telerik