Excel copy/paste

Hot Topic

Converting Interop.Excel.Workbook to VSTO.Workbook
Parameterising ProjectType in VS2005 templates
How to convert an Icon object to ImageSource?
VS2005 SP1 to be used with VSTO2005 SE?
ListBox shows (Collection)
Will There Be An Outlook 12 Template?
Sandcastle December CTP - Wrong icons shown on member pages
How to pass arguments to Action programatically?
Visual Studio help example font
Parallel debugger : concurrent users

Visual Studio

How to find whether there is a blank page at the end of the document ?
msi - check office and PIAs version
How to create a Popup control that has the look of a callout window in Excel Autoshapes collection
Can CallbackChannel Serialize
integration of clearcase in vs2003 and vs2005 behaves differently
Bad request?
Setup project doesn't appear to fully setup add-in
RC1 broke my stuff
Readonly dependendy property
How to make custom BitmapEffect.

Excel copy/paste

I have developed a custom VSTO application that manipulates data in a database through an Excel interface. The User has a limited entry field (all other cells are set to Locked=true), but can expand it through a custom form interface that they can easily spawn.

The client's common use of the product is going to be copying and pasting data into my application from other excel spreadsheets. Copying works perfectly(with validation and error handling), except in one case, when the area of the object they want to paste extends into the Locked region of the spreadsheet.

I'm already handling the Worksheet.Change event, but upon trying to paste an invalid region, the event is never even thrown. In addition, the message given my the excel client is very nondescriptive as to WHY the user can't paste, just saying that the user is trying to modify a locked cell.

What I'm looking for (and I'm stumped as to where to find it) is some way to catch the invalid copy/paste event and show a custom message to the user. Is there some event I can handle, or some way to catch when excel has errors

Thanks in advance.



Answer this question

Excel copy/paste

  • Chimme

    My big issue is that it isn't throwing an error. If it was, I could handle it and throw a message to the user. The vast majority of my code is within try/catch blocks, I think the default excel functionality is handling it before it even goes to my code. Thanks for the advice with the macro though, I'll take a look at that and see if I can handle the paste event there.

  • airwalker2000

    Hi Andrew

    I think this is more of an Excel object model issue but am keen to know if an error is thrown that can be trapped within your code have you tried to wrapper the code in a Try/Catch block and see if an error is raised. If so this maybe then easy to handle and display a different error.

    Additionally you could look to handle the paste command in a macro on your worksheet and then do a check on the current location and then raise your own error and then fire the Selection.Paste(). Simply having a set of code or macro button to replace this functionality.

    Regards



  • Excel copy/paste
Answer this question