Intellisens for Excel x64 (Excel 2019)

[Alberto Ghiglia]

Hi Govert,

I recently moved to x64 Excel machine and I have problems with the intellisense

I'm using ExceDNA 0.34.6, ExcelDna.Registration 0.34.7 and I tried to update with the intellisense 1.0.4

The .dna files is as follows:

<DnaLibrary Name="AlanTools Add-In" RuntimeVersion="v4.0">
  <ExternalLibrary Path="AlanTools.dll" ExplicitExports="true" LoadFromBytes="true" Pack="true" ComServer="true"  />
  <Reference Path="ExcelDna.IntelliSense.dll" Pack="true" />

I updated the Open/Close as follows

Public Class OpenClose
    Implements IExcelAddIn
    Sub Start() Implements IExcelAddIn.AutoOpen
        IntelliSenseServer.Install()
    End Sub
 
    Sub Close() Implements IExcelAddIn.AutoClose
        IntelliSenseServer.Uninstall()
    End Sub
End Class

I think that Excel Functions are correctly formatted

<ExcelFunction(IsVolatile:=False, IsMacroType:=True, Description:="Somma le celle selezionate in base a più criteri", Name:="SUBTOTALE.SE.CONTA", _
               HelpTopic:="AlanTools.chm!SUBTOTALE.SE", SuppressOverwriteError:=True, Category:="A_Matematiche")> _
        Public Shared Function SubtotalIfCountDue(<ExcelArgument(AllowReference:=True, Description:="Intervallo")> IntervalloConta As Object) As Object

I also installed on excel as add-in the "ExcelDna.IntelliSense64.xll"

I'm using Excel 2019

The issue is:

- when I start writing the formula (i.e. "=SUBTOTALE.SE.CONTA(") nothing is shown for UDF descriptions and for Arguments

- if I loose focus on excel, the help pop-up is shown, but if I continue to write, if there are more than one argument, the pop us still show the help for the first argumento (as if it was frozen)

This is weird..

Do you have any clue?

Thanks

Alberto

[Govert van Drimmelen]

That's a pretty old version of the IntelliSense library. The current one is version 1.1.0 and should work fine on 64-bit Excel.

-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 post to this group, send email to exce...@googlegroups.com.
Visit this group at https://groups.google.com/group/exceldna.
For more options, visit https://groups.google.com/d/optout.

[Alberto Ghiglia]

Hi Givert

I installed ther 1.1.0 (updated in the project by NuGet) but there is still the same problem

PS. I could not find the ExcelDna.IntelliSense64.xll in the NuGetPackage (so I disinstalled as add-in in Excel but still the same result)

Thanks

Alberto

[Govert van Drimmelen]

You need to download ExcelDna.IntelliSense64.xll from https://github.com/Excel-DNA/IntelliSense/releases

 

It’s easier to test with the alone-standing .xll than with the embedded ExcelDna.IntelliSense.dll library that is installed when you get the NuGet package.

Once the alone-standing one works well, you can consider trying the embedded .dll again.

 

-Govert

--

[Alberto Ghiglia]

Done..

..but the error is still the same..

Is it possible that it is Excel 2019?

What can I do else?

Thanks

Alberto

[Govert van Drimmelen]

No – I don’t think it can be Excel 2019, as this is just a version of Excel 2016 / Excel 365 that is frozen in time – nothing special about Excel 2019.04.09

 

We could arrange for a paid-for support session for me to have a look.

For this you can email me directly at gov...@icon.co.za.

 

-Govert

 

 

From: exce...@googlegroups.com <exce...@googlegroups.com> On Behalf Of Alberto Ghiglia
Sent: 9 April 2019 10:35
To: Excel-DNA <exce...@googlegroups.com>
Subject: Re: [ExcelDna] Intellisens for Excel x64 (Excel 2019)

 

Done..

--