When using Excel via COM, why does the Value2 property fail?

The Dyalog "Knowledgebase". This forum is read-only
Forum rules
The FAQ is a read-only forum which is in general updated only by employees of Dyalog Ltd. It replaces the FAQ page which existed under http://www.dyalog.com. Rather than rejecting other posts to this forum, such posts will be put in a moderation queue, and moved to a more appropriate forum.

When using Excel via COM, why does the Value2 property fail?

Postby Vince|Dyalog on Tue Nov 16, 2010 2:51 pm

The range of cells contains a value which cannot be represented in Dyalog. An example would be the divide by zero error value "#DIV/0!". When we ask Excel for the Value2 property, Excel tells us there is an error in the data. So, we generate a DOMAIN ERROR.
Vince|Dyalog
 
Posts: 412
Joined: Wed Oct 01, 2008 9:39 am

Return to Frequently Asked Questions (FAQ)

Who is online

Users browsing this forum: No registered users and 1 guest