Format Cells dialog non functional with Spread 12 SP1

Format Cells dialog non functional with Spread 12 SP1

Posted by: Peter.Priestley on 13 June 2019, 11:50 am EST

• 

  Peter.Priestley

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 13 June 2019, 11:50 am EST

  After upgrading to the recently released 2012 SP1 (12.45.20191.0) I am finding that the Format Cells dialog throws an exception and is non-functional.

  This can be demonstrated using the Spread Designer.
  
  Open Spread Designer.
  
  Right Click on any cell.
  
  Select “Format Cells…” from the popup menu.

  Dialog displays but immediately displays an Unhandled exception message. Clicking Continue on the exception message dialog, the editing features of the Number tab are mostly missing. Changing the Category for example produces further Unhandled exception messages.

• 

  Ruchir.Agarwal

  

  • Post Options:
  • Link
    Copy

  Posted 13 June 2019, 10:57 pm EST

  Hello,

  This is not the case at my end using the same ServicePack version. See attached video.
  
  Does this exception occur for you everytime or it sporadic?

  Thanks,
  
  Ruchir

• 

  Peter.Priestley

  • Post Options:
  • Link
    Copy

  Posted 16 June 2019, 6:32 pm EST - Updated 30 September 2022, 4:46 am EST

  The exception happens every time.

  I considered that my developer box may be suffering version-hell, so I tried installing Spread 12 SP1 on another PC that had never had Spread installed. This had exactly the same behaviour when running Spread Designer, i.e. exception displayed as soon as the Format Cells dialog is displayed.

  I have attached a screen shot of the issue and the debugging info returned by the exception message Details button.

  

  928×699 60.7 KB

  Details.zip

• 

  Ruchir.Agarwal

  

  • Post Options:
  • Link
    Copy

  Posted 18 June 2019, 4:34 pm EST

  This is strange since checking this (using Spread 12.45.0.20191.0) on a fresh machine at my end, again works properly.
  
  Can you share the environment details like Windows, OS version etc? As it could be environment specific.
  
  Also just to confirm, since you were not facing this earlier before upgrade, how did you perform the upgrade, what steps did you follow?

  Thanks,
  
  Ruchir

• 

  Peter.Priestley

  • Post Options:
  • Link
    Copy

  Posted 19 June 2019, 12:47 pm EST

  The combinations I have tried are:-
  
  Windows 10.0.17763 + Office 365 Excel 16.0.11629.20210 + NET Framework 4.7.3416.
  
  Windows 10.0.14393 + Office 2010 Excel 14.0.7232.5000 + NET Framework 4.7.2650.
  
  Windows 7 6.1.7601 + No office + NET Framework 4.7.3324.

  It always fails for me with Spread 12.45.20191.0 and always worked with the previous version Spread 12.45.20181.2.

  I install Spread by downloading the bootstrapper (spread.net-installer.exe) and running this with the options set to “online”. (The installer does appear to be for 12 SP1 and the dll versions after installing are …20191.0).

  Perhaps it is a NET Framework issue as all my machines are running 4.7. According to your documentation Spread should require NET 4.5.2 - does that still apply? We are using VS2017 for development and have not installed VS2019 or NET 4.8.

• 

  Ruchir.Agarwal

  

  • Post Options:
  • Link
    Copy

  Posted 19 June 2019, 11:58 pm EST

  Thank you Peter for sharing the environment information.

  I am discussing with the developer as to what can be the cause of the issue [ID: 273499] at your end. I’ll get back to you as soon as we have solution/question/information for you.
  
  Thank you for patience.

  Kind Regards,
  
  Ruchir

• 

  Ruchir.Agarwal

  

  • Post Options:
  • Link
    Copy

  Posted 20 June 2019, 3:42 pm EST

  Hello Peter,

  Apologies to annoy you but could you help us in troubleshooting this further by copying the error information here? You can get the information by clicking the ‘Details’ button in the error dialog.

  Thanks & regards,
  
  Ruchir

• 

  Peter.Priestley

  • Post Options:
  • Link
    Copy

  Posted 23 June 2019, 4:12 pm EST

  See the end of this message for details on invoking
  
  just-in-time (JIT) debugging instead of this dialog box.

  ************** Exception Text **************
  
  System.NullReferenceException: Object reference not set to an instance of an object.
  
  at od.f()
  
  at od.a(e A_0)
  
  at od.h()
  
  at od.a(Worksheet A_0, Object A_1, NumberFormat A_2)
  
  at FarPoint.Win.Spread.FormatCells.OnShown(EventArgs e)
  
  at System.Windows.Forms.Form.CallShownEvent()
  
  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()

  ************** Loaded Assemblies **************
  
  mscorlib
  
  Assembly Version: 4.0.0.0
  
  Win32 Version: 4.7.2650.0 built by: NET471REL1LAST_B
  
  CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v4.0.30319/mscorlib.dll

  FarPoint.SpreadDesigner
  
  Assembly Version: 12.45.20191.0
  
  Win32 Version: 12.45.20191.0
  
  CodeBase: file:///C:/Program%20Files%20(x86)/GrapeCity/Spread.NET%2012/Windows%20Forms/v12.45.20191.0/bin/FarPoint.SpreadDesigner.exe

  System.Windows.Forms
  
  Assembly Version: 4.0.0.0
  
  Win32 Version: 4.7.2558.0 built by: NET471REL1
  
  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.2634.0 built by: NET471REL1LAST_C
  
  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.2558.0 built by: NET471REL1
  
  CodeBase: file:///C:/windows/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll

  FarPoint.Win.Spread
  
  Assembly Version: 12.45.20191.0
  
  Win32 Version: 12.45.20191.0
  
  CodeBase: file:///C:/windows/Microsoft.Net/assembly/GAC_MSIL/FarPoint.Win.Spread/v4.0_12.45.20191.0__327c3516b1b18457/FarPoint.Win.Spread.dll

  System.Core
  
  Assembly Version: 4.0.0.0
  
  Win32 Version: 4.7.2634.0 built by: NET471REL1LAST_C
  
  CodeBase: file:///C:/windows/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll

  FarPoint.Win
  
  Assembly Version: 12.45.20191.0
  
  Win32 Version: 12.45.20191.0
  
  CodeBase: file:///C:/windows/Microsoft.Net/assembly/GAC_MSIL/FarPoint.Win/v4.0_12.45.20191.0__327c3516b1b18457/FarPoint.Win.dll

  Microsoft.VisualBasic
  
  Assembly Version: 10.0.0.0
  
  Win32 Version: 14.7.2558.0 built by: NET471REL1
  
  CodeBase: file:///C:/windows/Microsoft.Net/assembly/GAC_MSIL/Microsoft.VisualBasic/v4.0_10.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualBasic.dll

  FarPoint.Win.Spread.Design
  
  Assembly Version: 12.45.20191.0
  
  Win32 Version: 12.45.20191.0
  
  CodeBase: file:///C:/windows/Microsoft.Net/assembly/GAC_MSIL/FarPoint.Win.Spread.Design/v4.0_12.45.20191.0__327c3516b1b18457/FarPoint.Win.Spread.Design.dll

  C1.Win.C1Ribbon.4
  
  Assembly Version: 4.0.20183.347
  
  Win32 Version: 4.0.20183.347
  
  CodeBase: file:///C:/Program%20Files%20(x86)/GrapeCity/Spread.NET%2012/Windows%20Forms/v12.45.20191.0/bin/Designer/C1.Win.C1Ribbon.4.DLL

  GrapeCity.Spreadsheet.Win
  
  Assembly Version: 12.45.20191.0
  
  Win32 Version: 12.45.20191.0
  
  CodeBase: file:///C:/windows/Microsoft.Net/assembly/GAC_MSIL/GrapeCity.Spreadsheet.Win/v4.0_12.45.20191.0__327c3516b1b18457/GrapeCity.Spreadsheet.Win.dll

  GrapeCity.Spreadsheet
  
  Assembly Version: 12.45.20191.0
  
  Win32 Version: 12.45.20191.0
  
  CodeBase: file:///C:/windows/Microsoft.Net/assembly/GAC_MSIL/GrapeCity.Spreadsheet/v4.0_12.45.20191.0__327c3516b1b18457/GrapeCity.Spreadsheet.dll

  GrapeCity.CalcEngine
  
  Assembly Version: 12.45.20191.0
  
  Win32 Version: 12.45.20191.0
  
  CodeBase: file:///C:/windows/Microsoft.Net/assembly/GAC_MSIL/GrapeCity.CalcEngine/v4.0_12.45.20191.0__327c3516b1b18457/GrapeCity.CalcEngine.dll

  System.Configuration
  
  Assembly Version: 4.0.0.0
  
  Win32 Version: 4.7.2558.0 built by: NET471REL1
  
  CodeBase: file:///C:/windows/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll

  System.Xml
  
  Assembly Version: 4.0.0.0
  
  Win32 Version: 4.7.2612.0 built by: NET471REL1LAST_B
  
  CodeBase: file:///C:/windows/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll

  FarPoint.Localization
  
  Assembly Version: 12.45.20191.0
  
  Win32 Version: 12.45.20191.0
  
  CodeBase: file:///C:/windows/Microsoft.Net/assembly/GAC_MSIL/FarPoint.Localization/v4.0_12.45.20191.0__327c3516b1b18457/FarPoint.Localization.dll

  System.Data
  
  Assembly Version: 4.0.0.0
  
  Win32 Version: 4.7.2623.0 built by: NET471REL1LAST_C
  
  CodeBase: file:///C:/windows/Microsoft.Net/assembly/GAC_32/System.Data/v4.0_4.0.0.0__b77a5c561934e089/System.Data.dll

  C1.Win.C1InputPanel.4
  
  Assembly Version: 4.0.20183.347
  
  Win32 Version: 4.0.20183.347
  
  CodeBase: file:///C:/Program%20Files%20(x86)/GrapeCity/Spread.NET%2012/Windows%20Forms/v12.45.20191.0/bin/Designer/C1.Win.C1InputPanel.4.DLL

  C1.Win.4
  
  Assembly Version: 4.0.20183.347
  
  Win32 Version: 4.0.20183.347
  
  CodeBase: file:///C:/Program%20Files%20(x86)/GrapeCity/Spread.NET%2012/Windows%20Forms/v12.45.20191.0/bin/Designer/C1.Win.4.DLL

  C1.Win.C1Themes.4
  
  Assembly Version: 4.0.20183.347
  
  Win32 Version: 4.0.20183.347
  
  CodeBase: file:///C:/Program%20Files%20(x86)/GrapeCity/Spread.NET%2012/Windows%20Forms/v12.45.20191.0/bin/Designer/C1.Win.C1Themes.4.DLL

  C1.C1Zip.4
  
  Assembly Version: 4.0.20183.347
  
  Win32 Version: 4.0.20183.347
  
  CodeBase: file:///C:/Program%20Files%20(x86)/GrapeCity/Spread.NET%2012/Windows%20Forms/v12.45.20191.0/bin/Designer/C1.C1Zip.4.DLL

  Accessibility
  
  Assembly Version: 4.0.0.0
  
  Win32 Version: 4.7.2558.0 built by: NET471REL1
  
  CodeBase: file:///C:/windows/Microsoft.Net/assembly/GAC_MSIL/Accessibility/v4.0_4.0.0.0__b03f5f7f11d50a3a/Accessibility.dll

  FarPoint.CalcEngine
  
  Assembly Version: 12.45.20191.0
  
  Win32 Version: 12.45.20191.0
  
  CodeBase: file:///C:/windows/Microsoft.Net/assembly/GAC_MSIL/FarPoint.CalcEngine/v4.0_12.45.20191.0__327c3516b1b18457/FarPoint.CalcEngine.dll

  FarPoint.Win.TextRenderer
  
  Assembly Version: 12.45.20191.0
  
  Win32 Version: 12.45.20191.0
  
  CodeBase: file:///C:/Program%20Files%20(x86)/GrapeCity/Spread.NET%2012/Windows%20Forms/v12.45.20191.0/bin/FarPoint.Win.TextRenderer.DLL

  System.Design
  
  Assembly Version: 4.0.0.0
  
  Win32 Version: 4.7.2558.0 built by: NET471REL1
  
  CodeBase: file:///C:/windows/Microsoft.Net/assembly/GAC_MSIL/System.Design/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Design.dll

  GrapeCity.Win.PluginInputMan
  
  Assembly Version: 12.45.20191.0
  
  Win32 Version: 12.45.20191.0
  
  CodeBase: file:///C:/windows/Microsoft.Net/assembly/GAC_MSIL/GrapeCity.Win.PluginInputMan/v4.0_12.45.20191.0__327c3516b1b18457/GrapeCity.Win.PluginInputMan.dll

  System.Drawing.Design
  
  Assembly Version: 4.0.0.0
  
  Win32 Version: 4.7.2558.0 built by: NET471REL1
  
  CodeBase: file:///C:/windows/Microsoft.Net/assembly/GAC_MSIL/System.Drawing.Design/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.Design.dll

  FarPoint.Excel
  
  Assembly Version: 12.45.20191.0
  
  Win32 Version: 12.45.20191.0
  
  CodeBase: file:///C:/windows/Microsoft.Net/assembly/GAC_MSIL/FarPoint.Excel/v4.0_12.45.20191.0__327c3516b1b18457/FarPoint.Excel.dll

  FarPoint.Win.Chart
  
  Assembly Version: 12.45.20191.0
  
  Win32 Version: 12.45.20191.0
  
  CodeBase: file:///C:/windows/Microsoft.Net/assembly/GAC_MSIL/FarPoint.Win.Chart/v4.0_12.45.20191.0__327c3516b1b18457/FarPoint.Win.Chart.dll

  ************** JIT Debugging **************
  
  To enable just-in-time (JIT) debugging, the .config file for this
  
  application or computer (machine.config) must have the
  
  jitDebugging value set in the system.windows.forms section.
  
  The application must also be compiled with debugging
  
  enabled.

  For example:

  When JIT debugging is enabled, any unhandled exception
  
  will be sent to the JIT debugger registered on the computer
  
  rather than be handled by this dialog box.

• 

  Ruchir.Agarwal

  

  • Post Options:
  • Link
    Copy

  Posted 23 June 2019, 10:22 pm EST

  Thank you Peter. This will help our dev. team to investigate better and quicker over this issue.
  
  I’ll get back to you once we have some information/the issue gets fixed.

  Thanks,
  
  Ruchir

• 

  Peter.Priestley

  • Post Options:
  • Link
    Copy

  Posted 10 July 2019, 5:38 pm EST

  I have determined that having .NET Framework 4.5.2, 4.7 or 4.8 installed makes no difference, the Spread Designer fails in the same way. I have not found any combination that does not fail.

  This is a big problem. I do not want to roll back 12 SP1 to 12 due to the other improvements in SP1, especially the regional settings fixes mentioned in one of my other posts. I’m especially interested in understanding more about the problem, in case it is possible to craft a work-around (rather than wait for SP2).

  What is the best method to get some response from the dev team? I would be willing to pay for priority support.

  Thanks,
  
  Peter P.

• 

  Ruchir.Agarwal

  

  • Post Options:
  • Link
    Copy

  Posted 12 July 2019, 12:42 am EST

  Hello Peter,

  I am happy to inform you that the issue has been internally fixed and I have inquired the managers for the release date.
  
  Regarding the support package, I am discussing this with the team and will get to you with some information.

  Regards,
  
  Ruchir

• 

  Ruchir.Agarwal

  

  • Post Options:
  • Link
    Copy

  Posted 7 August 2019, 3:35 pm EST

  Hi Peter,

  Regarding priority support, you are suggested to visit the following webpage. The page mentions the product wise support plans that we offer, out of which you can choose any.
  
  Support Plans: https://www.grapecity.com/support/plans

  Kind Regards,
  
  Ruchir

• 

  Peter.Priestley

  • Post Options:
  • Link
    Copy

  Posted 7 August 2019, 4:40 pm EST

  Is there an expected release date for 12 SP2?

• 

  Ruchir.Agarwal

  

  • Post Options:
  • Link
    Copy

  Posted 11 August 2019, 9:38 pm EST

  Hello,

  It is expected to release soon. However, for the exact dates I am inquiring this with the product manager.
  
  Will get back to you soon with information on release dates.

  Thanks,
  
  Ruchir

• 

  Ruchir.Agarwal

  

  • Post Options:
  • Link
    Copy

  Posted 19 August 2019, 5:52 pm EST

  Hello,

  The issue you reported here have found to have been fixed in the latest release version of Spread.Net12. So, you’re requested to download the latest version and verify the fix.

  Download: https://www.grapecity.com/download/spreadnet

  Best wishes,
  
  Ruchir

• 

  Peter.Priestley

  • Post Options:
  • Link
    Copy

  Posted 21 August 2019, 6:44 pm EST

  Hi Ruchir,
  
  Thanks, I’ve tested SP2 and the issue appears to be fixed.
  
  Peter P.