How to prevent copy paste values+formula

Aspose.Cells Product Family
1

Hi,

We want to prevent the user from copy paste values with formulas in the worksheet .Is there any method in ASPOSE that we can use to implement this?

Our application environment is:
Visual Studio 2010,

Server: Windows 2008

For Example : We have set a formula on Cell A1, B1 in worksheet1. If we copy values from A1 AND B1 and try to paste in Worksheet 2 then it should not allow.

2

Hi,


I think you may make use of Protection options/ settings provided by Aspose.Cells APIs. For example, you may protect your desired columns, rows or even cells/range in the sheet for your requirements, or even you may protect the whole sheet accordingly. Please see the topic for your complete reference:
http://www.aspose.com/docs/display/cellsnet/Protecting+Worksheets
http://www.aspose.com/docs/display/cellsnet/Advanced+Protection+Settings+since+Excel+XP

Also, protecting worksheets will still allow users to copy/paste values in the cells (the users can right click on the cell and use Copy option in the context menu of MS Excel etc.). For copy/paste formulas, the users cannot do that for the protected cells though.

Thank you.

3

Hi Amjad Sahiv,

I have tried unsuccessfully with the code as per the given link.

After the template is generated, I was able to write to the cells/column which was marked as locked.

Do you have any other way that I can mark the complete column/range as locked/read only.

The all I am trying to do is to make one column or selected range od cells read only for the users. Users should not be able to type values in those cells.

Any help please?

Regards,

Samir Ray

4
Hi,

cgiituk:

I have tried unsuccessfully with the code as per the given link.

After the template is generated, I was able to write to the cells/column which was marked as locked.

.........

The all I am trying to do is to make one column or selected range od cells read only for the users. Users should not be able to type values in those cells.


Could you provide us your sample runnable code or simple console application (you may zip it prior attaching here) with your template Excel file (if you have any), we will check your issue soon.


Thank you.