COM Exception while setting ExcelApp.DisplayAlerts

Add-in Express™ Support Service
That's what is more important than anything else

COM Exception while setting ExcelApp.DisplayAlerts
 
Lakshman Kumar




Posts: 16
Joined: 2019-02-11
Hi,

Recently I faced the issue in List separator while saving csv file and fixed the issue as mentioned in CSV Issue.

But the same code now causing COM Exception 0x800A03EC at Microsoft.Office.Interop.Excel._Application.set_DisplayAlerts(Boolean RHS). i.e When calling
ExcelApp.DisplayAlerts = false;
.

Office version: Office 365 v16.0.11328.20420 64-bit in windows 10 64-bit.

I need to turn-off Display Alerts as I need to over write the existing file for csv due to original issue.

1. One thing I noticed is for Office 365, the issue happens only after opening csv file, type some text and leave the cursor in the cell, and click "save" icon from Ribbon commands.

2. for Office 2010 64-bit, even I clicked some where else also, I am getting same COM Exception.

Is there any way to fix the issue?

Thanks,
Lakshman.
Lakshman
Posted 08 Oct, 2019 04:16:07 Top
Andrei Smolin


Add-in Express team


Posts: 17132
Joined: 2006-05-11
Hello Lakshman,

I suggest that you set the Thread.CurrentThread.CurrentCulture as we do this at https://www.add-in-express.com/creating-addins-blog/2009/02/13/old-format-invalid-type-library/.

Regards from Belarus (GMT+3),

Andrei Smolin
Add-in Express Team Leader
Posted 08 Oct, 2019 06:43:52 Top
Lakshman Kumar




Posts: 16
Joined: 2019-02-11
Hi,

Thanks for the reply.

I tried the above suggestion, but still getting the same exception. Could you please suggest any other ways to fix the issue?

Thanks,
Lakshman.
Lakshman
Posted 08 Oct, 2019 21:27:31 Top
Andrei Smolin


Add-in Express team


Posts: 17132
Joined: 2006-05-11
Hello Lakshman,

How can I reproduce the issue? Do you have some code and steps to follow?

Regards from Belarus (GMT+3),

Andrei Smolin
Add-in Express Team Leader
Posted 09 Oct, 2019 03:13:32 Top
Lakshman Kumar




Posts: 16
Joined: 2019-02-11
Hi,

Thanks for the reply.

Please find the sample excel add-in in the following path.

sample-add-in

Steps to reproduce:
1. open existing csv file, type few characters and let the cursor be there in the cell itself. (don't press ENTER/TAB etc..).
2. click on "save" icon button from ribbon. (overriden ribben save command)
3. will be notified with exception. (message box).

Please let me know if need more details.

Thanks,
Lakshman
Posted 09 Oct, 2019 04:03:12 Top
Andrei Smolin


Add-in Express team


Posts: 17132
Joined: 2006-05-11
Hello Lakshman,

I'm sorry for missing this description earlier. The exception occurs because you cannot call save while the user edits a cell. On how to detect this scenario, see https://www.add-in-express.com/creating-addins-blog/2011/03/23/excel-check-user-edit-cell/.

Regards from Belarus (GMT+3),

Andrei Smolin
Add-in Express Team Leader
Posted 09 Oct, 2019 04:07:16 Top
Lakshman Kumar




Posts: 16
Joined: 2019-02-11
Hi,

Thanks for the reply. I'll look at the posted URL.

But why this is happening only when I override the save ribbon command with same test?

First I had only BeforeSave event, then I didn't get the exception, but once I started overriding save ribbon command issue starts happening.


Thanks,
Lakshman
Posted 09 Oct, 2019 04:28:37 Top
Andrei Smolin


Add-in Express team


Posts: 17132
Joined: 2006-05-11
Hello Lakshman,

I suppose this occurs because there are several phases after you click the button Save; the Ribbon command is invoked on an early phase (to let you cancel the click).

I assume that after the command's event is processed (the click is not cancelled), Excel finds out that the user edits a cell, cancels the edit (most probably, it saves the currently edited value to the cell) and starts saving the document; this is the moment when you receive the WorkbookBeforeSave event.

Regards from Belarus (GMT+3),

Andrei Smolin
Add-in Express Team Leader
Posted 09 Oct, 2019 06:04:01 Top