Excel::Shape object getting released automatically after the count reaches 18 in List<T>
Posted
by A9S6
on Stack Overflow
See other posts from Stack Overflow
or by A9S6
Published on 2010-05-31T11:44:56Z
Indexed on
2010/05/31
12:33 UTC
Read the original article
Hit count: 339
I have a Excel addin written in C# 2.0 in which I am experiencing a strange behavior.Please note that this behavior is only seen in Excel 2003 and NOT in Excel 2007 or 2010.
Issue:
When the user clicks an import command button, a file is read and a number of Shapes are created/added to the worksheet using Worksheet::Shapes::AddPicture() method. A reference to these Shape objects are kept in a generic list:
List<Excel.Shape> list = new List<Excel.Shape>();
Everything works fine till the list has less than 18 references. When the count reaches 18, and a new Shape reference is added, the first one i.e. @ index [0] is released. I am unable to call any method or property on that reference and calling a method/property throws a COMException (0x800A1A8) i.e. Object Required. If I add one more, then the reference @ [1] is not accessible and so on.
Strange enough... this happens with Shape object only i.e. If I add one Shape and then 17 nulls to the list then this wont happen until 17 more Shape objects are added.
Does anyone has an idea why it happens after the count reaches 18?
I thought it might be something with the List's default capacity. Something like relocating the references during which they get released so I initialized it with a capacity of 1000 but still no luck.
List<Excel.Shape> list = new List<Excel.Shape>(1000);
Any Idea??
© Stack Overflow or respective owner