Telerik Nuget is Missing Telerik.Web.Spreadsheet Framework

1 Answer 232 Views
PdfViewer Spreadsheet
Caleb
Top achievements
Rank 1
Caleb asked on 10 Oct 2022, 06:00 PM

We switched from using your DLLs directly to pulling from Nuget.

We were originally targeting the .NET Framework version of your libraries and planned to continue to do so.

However in the conversion it was realized that Telerik.Web.Spreadsheet is only available as Standard in your Nuget. Therefore due to this ONE missing library I had to convert everything to Standard.

This was fine until we realized that Standard isn't capable of embedding subset fonts into PDFs like Framework, leading to larger files.

I attempted to do a mix of the two and failed but I'd really rather not do that anyway.

Could you please properly update your Nuget to include the Framework version of Telerik.Web.Spreadsheet? I know it exists because I used it before moving to Nuget.

Thank you

Attila Antal
Telerik team
commented on 13 Oct 2022, 09:33 AM

Hi Caleb,

Telerik.Web.Spreadsheet is a .NET Framework library and it is required by RadSpreadsheet (ASP.NET WebForms Control) to work.

We have the same assembly for the Telerik UI for ASP.NET AJAX Installers or in the NuGet package repository.

 

Are you trying to use the RadSpreadsheet component and you are unable to or are you trying to create/manipulate documents?

For manipulating documents, there are separate .NET libraries called the Telerik Document Processing Libraries. One of its libraries is called the RadSpreadProcessing library.

Can you please clarify your intention and the issue that you are experiencing?

 

Caleb
Top achievements
Rank 1
commented on 13 Oct 2022, 03:30 PM

I am trying to do both. But the issue comes with using RadSpreadsheet.

On this page: https://docs.telerik.com/devtools/aspnet-ajax/controls/spreadsheet/getting-started

In the Assembly section it says:

"You can access the needed assemblies from the AdditionalLibraries folder in the Telerik® UI for ASP.NET AJAX installation (automated and manual) and from the internal builds archive. They support .NET 4 and .NET 4.5, so depending on the target framework of your project, you need to take the assemblies from the Bin40 or the Bin45 folder respectively."

However this is not true for Nuget installation. The correct Telerik.Web.Spreadsheet.dll is missing from Nuget. This dll is NOT included in Telerik.UI.for.AspNet.Ajax.Net45.

I have all of the libraries on that page except Telerik.Web.Spreadsheet. My code for creating a Telerik.Web.Spreadsheet.Workbook of course throws a compilation error stating that I need the Telerik.Web.Spreadsheet library. However if you go to the Telerik Nuget right now and lookup Telerik.Web.Spreadsheet you will only find the Standard version. If I attempt to install that then it wants to install all of its dependencies which are the various Telerik.Documents... assemblies. NOT Telerik.Windows.Documents... as stated in the article. Because Telerik.Documents is the Standard version of Telerik.Windows.Documents.  And if you were to install the available Telerik.Web.Spreadsheet you will see that under lib there is only 1 folder: "netstandard2.0". Unlike some libraries where there are many folders for standard, framework, core, etc.

Unless there is some other Telerik package hidden somewhere which includes Framework Telerik.Web.Spreadsheet?

 

1 Answer, 1 is accepted

Sort by
0
Attila Antal
Telerik team
answered on 18 Oct 2022, 10:58 AM | edited on 18 Oct 2022, 11:54 AM

Hi Caleb,

Thanks for clarifying the issue, now I see where the problem is.

The Telerik.Web.Spreadsheet.dll was added to NuGet with recent versions of Telerik. If you do not see that, you are likely using an old version. In that case, you would need to reference this assembly manually.

 

I have tested the current version (2022.3.913) and the assembly is available, see the screenshot below:

 

UPDATE

The Telerik.Web.Spreadsheet.dll is part of the Kendo suite, and since the Telerik RadSpreadsheet for ASP.NET AJAX is actually a wrapper for the Kendo widget, we need to include the assembly in the Telerik UI for ASP.NET AJAX suite. 

Until recently we have shipped the Assembly in the AdditionalLibraries folder. Current versions of NuGet packages now include it and will be available as per the screenshot above.

 

You are correct that the Telerik.Web.Spreadsheet.dll is a .NET Standard 2.0 but is compatible with both .NET Core and .NET 4.6.1+ and this shall be used.

For more details, you can check out the Differences Between .NET Framework, .NET Core, and .NET Standard article.


Regards,
Attila Antal
Progress Telerik

Love the Telerik and Kendo UI products and believe more people should try them? Invite a fellow developer to become a Progress customer and each of you can get a $50 Amazon gift voucher.

Caleb
Top achievements
Rank 1
commented on 21 Oct 2022, 05:14 PM | edited

This is not true.

The Standard version of Telerik.Web.Spreadsheet (on Nuget, the one you mention) depends on namespace Telerik.Documents...

The Framework version of Telerik.Web.Spreadsheet (not on Nuget) depends on namespace Telerik.Windows.Documents...

IF you try to use Standard Telerik.Web.Spreadsheet with Telerik.Windows.Documents... it will not compile.

I've decided to stop fooling with this and just include the Framework Telerik.Web.Spreadsheet.dll in my project files for reference to "solve" this problem. 

Thanks

Update

In further testing it looks like the Standard actually ends up with a smaller size anyway so I'll keep that. I think the only way I'll get them even smaller is a different library.

Attila Antal
Telerik team
commented on 24 Oct 2022, 02:19 PM

Caleb, 

There's a single assembly file "Telerik.Web.Spreadsheet.dll" and it is used across multiple suites (Telerik UI for ASP.NET AJAX, Telerik UI for .NET MVC, and Telerik  UI for .NET Core).

The namespace "Telerik.Documents.Common.Model" will only be set as a dependency if the Telerik.Web.Spreadsheet.dll is used in an application that targets the .NET Standard (2.0).

For applications targeting the .NET Framework 4.0 and above, the "Telerik.Windows.Documents.Spreadsheet.Theming" namespace is used.

I hope this will clarify the confusion.

Chris
Top achievements
Rank 1
commented on 04 Mar 2024, 07:55 PM

The problem is the build numbers do not match.  It is true to this day.  

 

Telerik.Windows.Documents.Speadsheet on nuget right now is 2024.1.124.20.

Telerik.UI.for.AspNet.Ajax.Net45 2024.1.131 requires 2024.1.124.40

 

From the looks of it, you have a problem where your Telerik.UI.for.AspNet.Ajax.Net45 is building a newer version of Telerik.Windows.Documents.Speadsheet than what you deploy to nuget.

 

This acts this way for all of the builds from what I could tell.  Please update your build and deploy process so that all your projects reference assemblies that are actually accessible.

Attila Antal
Telerik team
commented on 05 Mar 2024, 11:01 AM

Hi Chris,

The reason you can see a difference in the version numbers is that Telerik.Web.Spreadsheet is a dependency that needs to be released before it can be incorporated into other projects. For instance, in the Telerik.Web.UI (Telerik.UI.for.AspNet.Ajax.Net45) assemblies. So they may release this assembly a few days prior. Hence the difference between Telerik.Web.Spreadsheet 2024.1.124 (January 24th) and Telerik UI for ASP.NET AJAX 2024.1.131 (January 31).

This, however, is not the cause of the problem that was reported in this forum post. We have discussed the issue between the Teams, and we found that the NuGet package for Telerik.Web.Spreadsheet only includes the Standard version (.net20) which will not work with the Telerik UI for ASP.NET AJAX (.NET Framework).

The issue was logged and we're waiting for the respective team to release a .net40 version of the Telerik.Web.Spreadsheet assembly in the NuGet.

Until this issue is fixed, the Telerik.Web.Spreadsheet (.net40) can be extracted from the ZIP content or by installing the Assemblies using the MSI installers. Instructions to find the Spreadsheet library: https://docs.telerik.com/devtools/aspnet-ajax/getting-started/installation/included-assemblies#spreadsheet-library

I hope this will clarify the confusion.

Chris
Top achievements
Rank 1
commented on 05 Mar 2024, 02:34 PM | edited

The issue is not that it is .Net Standard, as you can use .Net Standard with Framework products.  The issue is what I said, and the reason why Caleb was having issues.  Your Web framework is looking for a newer version than what you have for your Documents framework.  I have already gotten around the issue by installing the newer DLLs for Documents manually, and yes, I am using the .Net Standard version in my Framework project. Please address my concern with your developement team so that I may use Nuget as intended and remove my dependency of manually adding and updating DLLs in my project
Tags
PdfViewer Spreadsheet
Asked by
Caleb
Top achievements
Rank 1
Answers by
Attila Antal
Telerik team
Share this question
or