S
SBT
We are creating a math package to Excel via an XLL.
To test the output of the XLL our build agent runs a series of tests, some
of which loads Excel with our XLL and then itterates over each sheet, calling
calculate on each in the process. Finally we compare our results with a
static set of data - thus ensuring stability of the XLL.
The problem is that with SOME sheets, the results when we use
Sheet.Calculate differ, yet when we from when we manually iterate over the
sheets and use Shift+F9 they add up perfectly.
The sheets all run with manual calculation, and the other setting in the
Calculate tab are also the same in both instances. All functions use only
parameters as input (no referencing specific cells from within the function)
Also, simply using CalculateFullRebuild will not work either.
To test the output of the XLL our build agent runs a series of tests, some
of which loads Excel with our XLL and then itterates over each sheet, calling
calculate on each in the process. Finally we compare our results with a
static set of data - thus ensuring stability of the XLL.
The problem is that with SOME sheets, the results when we use
Sheet.Calculate differ, yet when we from when we manually iterate over the
sheets and use Shift+F9 they add up perfectly.
The sheets all run with manual calculation, and the other setting in the
Calculate tab are also the same in both instances. All functions use only
parameters as input (no referencing specific cells from within the function)
Also, simply using CalculateFullRebuild will not work either.