Hi
Is it possible to restrict xamSpreadSheet to paste only values from Clipboard, but not format and validation rules..
The case is next: There is a sheet in workbook with Cell formats and datavalidation rules. When a cell is copied from MS Excel and pasted in xamSpreadsheet, format and datavalidation rule are changed/removed.
Thank you in advance.
Hello isimeon,
Thank you for your post. I was researching your inquire and I can suggest you to handle the DataObject’s Pasting attached event and change the event arguments object's apply format to “Text”. I am attaching a sample application which demonstrates how to do it.
Please do not hesitate to let me know if you have any further questions on this matter.
Sincerely,
Radko Kolev
Infragistics Inc.
www.infragistics.com/support
Hi Radko,
This is exactly what I wanted.
As is written in the documentation, data validation rules are not fired when paste a value in a cell (same as MS Excel). Is it posible to handle cell value change when pasting and fire data validation rule programatically? If data validation rule is violated I want to cancel pasting (or execute Undo).
Best Regards,
Ivan