Data loaded into 2 spreadsheets, Copy cells from one and paste into the other.
1st copy/paste succeeds without a problem.
2nd copy/paste results in unhandled exception.
It is not the data as I if reverse the data i'm copying in 1st action with the data in the 2nd action - the 1st will copy and the 2nd will still fail.
System.ArgumentException
HResult=0x80070057
Message=Sheet Name is already existed in workbook
Source=Syncfusion.XlsIO.Base
StackTrace:
at Syncfusion.XlsIO.Implementation.Collections.WorkbookObjectsCollection.Add(ISerializableNamedObject namedObject)
at Syncfusion.XlsIO.Implementation.Collections.WorksheetsCollection.Add(IWorksheet sheet)
at Syncfusion.XlsIO.Implementation.Collections.WorksheetsCollection.Create(String name)
at Syncfusion.Windows.Forms.Spreadsheet.SpreadsheetCopyPaste.Paste(GridRangeInfoList range, PasteOptions e)
at Syncfusion.Windows.Forms.Spreadsheet.SpreadsheetCopyPaste.Paste(GridRangeInfoList range)
at Syncfusion.Windows.Forms.Spreadsheet.SpreadsheetCopyPaste.Paste()
at Syncfusion.Windows.Forms.CellGrid.SelectionController.HandleKeyDown(KeyEventArgs args)
at Syncfusion.Windows.Forms.Spreadsheet.SpreadsheetGrid.ProcessKeyEventArgs(Message& m)
at System.Windows.Forms.Control.ProcessKeyMessage(Message& m)
at System.Windows.Forms.Control.WmKeyChar(Message& m)
at System.Windows.Forms.Control.WndProc(Message& m)
at Syncfusion.Windows.Forms.ScrollControl.WndProc(Message& msg)
at Syncfusion.Windows.Forms.Spreadsheet.SpreadsheetGrid.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
at Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase.OnRun()
at Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase.DoApplicationModel()
at Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase.Run(String[] commandLine)
at ExcelDisplay.My.MyApplication.Main(String[] Args) in :line 81