We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Sheets copy

Thread ID:

Created:

Updated:

Platform:

Replies:

34541 Sep 12,2005 03:18 PM UTC Sep 14,2005 10:38 AM UTC WinForms 3
loading
Tags: XlsIO
Administrator [Syncfusion]
Asked On September 12, 2005 03:18 PM UTC

I tried to copy sheets from one workbook to another. In simple code copy process works perfectly, but in my code ExcelRW function throws next Exception: "A first chance exception of type ''System.NullReferenceException'' occurred in syncfusion.excelrw.base.dll Additional information: Object reference not set to an instance of an object." Here is stack trace: syncfusion.excelrw.base.dll!Syncfusion.ExcelRW.Implementation.WorksheetImpl.UpdateIndexes(System.Collections.ICollection collection = {System.Collections.Hashtable.ValueCollection}, Syncfusion.ExcelRW.Implementation.WorksheetImpl sourceSheet = {Syncfusion.ExcelRW.Implementation.WorksheetImpl}, System.Collections.Hashtable hashStyleNames = {Count=13}) + 0x173 bytes syncfusion.excelrw.base.dll!Syncfusion.ExcelRW.Implementation.WorksheetImpl.CopyRowHeight(Syncfusion.ExcelRW.Implementation.WorksheetImpl sourceSheet = {Syncfusion.ExcelRW.Implementation.WorksheetImpl}, System.Collections.Hashtable hashStyleNames = {Count=13}) + 0x73 bytes syncfusion.excelrw.base.dll!Syncfusion.ExcelRW.Implementation.WorksheetImpl.CopyFrom(Syncfusion.ExcelRW.Implementation.WorksheetImpl worksheet = {Syncfusion.ExcelRW.Implementation.WorksheetImpl}, System.Collections.Hashtable hashStyleNames = {Count=13}, System.Collections.Hashtable hashWorksheetNames = , Syncfusion.ExcelRW.ExcelWorksheetCopyFlags flags = CopyWithoutNames) + 0x5f bytes syncfusion.excelrw.base.dll!Syncfusion.ExcelRW.Implementation.Collections.WorksheetsCollection.AddCopy(Syncfusion.ExcelRW.IWorksheets worksheets = {Syncfusion.ExcelRW.Implementation.Collections.WorksheetsCollection}) + 0x23b bytes >My Cool Functions Any ideas?

Administrator [Syncfusion]
Replied On September 13, 2005 08:56 AM UTC

Hi Shwarzenegger, I would appreciate it, if you could send the spreadsheet with the worksheet you are trying to copy. It will help us to investigate and give exact solution. If you wish to maintain the confidentiality of your spreadsheet, please create a Direct-Trac incident in this regard and mention the link to this forum post. Best Regards, Seetha >I tried to copy sheets from one workbook to another. In simple code copy process works perfectly, but in my code ExcelRW function throws next Exception: > >"A first chance exception of type ''System.NullReferenceException'' occurred in syncfusion.excelrw.base.dll > >Additional information: Object reference not set to an instance of an object." > >Here is stack trace: > >syncfusion.excelrw.base.dll!Syncfusion.ExcelRW.Implementation.WorksheetImpl.UpdateIndexes(System.Collections.ICollection collection = {System.Collections.Hashtable.ValueCollection}, Syncfusion.ExcelRW.Implementation.WorksheetImpl sourceSheet = {Syncfusion.ExcelRW.Implementation.WorksheetImpl}, System.Collections.Hashtable hashStyleNames = {Count=13}) + 0x173 bytes > >syncfusion.excelrw.base.dll!Syncfusion.ExcelRW.Implementation.WorksheetImpl.CopyRowHeight(Syncfusion.ExcelRW.Implementation.WorksheetImpl sourceSheet = {Syncfusion.ExcelRW.Implementation.WorksheetImpl}, System.Collections.Hashtable hashStyleNames = {Count=13}) + 0x73 bytes > >syncfusion.excelrw.base.dll!Syncfusion.ExcelRW.Implementation.WorksheetImpl.CopyFrom(Syncfusion.ExcelRW.Implementation.WorksheetImpl worksheet = {Syncfusion.ExcelRW.Implementation.WorksheetImpl}, System.Collections.Hashtable hashStyleNames = {Count=13}, System.Collections.Hashtable hashWorksheetNames = , Syncfusion.ExcelRW.ExcelWorksheetCopyFlags flags = CopyWithoutNames) + 0x5f bytes > syncfusion.excelrw.base.dll!Syncfusion.ExcelRW.Implementation.Collections.WorksheetsCollection.AddCopy(Syncfusion.ExcelRW.IWorksheets worksheets = {Syncfusion.ExcelRW.Implementation.Collections.WorksheetsCollection}) + 0x23b bytes > >>My Cool Functions > >Any ideas?

Administrator [Syncfusion]
Replied On September 14, 2005 04:58 AM UTC

Hi Seetha, I put the zip file of simple project that must demonstrate the problem. This code shows the same problems that appears in my big project. The stack trace is the same. ExcelRWProblems_9731.zip

Administrator [Syncfusion]
Replied On September 14, 2005 10:38 AM UTC

Hi Shwarzenegger, I was able to see the issue and its already a Bug. We have already filed a bug report with the Developement team. Defect #552 - AddCopy does not work properly when copying multiple times Sorry for the inconvenience. Thanks, Seetha >Hi Seetha, I put the zip file of simple project that must demonstrate the problem. This code shows the same problems that appears in my big project. The stack trace is the same. > > >ExcelRWProblems_9731.zip > >

CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

;