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. Image for the cookie policy date

Spreadsheet example app crashes when deleting a sheet

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
----------------------------------------


3 Replies

GA Gayathri Arumugam Syncfusion Team 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  
 



SW Simon Webster 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


GA Gayathri Arumugam Syncfusion Team 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 


Loader.
Live Chat Icon For mobile
Up arrow icon