Skip to content

Excel-DNA IntelliSense v1.4.0

Compare
Choose a tag to compare
@govert govert released this 26 Oct 09:22
· 74 commits to master since this release

The Excel-DNA IntelliSense add-in provides on-sheet IntelliSense for UDFs from Excel-DNA add-ins, VBA projects and other .xll-based add-ins.

The IntelliSense extension can run in two display modes:

  • Independent mode, using the standalone ExcelDna.IntelliSense.xll add-in from this release.
  • Integrated mode, where the IntelliSense library ExcelDna.IntelliSense.dll is provided as part of another Excel-DNA add-in - this library can be added to a project via the ExcelDna.IntelliSense package.

This version of the IntelliSense extension is supported on:

  • Excel 2010 and later (use ExcelDna.IntelliSense64.xll for the 64-bit version of Excel)
  • Windows 7 and later

On-sheet IntelliSense is automatically enabled for Excel-DNA add-ins built with v0.32 or later, and will show the same descriptions as in the Function Arguments dialog (extracted from ExcelFunction, ExcelArgument and Description attributes). Options to provide descriptions for VBA functions and other .xll add-ins are described in the Getting Started page.

Please ask questions and provide feedback via the Excel-DNA Google group.

  • [v1.0.2 removes the dependency on the UI Automation libraries, to address problems introduced by the November 2016 update to Excel 2016.]
  • [v1.0.3 fixes a minor window tracking bug.]
  • [v1.0.4 fixes an occasional one character lag, and an occasional crash reported under Excel 2010.]
  • [v1.0.5 has some workarounds for slow loading of the IntelliSense server.]
  • [v1.0.6 fixes an error that popped up when the Excel function list window changed unexpectedly.]
  • [v1.0.7 adapts to Windows or Excel updates that have interfered with the formula state tracking, adds support for the variable parameters pattern and fixed various bugs.]
  • [v1.0.8 fixes a minor layout bug in the help link location.]
  • [v1.0.9 fixes a bug where the Explorer.exe would crash when 64-bit Excel with IntelliSense is running.]
  • [v1.1.0 fixes problems introduced in v1.0.9 when the add-in is unloaded or reloaded. Changes required calls when integrating into an Excel-DNA add-in to IntelliSenseServer.Install (in AutoOpen) and Uninstall (in AutoClose).]
  • [v1.3.0 fixes some minor bugs, is a strong-named version of the extension assembly, and aligns the IntelliSense with extension with the Excel-DNA 1.1 release]
  • [v1.4.0 improves stability by addressing an API threading pattern that caused Excel to crash occasionally - thanks @gmichaud !]