Cell based protection - is this implemented?


#1

Hi,

We have created a spreadsheet to send to clients. We have protection on our worksheet. All columns are locked, except for 3. These 3 columns are designed for the client to enter data into and send the spreadsheet back to us. All other columns have data in them to aid the client in populating the required columns.

When we insert our datatable, our protection gets overwritten. The entire worksheet is locked and the 3 columns can not have data entered into them.

Below is our code. If you require the designer file, let me know.

------------------------------------------------------------------------------

//
Excel excel = new Excel();
excel.Open(templatePath);

//
Worksheet sheet = excel.Worksheets[0];
sheet.Cells.ImportDataTable(inputTable, false, 1, 0);

//
string outputPath = @“E:” + DateTime.Now.ToString(“yyMMdd”) + “_Daily_Due_Jobs.xls”;

//
excel.Save(outputPath, FileFormatType.ExcelXP);


------------------------------------------------------------------------------

Thanks
Brendan


#2

Hi Brendan,

Yes. Please email me your designer file. That will help me to understand your need and investigate this issue.

Thanks.


#3

Hi Laurence,

I have emailed you our designer file. Can you please indicate if you have received this, and if so, what the progress of this issue is? The resolution of this issue will determine whether we purchase your component, or go with another provider.

Cheers
Brendan


#4

Hi Brendan,

I will check it ASAP. And I think I could solve it within two days. Thanks for your patience.


#5

Hi Brendan,

Have you tried our latest hotfix at http://www.aspose.com/Products/Aspose.Excel/Fixes/Aspose.Excel.zip? I have tested your file and haven’t found the problem you described.

If the problem still exists in your side, could you email me the worksheet protection password? That will help me to investigate your setting in the designer file.

Thanks.