Re: [ExcelDna] Deprecated Excel Formulas

[C. Augusto Proiete]

Excel doesn't seem to have a documented way to mark functions as deprecated from an add-in through their C API, which is what Excel-DNA uses to register functions.

One thing you can do as an alternative, is mark your function as "hidden" which means the function will still work if you know how to call it, but it will not show in the function list anymore.

[ExcelFunction(IsHidden = true)]
public static bool MyFunction()
{
    // ...
}

Cheers,

C. Augusto Proiete

https://augustoproiete.net

On Tue, Nov 24, 2020 at 12:00 PM Dominykas <dominykas...@gmail.com> wrote:

Hello, is it possible to set the formula as obsolete, to mark it as deprecated in excel? Excel shows warning near deprecated formulas.

Tried System.ObsoleteAttribute but it didn't have any effect, as expected I guess.

--
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/20629828-2263-4c38-b5f6-576dd32702f2n%40googlegroups.com.