Wednesday, May 1, 2013

Spreadsheetgear Issue with Macros

S/shgear lists macros under namedranges

this makes no sense to me

I had to do this to weed them out:



SpreadsheetGear.IRange tempName = name.RefersToRange;
                    //tempName.Name!= null avoids adding macros
                    //wish s/sh gear had a better way of identifying name type
                    if (tempName != null && tempName.Name!= null)
                    {

No comments:

Post a Comment