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

error trying to protect the worksheet

5 Answers 91 Views
Spreadsheet
This is a migrated thread and some comments may be shown as answers.
Valery
Top achievements
Rank 1
Veteran
Valery asked on 22 Jan 2019, 05:46 AM

I use RadSpreadSheet to view xlsx stored in the database (so they need to be protected from editing). But for some worksheet, this leads to the following error:

System.ArgumentException: algorithmName
в Telerik.Windows.Documents.Utilities.Guard.ThrowExceptionIfNullOrEmpty(String param, String paramName)
в Telerik.Windows.Documents.Common.Model.Protection.ProtectionHelperBase.GenerateHashBase64(String password, String salt, String algorithmName, Int32 spinCount)
в Telerik.Windows.Documents.Spreadsheet.Model.Protection.ProtectionData.EnforceProtection(String input)
в Telerik.Windows.Documents.Spreadsheet.Model.Sheet.ProtectSheet(String password)

I cannot submit the file, as it contains confidential information. Perhaps the reason is that the worksheet contains links to other files that are not on this computer.

 

Here's a line from my program that causes an error:

 

tem.Protect("abc", WorksheetProtectionOptions.Default);

 

 

 

 

5 Answers, 1 is accepted

Sort by
0
Anna
Telerik team
answered on 24 Jan 2019, 10:54 AM
Hello Valery,

Would it be convenient for you to send us a sample file for which this error happens? Although it might seem pretty obvious from the stack trace there are some peculiarities we would like to be certain of before we can be sure what the core cause is. Thank you in advance.

Regards,
Anna
Progress Telerik
Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.
0
Valery
Top achievements
Rank 1
Veteran
answered on 24 Jan 2019, 11:31 AM
Unfortunately I can not send the file, because it contains our customer’s confidential information. 
0
Anna
Telerik team
answered on 25 Jan 2019, 11:06 AM
Hello Valery,

I see you are not using the latest versions of our DLLs, is that correct? Since we recently fixed an exception related to the algorithmName parameter, can you please try using the latest version?

If the exception persists, would it be OK if you send us one of those files, but with its content removed? It is not necessary for the purposes of this particular exception. I completely understand your concern, but I assure you we treat the files of our customers with strict confidentiality.

Regards,
Anna
Progress Telerik
Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.
0
Valery
Top achievements
Rank 1
Veteran
answered on 25 Jan 2019, 11:23 AM

We are using version 2018.3.1016.40. We are planning to switch to the latest version next month. As soon as we switch to the latest version, I will immediately tell you the results

 

0
Valery
Top achievements
Rank 1
Veteran
answered on 04 Feb 2019, 10:40 AM
In version 2019.1.117.40, everything works. thank
Tags
Spreadsheet
Asked by
Valery
Top achievements
Rank 1
Veteran
Answers by
Anna
Telerik team
Valery
Top achievements
Rank 1
Veteran
Share this question
or