aspose.cells

aspose.cells

Class FormulaParseOptions

Represents options when parsing formula.

Constructor Summary
FormulaParseOptions()
 
Property Getters/Setters Summary
functiongetCheckAddIn()
function
setCheckAddIn(value)
           Whether check addins in existing external links of current workbook for user defined function without external link. Default is true(if user defined function matches one addin in existing external links, then take it as the addin).
functiongetCustomFunctionDefinition()
function
setCustomFunctionDefinition(value)
           Definition for parsing custom functions.
functiongetLocaleDependent()
function
setLocaleDependent(value)
           Whether the formula is locale formatted. Default is false.
functiongetParse()
function
setParse(value)
           Whether parse given formula. Default is true. If it is false, then given formula string will be kept as it is for the cell until user call other methods to parse them or parsed formula data is required by other operations such as calculating formulas.
functiongetR1C1Style()
function
setR1C1Style(value)
           Whether the formula is R1C1 reference style. Default is false.
 

    • Constructor Detail

      • FormulaParseOptions

        function FormulaParseOptions()

    • Property Getters/Setters Detail

      • getLocaleDependent/setLocaleDependent : boolean 

        function getLocaleDependent() / function setLocaleDependent(value)
        Whether the formula is locale formatted. Default is false.

      • getR1C1Style/setR1C1Style : boolean 

        function getR1C1Style() / function setR1C1Style(value)
        Whether the formula is R1C1 reference style. Default is false.

      • getCheckAddIn/setCheckAddIn : boolean 

        function getCheckAddIn() / function setCheckAddIn(value)
        Whether check addins in existing external links of current workbook for user defined function without external link. Default is true(if user defined function matches one addin in existing external links, then take it as the addin).

      • getParse/setParse : boolean 

        function getParse() / function setParse(value)
        Whether parse given formula. Default is true. If it is false, then given formula string will be kept as it is for the cell until user call other methods to parse them or parsed formula data is required by other operations such as calculating formulas.

      • getCustomFunctionDefinition/setCustomFunctionDefinition : CustomFunctionDefinition 

        function getCustomFunctionDefinition() / function setCustomFunctionDefinition(value)
        Definition for parsing custom functions. For some special requirements, such as when calculating custom function in user's custom engine, some parameters of it need to be caculated in array mode, using this property can mark those parameters as array mode when parsing the formula. Otherwise user needs to update those custom functions later by Workbook.updateCustomFunctionDefinition(com.aspose.cells.CustomFunctionDefinition) to get the same result.