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
Hello Ivan,
Currently there is no event raised after a cell value is updated as a result of clipboard-paste operation. As a workaround you may attach an event handler to the "CommandExecuted" event and check for the “Paste” command. Regarding the manual data validation execution I may suggest you to enumerate over the current selection’s cells and invoke “ValidateCellValue” on each one.
I am attaching a new sample demonstrating this.
As all your requested functionalities were not available “out of the box” I suggest you to submit a product idea.
You can suggest new Product Ideas for future versions (or vote for existing ones) at http://ideas.infragistics.com.
Steps to create your idea:
1. Log into the Infragistics Product Ideas site at http://ideas.infragistics.com (creating a new login if needed).
2. Navigate to the product / platform channel of your choice (e.g. WPF, Windows Forms, ASP.NET, HTML5 / Ignite UI, iOS / NucliOS, etc.)
3. Add your product idea and be sure to be specific and provide as much detail as possible. Explain the context in which a feature would be used, why it is needed, why it can’t be accomplished today, and who would benefit from it. You can even add screenshots to build a stronger case. Remember that for your suggestion to be successful, you need other members of the community to vote for it. Be convincing!
The benefits of submitting the product idea yourself include:
• Direct communication with our product management team regarding your product idea.
• Notifications whenever new information regarding your idea becomes available.
Additional benefits of the Product Idea system include:
• Ability to vote on your favorite product ideas to let us know which ones are the most important to you. You will have ten votes for this and can change which ideas you are voting for at any time.
• Allow you to shape the future of our products by requesting new controls and products altogether.
• You and other developers can discuss existing product ideas with members of our Product Management team.
The product ideas site allows you to track the progress of your ideas at any time, see how many votes it got, read comments from other developers in the community, and see if someone from the product team has additional questions for you.
Thank you for contacting Infragistics.
Thak you for the sample project. It will be very helpfull.
Best regards,
Thank you for your feedback.
I am very glad that you have manage to resolve your issue.
If you require any further assistance, please do not hesitate to ask.