but couldnt get a reliable repro. After reworking the application to depend less upon the spreadsheet control as I was encountering a number of bugs since starting using it but have got to a stage where I reliably repro this error using the spreadsheet control.
System.Reflection.TargetInvocationException
HResult=0x80131604
Message=Exception has been thrown by the target of an invocation.
Source=mscorlib
StackTrace:
at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
at System.Delegate.DynamicInvokeImpl(Object[] args)
at System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry tme)
at System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj)
at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme)
at System.Windows.Forms.Control.InvokeMarshaledCallbacks()
at System.Windows.Forms.Control.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 CheckinManifest.My.MyApplication.Main(String[] Args) in :line 81
Inner Exception 1:
ArgumentException: Item has already been added. Key in dictionary: '!11!' Key being added: '!11!'
INNER EXCEPTION DETAILS
InnerException {"Item has already been added. Key in dictionary: '!11!' Key being added: '!11!'"} System.Exception {System.ArgumentException}
at System.Collections.Hashtable.Insert(Object key, Object nvalue, Boolean add)
at System.Collections.Hashtable.Add(Object key, Object value)
at Syncfusion.Windows.Forms.CellGrid.FormulaEngine.RegisterGridAsSheet(String refName, ICalcData grid, Int32 sheetFamilyID)
at Syncfusion.Windows.Forms.Spreadsheet.Converter.SpreadsheetImportExtension.ImportExcelToGrid(Spreadsheet spreadsheet, IWorkbook workbook, Int32 SheetFamilyId)
at Syncfusion.Windows.Forms.Spreadsheet.Spreadsheet.LoadTabItems()
at Syncfusion.Windows.Forms.Spreadsheet.Spreadsheet.OpenFile(Stream file)
at Syncfusion.Windows.Forms.Spreadsheet.Spreadsheet.<>c__DisplayClass49.<Open>b__44()
I will PM the project source and a video repro.