bovender / XLToolbox

Daniel's XL Toolbox is an open-source add-in for Excel(R) that assists with scientific and technical data analysis and visualization.
https://www.xltoolbox.net
Apache License 2.0
55 stars 10 forks source link

There's a problem with this formula. Not trying to type a formula? When the first character is an equal (=) or minus (-) sign, Excel thinks it's a formula: • you type: =1+1, cell shows: 2 To get around this, type an apostrophe ( ' ) first: • you type: '=1+1, cell shows: =1+1 #928

Open bovender opened 3 years ago

bovender commented 3 years ago

This issue was submitted by the add-in's exception handler.

Exception:

System.Runtime.InteropServices.COMException (0x800A03EC): There's a problem with this formula.

Not trying to type a formula?
When the first character is an equal (=) or minus (-) sign, Excel thinks it's a formula:

• you type:   =1+1, cell shows:   2

To get around this, type an apostrophe ( ' ) first:

• you type:   '=1+1, cell shows:   =1+1
   at Microsoft.Office.Interop.Excel._Workbook.Save()
   at XLToolbox.Excel.ViewModels.Instance.ConfirmQuitSavingChanges() in X:\Code\xltoolbox\NG\XLToolbox\Excel\ViewModels\Instance.cs:line 871
   at XLToolbox.Excel.ViewModels.Instance.<DoQuitSavingChanges>b__61_0(MessageContent response) in X:\Code\xltoolbox\NG\XLToolbox\Excel\ViewModels\Instance.cs:line 842
   at Bovender.Mvvm.Messaging.Message`1.<>c__DisplayClass3_0.<Send>b__0() in X:\Code\bovender\Bovender\Mvvm\Messaging\Message.cs:line 67
   at Bovender.Mvvm.Actions.MessageActionBase.<>c__DisplayClass5_1`1.<Invoke>b__0(Object sender, EventArgs e) in X:\Code\bovender\Bovender\Mvvm\Actions\MessageActionBase.cs:line 78
   at System.EventHandler.Invoke(Object sender, EventArgs e)
   at Bovender.Mvvm.ViewModels.ViewModelBase.DoCloseView() in X:\Code\bovender\Bovender\Mvvm\ViewModels\ViewModelBase.cs:line 329
   at Bovender.Mvvm.Messaging.MessageContent.DoConfirm() in X:\Code\bovender\Bovender\Mvvm\Messaging\MessageContent.cs:line 84
   at Bovender.Mvvm.Messaging.MessageContent.<get_ConfirmCommand>b__21_0(Object param) in X:\Code\bovender\Bovender\Mvvm\Messaging\MessageContent.cs:line 55
   at Bovender.Mvvm.DelegatingCommand.Execute(Object parameter) in X:\Code\bovender\Bovender\Mvvm\DelegatingCommand.cs:line 121

Message: There's a problem with this formula.

Not trying to type a formula? When the first character is an equal (=) or minus (-) sign, Excel thinks it's a formula:

• you type: =1+1, cell shows: 2

To get around this, type an apostrophe ( ' ) first:

• you type: '=1+1, cell shows: =1+1

Environment

Parameter Value
Version 7.3.4
OS Microsoft Windows NT 10.0.17763.0, 64-bit
Excel 365 (16.0.5110), 32-bit
CLR 4.0.30319.42000, 32-bit
VSTO runtime 10.0.60301
ClickOnce False
Bovender 0.18.0.0
FreeImage 3.18.0
Identifier 9e320a6000440371f2667de16ad54e24dc94539276e7213c78e12257cbf90cc9