Excel Files downloaded from the internet causing "Reference isn't valid" error on version 9.1.4620

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

Excel Files downloaded from the internet causing "Reference isn't valid" error on version 9.1.4620
 
Andrei Smolin


Add-in Express team


Posts: 16662
Joined: 2006-05-11
Tim,

I've found the following ways to get the address of the active cell from the XLL:

public static string ActiveCellAddress()
{
    AddinExpress.MSO.ADXExcelRef reference = Module.CallWorksheetFunction(ADXExcelWorksheetFunction.ActiveCell) as AddinExpress.MSO.ADXExcelRef;
    return string.Format("Cell coordinates=[{0},{1},{2},{3}] Cell address='{4}'", reference.ColumnFirst, reference.RowFirst, reference.ColumnLast, reference.RowLast, reference.ConvertToA1Style());
}


Regards from Belarus (GMT+3),

Andrei Smolin
Add-in Express Team Leader
Posted 26 Sep, 2018 07:18:53 Top