Demonstrates the use of the CXlOper class, in a useful worksheet function that constructs and manipulates arrays
This sample add-in demonstrates the use of the CXlOper class.
The TFOLD function in the add-in is a very useful utility for creating arrays of cells from individual cells and ranges in worksheets. If you want to use an add-in function that expects arguments to be in a certain shape, you can use TFOLD to create a correctly shaped array on the fly, instead of changing your worksheet to suit the demands of the function.
The TFOLD.XLS demo workbook shows TFOLD and TFOLDT is use.
A very powerful use of TFOLDT is also shown in LabelledArgs.xls, which is part of the LabelledArgs sample.
Under Visual Studio .NET 2003, it was necessary to switch off the
/Ob2 under the Release configuration,
and replace it with
/Ob2 optimization causes runtime exceptions.
This compiler behavior was fixed for Visual Studio 2005, 2008 and 2010,
and the standard optimization settings (
/O2) can be used.
Each sample project is located in a sub-directory of the Samples directory of the XLL+ installation. To use the sample project, open the solution file TFold.sln or the project file TFold.vcproj.
You can enable debugging under Excel by using the Setup Debugging command in the XLL+ ToolWindow.
When delivered, the help files are excluded from the build.
You can enable the help build by selecting the files
in the Solution Explorer,
and using the right-click menu to view Properties.
Select the page "Configuration Properties/General" and
set the "Excluded from build" property to "No".
See Generating help
in the User Guide for more information.