Specifies whether custom function definitions should be replaced with the corresponding calculated values when exporting a document.
A CustomFunctionExportMode enumerator value.
You can access this nested property as listed below:
|Library||Object Type||Path to CustomFunctionExportMode|
|Office File API||DocumentOptions|
Custom functions are not saved in a workbook. So, if a worksheet that contains a custom function is loaded in a workbook that is not aware of the function (or in MS Excel), the “#NAME!” error is displayed after the cell containing the function has been re-evaluated. To avoid this situation, you can set the CustomFunctionExportMode option to CustomFunctionExportMode.CalculatedValue and custom functions will be converted to their calculated values when saving a document.