lock cell but allow column width and height to be adjustable.

[Craig Bart]

lock cell but allow column width and height to be adjustable. can you do this? thanks.

[Sarathi D]

Hi,

Thank you for posting your query to us.

The row and column height of a locked cell can be adjusted using the rowheight and column width properties.

I have created a sample based on this and it is available in the following link.

http://websamples.syncfusion.com/samples/XlsIO.Windows/F67525/main.htm

Please run the sample and let me know if this satisfies your requirement.

Regards,
Sarathi

[Craig Bart]

What about from the excel sheet? After it's locked can i adjust row and height from excel? That's what i need to do.

[Sarathi D]

Hi,

With the current implementation it is not possible to adjust the row and height of a locked cell.

sorry for the inconvenience.

Please let me know if you have any further queries.

Regards,
Sarathi

[Anonymous]

If I understood you correctly, you need to create worksheet that is protected but users can change row height and column widht using MS Excel. This can be done using following code
IWorksheet sheet = book.Worksheets[ 0 ];
ExcelSheetProtection options = ExcelSheetProtection.FormattingColumns | ExcelSheetProtection.FormattingRows | ExcelSheetProtection.UnLockedCells | ExcelSheetProtection.LockedCells;
sheet.Protect( "test", options );

[Sarathi D]

Hi ,

Sorry for the inconvenience caused.

Your code snippet is working fine for resizing the locked cells using Essential XlsIO. Please do let me know if you have any other technical questions or I can be of any other assistance. I will be glad to assist you.

Thank you for your continued interest in Syncfusion Products.

Best regards,
Sarathi.

[Craig Bart]

Thank you ami!!!

[DIGVIJAY KUMAR]

Yes