Issue in DocumentFormat.OpenXML SDK with sheet protection

[ghost]

Hi All, Im trying to export an excel,using the openxml sdk, but when I protect the sheet and try to make the cells or rows editable which was not created programmatically..

To fix this we found solution, that there is a workaround by removing the sheet protection and adding the datavalidation for the readonly fields.. using the Datavalidation class, but here also a problem, because when I copy paste or drag and drop the rows from the existing validation it copies the old validations as well, which I dont want.. Can someone explain or help on this issue.

Is there any way to correct or fix this problem in the library.

for the issues:

1. Sheet protection for the cell range or only for the rows which I create programmatically.
2. Option to allow trigger an event when I copy paste the rows.