Issue around downloading Telerik.Windows.Documents.Spreadsheet.for.Net40 from nuget

5 posts, 0 answers
  1. Adi
    Adi avatar
    3 posts
    Member since:
    Jan 2016

    Posted 27 Sep 2018 Link to this post

    We recently upgraded Sitefinity 9.1 to Sitefinity 11.0.

    We process excel spreadsheets using "Telerik.Windows.Documents.Spreadsheet.Model" which references Telerik.Windows (2015.1.225.45) nuget package with .Net Framework 4.5

    Sitefinity 11 uses .Net Framework 4.7.1 and seems like "Telerik.Windows.Documents.Spreadsheet.for.Net40" is the replacement for "Telerik.Windows.Documents.Spreadsheet.Model"? Is this true? If so I'm trying to download ...for.Net40 from Telerik nuget and I get an following error-

     

    Unable to resolve dependency 'Telerik.Windows.Zip.for.Net40'.

    I could not find this from Telerik's nuget package. Am I heading in the right direction? Appreciate help in advance.

     

     

  2. Polya
    Admin
    Polya avatar
    267 posts

    Posted 01 Oct 2018 Link to this post

    Hi Adi,

    We ship our Sitefinity distributions with Telerik.Windows.Documents.Core and Telerik.Windows.Zip dlls, but not with Telerik.Windows.Documents.Spreadsheet dll. For that reason, after the upgrade, the referenced versions of the Core and Zip dlls are automatically changed to reflect the new Sitefinity version, but the Spreadsheed dll version stays unchanged.
    Telerik.Windows.Documents.Spreadsheet depends on Telerik.Windows.Documents.Core and Telerik.Windows.Zip, thus the three dlls must have the same version.
    That said, I suggest after the Sitefinity upgrade to, as you've said, install the nuget package Telerik.Windows.Documents.Spreadsheet.for.Net40 with version equal to the version of the changed Core and Zip dlls (2018.1.122, if I am not mistaken). That way all three dlls - Telerik.Windows.Documents.Core, Telerik.Windows.Zip and Telerik.Windows.Documents.Spreadsheet would be in the same version.
    Please give it a try and let us know whether this resolves the issue.

    Regards,
    Polya
    Progress Telerik

  3. Adi
    Adi avatar
    3 posts
    Member since:
    Jan 2016

    Posted 01 Oct 2018 in reply to Polya Link to this post

    Hey Polya,

    I was exactly trying to do the same thing as you said, like install same versions (2018.1.122) of Telerik.Windows.Documents.Core, Telerik,Windows.Zip and Telerik.Windows.Documents.Spreadsheet DLLs.

     

    As I indicated earlier, I got the .Core and .Zip versions downloaded but when I'm trying to download Telerik.Windows.Documents.Spreadsheet.For.Net40 from nuget, I get the following error-

    Unable to resolve dependency 'Telerik.Windows.Zip.for.Net40'.

    I'm attaching the screenshot of the nuget error console and also the nuget packages I'm trying to install for your reference.

    Thanks.

     

  4. Adi
    Adi avatar
    3 posts
    Member since:
    Jan 2016

    Posted 01 Oct 2018 in reply to Adi Link to this post

    This is the error I get when I run this code-

    var workbook = new Telerik.Windows.Documents.Spreadsheet.Model.WorkBook();

    Could not load type 'Telerik.Windows.Documents.Common.Model.Protection.ProtectionData' from assembly 'Telerik.Windows.Documents.Core, Version=2018.1.112.40, Culture=neutral, PublicKeyToken=5803cfa389c90ce7'.
       at Telerik.Windows.Documents.Spreadsheet.Model.Workbook..ctor()

     

    Nuget Packages installed in my project-

    <package id="Telerik.Windows" version="2015.1.225.45" targetFramework="net471" />
    <package id="Telerik.Windows.Documents.Core" version="2018.1.122.45" targetFramework="net471" />
    <package id="Telerik.Windows.Zip" version="2018.1.122.45" targetFramework="net471" />

  5. Polya
    Admin
    Polya avatar
    267 posts

    Posted 02 Oct 2018 Link to this post

    Hello Adi,

    Thank you for providing the additional information about the package sources and nuget package. We've investigated at our side and I think we've found the cause of the issue.
    From the provided screenshot, I see that you are using all Package sources to search for the Telerik.Windows.Documents.Spreadsheet.for.Net40 nuget package. I assume that the result you're seeing is from the Sitefinity package source and not the Telerik package source.
    The sitefinity nuget server contains only the Telerik.Windows.Documents.Spreadsheet.for.Net40 nuget package. However, it does not contain its dependent Telerik.Windows.Documents.Core.for.Net40 and Telerik.Windows.Zip.for.Net40 packages. All three of them are required for a successful installation, thus the error on installation.

    That said, in order to successfully install Telerik.Windows.Documents.Spreadsheet.for.Net40 please make sure you are installing it from the Telerik nuget server, which contains all three nuget packages.

    Could you give it a try and let me know whether this resolves the issue? Looking forward to your reply.

    Regards,
    Polya
    Progress Telerik

Back to Top