search

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

Clear method of Range class failed #891

Open bovender opened 4 years ago

bovender commented 4 years ago

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

Exception:

System.Runtime.InteropServices.COMException (0x800A03EC): Clear method of Range class failed
   at System.RuntimeType.ForwardCallToInvokeMember(String memberName, BindingFlags flags, Object target, Int32[] aWrapperTypes, MessageData& msgData)
   at Microsoft.Office.Interop.Excel.Range.Clear()
   at XLToolbox.WorkbookStorage.Store.PrepareStoreSheet() in X:\Code\xltoolbox\NG\XLToolbox\WorkbookStorage\Store.cs:line 575
   at XLToolbox.WorkbookStorage.Store.WriteToWorksheet() in X:\Code\xltoolbox\NG\XLToolbox\WorkbookStorage\Store.cs:line 500
   at XLToolbox.WorkbookStorage.Store.Dispose(Boolean disposing) in X:\Code\xltoolbox\NG\XLToolbox\WorkbookStorage\Store.cs:line 253
   at XLToolbox.WorkbookStorage.Store.Dispose() in X:\Code\xltoolbox\NG\XLToolbox\WorkbookStorage\Store.cs:line 240
   at XLToolbox.Export.Models.Preset.Store(Workbook workbookContext) in X:\Code\xltoolbox\NG\XLToolbox\Export\Models\Preset.cs:line 173
   at XLToolbox.Export.Models.Preset.Store() in X:\Code\xltoolbox\NG\XLToolbox\Export\Models\Preset.cs:line 178
   at XLToolbox.Export.ViewModels.PresetViewModel.Store() in X:\Code\xltoolbox\NG\XLToolbox\Export\ViewModels\PresetViewModel.cs:line 345
   at XLToolbox.Export.ViewModels.SingleExportSettingsViewModel.DoExport() in X:\Code\xltoolbox\NG\XLToolbox\Export\ViewModels\SingleExportSettingsViewModel.cs:line 266
   at XLToolbox.Export.ViewModels.SingleExportSettingsViewModel.DoConfirmFileName(FileNameMessageContent messageContent) in X:\Code\xltoolbox\NG\XLToolbox\Export\ViewModels\SingleExportSettingsViewModel.cs:line 368
   at XLToolbox.Export.ViewModels.SingleExportSettingsViewModel.<DoChooseFileName>b__35_0(FileNameMessageContent content) in X:\Code\xltoolbox\NG\XLToolbox\Export\ViewModels\SingleExportSettingsViewModel.cs:line 343
   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.FileDialogActionBase.Invoke(Object parameter) in X:\Code\bovender\Bovender\Mvvm\Actions\FileDialogActionBase.cs:line 104
   at System.Windows.Interactivity.TriggerBase.InvokeActions(Object parameter)
   at System.Windows.Interactivity.EventTriggerBase.OnEvent(EventArgs eventArgs)
   at System.Windows.Interactivity.EventTriggerBase.OnEventImpl(Object sender, EventArgs eventArgs)
   at Bovender.Mvvm.Messaging.Message`1.Send(T messageContent, Action`1 respond) in X:\Code\bovender\Bovender\Mvvm\Messaging\Message.cs:line 62
   at XLToolbox.Export.ViewModels.SingleExportSettingsViewModel.DoChooseFileName() in X:\Code\xltoolbox\NG\XLToolbox\Export\ViewModels\SingleExportSettingsViewModel.cs:line 338
   at XLToolbox.Export.ViewModels.SingleExportSettingsViewModel.<get_ChooseFileNameCommand>b__22_0(Object param) in X:\Code\xltoolbox\NG\XLToolbox\Export\ViewModels\SingleExportSettingsViewModel.cs:line 203
   at Bovender.Mvvm.DelegatingCommand.Execute(Object parameter) in X:\Code\bovender\Bovender\Mvvm\DelegatingCommand.cs:line 121

Message: Clear method of Range class failed

Environment

Parameter Value
Version 7.3.4
OS Microsoft Windows NT 10.0.18363.0, 64-bit
Excel 365 (16.0.12730), 32-bit
CLR 4.0.30319.42000, 32-bit
VSTO runtime 10.0.60828
ClickOnce False
Bovender 0.18.0.0
FreeImage 3.18.0
Identifier 6c244cbe2b6eede2b5a9aee915b42f608c22c546ec223c9a9d4876bdeb01b330