Spreadsheet example app crashes when deleting a sheet

[Simon Webster]

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]

  

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]

Thanks Gayathri.

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

Simon

[Gayathri Arumugam]

Hi Simon, 

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

Regards, 

Gayathri A