We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

Syncfusion.XlsIO.ExcelSheetProtection enum

Thread ID:

Created:

Updated:

Platform:

Replies:

94330 May 6,2010 02:19 PM May 7,2010 02:52 AM ASP.NET Web Forms (Classic) 1
loading
Tags: XlsIO
Nicholas Brassington
Asked On May 6, 2010 02:19 PM

Hello,

I was previously using version 6.3.1.8 of the Syncfusion.XlsIO and the enum ExcelSheetProtection.Default existed. In version 8.2.0.18 this constant does not exist. What can I replace this constant with in version 8.2.0.18 to create a similar permission set?

Thank you.

Nick

Lokesh R [Syncfusion]
Replied On May 7, 2010 02:52 AM

Hi Nick,

Thank you very much for using Syncfusion products.

As you have reported in your post. The equivalent permission set in 8.2.0.18 for the ExcelSheetProtection.DefaultProtect constant available in 6.3.1.8 is
ExcelSheetProtection.LockedCells | ExcelSheetProtection.UnLockedCells. Below, I have also added the code snippet for the same, could you please try the code snippet and let us know if this helps you.

[C#] Code Snippet:

ExcelEngine engine = new ExcelEngine();
IApplication app = engine.Excel;
IWorkbook workBook = app.Workbooks.Create(2);

//Equivalent permission set in 8.2.0.18 for the Defaultprotect option available in 6.3.1.8
workBook.Worksheets[0].Protect("Syncfusion", ExcelSheetProtection.LockedCells | ExcelSheetProtection.UnLockedCells);

workBook.SaveAs("Sample.xls");
workBook.Close();

Please, let us know if you have any queries.

Thanks,
Lokesh.

CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.

;