What's New in Release 7.0.6
XLL+ 7.0.6 is a full release, which replaces all earlier versions
of XLL+ 7. You should uninstall any earlier versions of XLL+ 7, including XLL+
7.0.4, before you can install this release. It contains the following enhancements and fixes:
- E00258 NEW - Visual Studio 2013
- A new version has been released which supports Visual Studio 2013.
- E00250 NEW - CXlMenu::GetCallingMenu under Excel 2007
- This method can return wrong results when called under Excel 2007 (Excel 12). This is due to an as yet unresolved bug in that version of Excel, which has been fixed in later versions. A new method CXlMenu::GetCallingMenuItemPosition has been added to the CXlMenu class, which works around the bug, and returns correct results under all Excel versions.
- E00251 NEW - WorkbookAfterSave and AfterCalculate events
- Two new COM event handlers have been added to the library, to handle the WorkbookAfterSave and AfterCalculate events, introduced in Excel 2010. These event handlers will have no effect under earlier versions of Excel.
- E00252 NEW - Shared object handles
- Object handles created using the non-RTD handle mechanisms (StringHandle, NumericHandle etc) can be shared between different add-ins. They can be created in one XLL and consumed in a separate XLL, by using the new HandleCache import and export manager mechanism.
- E00253 NEW - Using object handles in macros
- A new macro function (MonteCarlo2.InspectHandle) has been added to the MonteCarlo2 sample project, to show how to use object handles from macro functions.
- E00254 NEW - Function publishing filter
- A new class (CXllFunctionFilter) is included, which allows the developer full control over which functions are published in an XLL, and which are suppressed. Two example projects are provided to illustrate the use of the filter.
- E00255 NEW - Handles for classes with namespaces and templates
- It is now possible to create handles for objects that have namespaces in the class name or that are the result of templates. See the StringHandleDemo and RtdHandleDemo samples for examples of this use.
- E00256 NEW - CXllApp::GetRibbonCallbackFunctionName and CXllApp::GetObserverFunctionName
- Two new methods for CXllApp expose the published names of the framework-generated add-in functions.
- E00257 NEW - Accurate conversion for numerics to strings
- If numeric cells were converted automatically to strings as part of a generated input conversion, rounding in XLL+ 6.0 to XLL+ 7.0.4 was to 6 decimal places. A new method CXllApp::SetNumericToStringConversionMethod() has been provided which emulates the behavior of XLL+ 5 and earlier versions, thereby offering the same conversion accuracy as Excel itself.
- F00160 FIX - Two-dimensional input arrays containing empty cells can cause an input error
- The conversion of two-dimensional input arrays can return an error when some empty cells are contained within the array and at its boundaries. This behavior has been fixed.
- F00161 FIX - StringHandles
- Certain invalid string handles could cause the StringHandles extension to crash when they were decoded. This behavior has been fixed.
- F00162 FIX - CXlOper::AllocArray for a zero-size array
- CXlOper::AllocArray caused run-time errors if a zero-size array was allocated. This behavior has been fixed, and an exception is thrown, resulting in a returned value of #VALUE!
- F00163 FIX - Signing problem with on-line help
- In XLL+ 7.0.4 for Visual Studio 2010 and above, a problem occurred when installing the on-line help integrated into Visual Studio. This was due to a problem with the certificate used to sign the help. The problem has been resolved.
Release 7.0 contained many new features, including:
- 64-bit libraries
-
XLL+ now creates both 32-bit and 64-bit builds of XLL add-ins, so that you can
now provide your add-ins to users of Excel 2010 64-bit edition.
Also, all the XLL+ redistributable run-time servers are provided in both 32-bit
and 64-bit formats.
- Queued asynchonous functions
-
XLL+ now supports the new Excel 2010 asynchronous execution feature. This can
greatly improve the efficiency of thread-safe functions that contend for a
shared resource (such as a database or a data feed).
- Ribbon support
-
XLL+ 7 provides full support for the Office Ribbon, managing all the COM
interface issues, and routing the ribbon messages and events to a C++
event-handler function in your code.
See What's new in XLL+
7.0 for full details.