Normally, the actual value of a formula is extracted from an Excel spreadsheet; the formula from which the value is derived is not included in the output. However, KeyView enables you to include the value as well as the formula in the output. For example, if you configure Filter to extract the formula and the formula value, the output might look like this:
245 = SUM(B21:B26)
The calculated value from the cell is 245
and the formula from which the value is derived is SUM(B21:B26)
.
To set the extraction option for formulas, add the following lines to the formats.ini
file:
[Options] getformulastring=option
where option
is one of the following:
Option 
Description 


Extract the formula value only. This is the default. If formula extraction is enabled, and you want to return to the default, set this option. 

Extract the formula only. 

Extract the formula and the formula value. 
If a function in a formula is not supported or is invalid, and option 1 or 2 is specified, only the calculated value is extracted. See Supported Microsoft Excel functions for a list of supported functions.
When you enable formula extraction, Filter can extract Microsoft Excel formulas containing the functions listed in Supported Microsoft Excel functions:
Supported Microsoft Excel functions




























































































































