Lost openXML export options on upgrade

4 posts, 0 answers
  1. Scott Buchanan
    Scott Buchanan avatar
    42 posts
    Member since:
    Dec 2008

    Posted 22 Nov Link to this post

    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

     

     

  2. Katia
    Admin
    Katia avatar
    615 posts

    Posted 23 Nov Link to this post

    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
  3. Scott Buchanan
    Scott Buchanan avatar
    42 posts
    Member since:
    Dec 2008

    Posted 23 Nov in reply to Katia Link to this post

    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

  4. Katia
    Admin
    Katia avatar
    615 posts

    Posted 24 Nov Link to this post

    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
Back to Top