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 : Nov 16th 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Spreadsheet example app crashes when deleting a sheet

Thread ID:

Created:

Updated:

Platform:

Replies:

129811 Apr 5,2017 02:42 AM UTC Apr 7,2017 07:21 AM UTC WinForms 3
loading
Tags: Spreadsheet
Simon Webster
Asked On April 5, 2017 02:42 AM UTC

This issue relates directly to the sample provided with the following versions of the Windows Forms Spreadhseet component in Essential Studio:
15.1.0.33
15.1.0.37
15.1.0.41

Replication:
Opening the example included via the Syncfusion Control Panel in offline mode, adding a new sheet via the + icon at the bottom, then deleting this sheet by right clicking on the new tab and selecting delete crashes the sample program. 
This also happens if the process is performed when a spreadsheet that already contains multiple sheets is opened and the user attempts to delete a sheet. 

Windows 10, 64 bit. 




Debug Log:
*** Exception Text ***
System.NullReferenceException: Object reference not set to an instance of an object.
   at Syncfusion.XlsIO.Implementation.WorksheetImpl.GetXFIndex(Int32 iRow, Int32 iColumn)
   at Syncfusion.XlsIO.Implementation.RangeImpl.get_ExtendedFormatIndex()
   at Syncfusion.XlsIO.Implementation.CellStyle.BeforeRead()
   at Syncfusion.XlsIO.Implementation.ExtendedFormatWrapper.get_Font()
   at Syncfusion.Windows.Forms.Spreadsheet.SpreadsheetRibbon.UpdateFontSize()
   at Syncfusion.Windows.Forms.Spreadsheet.SpreadsheetRibbon.OnCurrentCellStyleChanged()
   at Syncfusion.Windows.Forms.Spreadsheet.Commands.DeleteCommand.OnExecute(Object parameter)
   at Syncfusion.Windows.Forms.Spreadsheet.Commands.CommandBase.Execute(Object parameter)
   at System.Windows.Forms.ToolStripItem.RaiseEvent(Object key, EventArgs e)
   at System.Windows.Forms.ToolStripMenuItem.OnClick(EventArgs e)
   at System.Windows.Forms.ToolStripItem.HandleClick(EventArgs e)
   at System.Windows.Forms.ToolStripItem.HandleMouseUp(MouseEventArgs e)
   at System.Windows.Forms.ToolStrip.OnMouseUp(MouseEventArgs mea)
   at System.Windows.Forms.ToolStripDropDown.OnMouseUp(MouseEventArgs mea)
   at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.ToolStrip.WndProc(Message& m)
   at System.Windows.Forms.ToolStripDropDown.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

*** Loaded Assemblies ***
mscorlib
    Assembly Version: 4.0.0.0
    Win32 Version: 4.7.2046.0 built by: NET47REL1
    CodeBase: file:///C:/Windows/Microsoft.NET/Framework64/v4.0.30319/mscorlib.dll
----------------------------------------
SpreadsheetDemo
    Assembly Version: 1.0.0.0
    Win32 Version: 1.0.0.0
    CodeBase: file:///C:/Users/i5-Desktop/AppData/Local/Syncfusion/EssentialStudio/15.1.0.37/Windows/Spreadsheet.Windows/Samples/GettingStarted/cs/bin/release/SpreadsheetDemo.exe
----------------------------------------
Syncfusion.Tools.Windows
    Assembly Version: 15.1400.0.37
    Win32 Version: 15.1400.0.37
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/Syncfusion.Tools.Windows/v4.0_15.1400.0.37__3d67ed1f87d44c89/Syncfusion.Tools.Windows.dll
----------------------------------------
System.Windows.Forms
    Assembly Version: 4.0.0.0
    Win32 Version: 4.7.2046.0 built by: NET47REL1
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System
    Assembly Version: 4.0.0.0
    Win32 Version: 4.7.2046.0 built by: NET47REL1
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Drawing
    Assembly Version: 4.0.0.0
    Win32 Version: 4.7.2046.0 built by: NET47REL1
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
Syncfusion.Shared.Base
    Assembly Version: 15.1400.0.37
    Win32 Version: 15.1400.0.37
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/Syncfusion.Shared.Base/v4.0_15.1400.0.37__3d67ed1f87d44c89/Syncfusion.Shared.Base.dll
----------------------------------------
System.Configuration
    Assembly Version: 4.0.0.0
    Win32 Version: 4.7.2046.0 built by: NET47REL1
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System.Core
    Assembly Version: 4.0.0.0
    Win32 Version: 4.7.2046.0 built by: NET47REL1
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll
----------------------------------------
System.Xml
    Assembly Version: 4.0.0.0
    Win32 Version: 4.7.2046.0 built by: NET47REL1
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
Syncfusion.Spreadsheet.Windows
    Assembly Version: 15.1400.0.37
    Win32 Version: 15.1400.0.37
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/Syncfusion.Spreadsheet.Windows/v4.0_15.1400.0.37__3d67ed1f87d44c89/Syncfusion.Spreadsheet.Windows.dll
----------------------------------------
Syncfusion.XlsIO.Base
    Assembly Version: 15.1400.0.37
    Win32 Version: 15.1400.0.37
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/Syncfusion.XlsIO.Base/v4.0_15.1400.0.37__3d67ed1f87d44c89/Syncfusion.XlsIO.Base.dll
----------------------------------------
Syncfusion.Compression.Base
    Assembly Version: 15.1400.0.37
    Win32 Version: 15.1400.0.37
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/Syncfusion.Compression.Base/v4.0_15.1400.0.37__3d67ed1f87d44c89/Syncfusion.Compression.Base.dll
----------------------------------------
System.Data
    Assembly Version: 4.0.0.0
    Win32 Version: 4.7.2046.0 built by: NET47REL1
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_64/System.Data/v4.0_4.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
System.Numerics
    Assembly Version: 4.0.0.0
    Win32 Version: 4.7.2046.0 built by: NET47REL1
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Numerics/v4.0_4.0.0.0__b77a5c561934e089/System.Numerics.dll
----------------------------------------
Accessibility
    Assembly Version: 4.0.0.0
    Win32 Version: 4.7.2046.0 built by: NET47REL1
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/Accessibility/v4.0_4.0.0.0__b03f5f7f11d50a3a/Accessibility.dll
----------------------------------------
System.Design
    Assembly Version: 4.0.0.0
    Win32 Version: 4.7.2046.0 built by: NET47REL1
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Design/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Design.dll
----------------------------------------
System.Xml.Linq
    Assembly Version: 4.0.0.0
    Win32 Version: 4.7.2046.0 built by: NET47REL1
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml.Linq/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.Linq.dll
----------------------------------------


Gayathri Arumugam [Syncfusion]
Replied On April 5, 2017 10:26 AM UTC

  
Hi Simon, 
  
We have confirmed that the issue “Application crashes while deleting a sheet in Spreadsheet” is a defect and we have logged a defect report. The fix for this issue will be available in our upcoming 2017 Vol 2 main release which is scheduled to be rolled out by end of April 2017. 
 
Please let us know if you need any further assistance.           
 
Regards,  
Gayathri A  
 


Simon Webster
Replied On April 5, 2017 10:29 AM UTC

Thanks Gayathri.

There's also the other issue I posted regarding errors in the output window concerning Xamarin / Mono Android.

Simon

Gayathri Arumugam [Syncfusion]
Replied On April 7, 2017 07:21 AM UTC

Hi Simon, 

We have provided the response in corresponding incident and forum. Please follow up the same for further updates. 

Regards, 
Gayathri A 


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

;