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

[Aditya]

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.

 

 

[Polya]

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

[Aditya]

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.

 

[Aditya]

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

[Polya]

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