This is a migrated thread and some comments may be shown as answers.

Lost openXML export options on upgrade

3 Answers 131 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Scott Buchanan
Top achievements
Rank 1
Scott Buchanan asked on 22 Nov 2017, 11:43 PM

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" />
      <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

 

 

3 Answers, 1 is accepted

Sort by
0
Katia
Telerik team
answered on 23 Nov 2017, 08:16 AM
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
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
0
Scott Buchanan
Top achievements
Rank 1
answered on 23 Nov 2017, 01:59 PM

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

0
Katia
Telerik team
answered on 24 Nov 2017, 01:02 PM
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
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Tags
General Discussions
Asked by
Scott Buchanan
Top achievements
Rank 1
Answers by
Katia
Telerik team
Scott Buchanan
Top achievements
Rank 1
Share this question
or