Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
340
XamSpreadsheet Paste values only
posted

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.

Parents
No Data
Reply
  • 2151
    Verified Answer
    Offline posted

    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

    XamSpreadsheet Pasting Values Only.zip
Children