@ Sign in Office 365

[Nadeem Akhtar]

Hi,

I developed an Excel Add-In using Excel-DNA that created different UDFs that fetch data from API and display it in Excel. Everything was working fine before Excel 365. I have noticed that my UDFs are preceded by =@  however I didn't put it there and now UDFs are not working. They work fine if I manually remove @ sign.

Regards,

[Govert van Drimmelen]

--------------------------------------------------

Excel-DNA is now registered on GitHub Sponsors.

Add a support subscription to your private or corporate GitHub account to ensure future development.

--------------------------------------------------

Hi Nadeem

This is a compatibility feature of Excel to deal with the new Dynamic Arrays.

You can read about the implicit intersection @ operator here: https://support.microsoft.com/en-us/office/implicit-intersection-operator-ce3be07b-0101-4450-a24e-c1c999be2b34?ui=en-us&rs=en-us&ad=us

 The @ gets added to your formula in two cases:

* When opening a sheet that was saved in a pre-Dynamic Arrays version of Excel. This is for compatibility as discussed in the article linked above.

* When setting the formula of a cell through the COM interface property Range.Formula. For this case you should instead use the new Range.Formula2 property to set the formula. See https://docs.microsoft.com/en-us/office/vba/excel/concepts/cells-and-ranges/range-formula-vs-formula2

 

I have put a few other links here: https://github.com/Excel-DNA/ExcelDna/wiki/Dynamic-Arrays

-Govert

--
You received this message because you are subscribed to the Google Groups "Excel-DNA" group.
To unsubscribe from this group and stop receiving emails from it, send an email to exceldna+u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/exceldna/65ae5153-32a5-4fbe-96ad-e5819408f25an%40googlegroups.com.

[Nadeem Akhtar]

Hi Govert,

Thanks for the quick response.

I am using Microsoft.Office.Interop.Excel interop version 15.0.0.0 and Range does not contain the property Formula2.

Range only has Formula as property.

Do I need to upgrade the interop assembly to the latest one to access Formula2 property?

Regards,

Nadeem Akhtar

[Nadeem Akhtar]

HI Govert,

Following are the properties that I can access from Range object.