Spread Windows Forms 15.0
GrapeCity.CalcEngine Assembly / GrapeCity.CalcEngine Namespace / FormulaEngine Class
Properties Methods


In This Topic
    FormulaEngine Class Members
    In This Topic

    The following tables list the members exposed by FormulaEngine.

    Public Properties
     NameDescription
    Public PropertyContextTranslatedColumnCountGets or sets the translated column count of current reference source when we unparse the expression to formula.  
    Public PropertyContextTranslatedRowCountGets or sets the translated row count of current reference source when we unparse the expression to formula.  
    Public PropertyCultureGets the current System.Globalization.CultureInfo object for parsing and unparsing process.  
    Public PropertyIsA1ReferenceGets a value indicating whether the current parsing mode is A1 reference style.  
    Public PropertyIsExportingGets current exporting state of FormulaEngine.  
    Public PropertyIsImportingGet current importing state of this FormulaEngine.  
    Top
    Public Methods
     NameDescription
    Public Methodstatic (Shared in Visual Basic)AddResolverOverloaded. Adds a custom symbol resolver which resolves un-parsed symbols like cell range reference, external reference...  
    Public Methodstatic (Shared in Visual Basic)AppendTableColumnAppends the column name of the structured reference.  
    Public MethodCloneClones the specified expression.  
    Public MethodEnterContextOverloaded. Enters the specified parsing context.  
    Public MethodExitContextExits the latest parsing context and restore the previous parsing context.  
    Public MethodHighlightParses the specified formula text to expression.  
    Public MethodParseParses the specified formula text to expression.  
    Public Methodstatic (Shared in Visual Basic)RemoveResolverOverloaded. Removes a custom symbol resolver which resolves un-parsed symbols like cell range reference, external reference...  
    Public MethodRestoreDefaultCulture  
    Public MethodSetExplicitCulture  
    Public MethodSetLanguagePackageSets the language package.  
    Public MethodStartExportingMark this FormulaEngine as exporting state.  
    Public MethodStartImportingMark this FormulaEngine as importing state.  
    Public MethodStopExporttingUn-mark this FormulaEngine from exporting state.  
    Public MethodStopImportingUn-mark this FormulaEngine from importing state.  
    Public MethodStrictR1C1BoundaryAll unbound ranges will be parsed as #REF! when we parse in R1C1 reference style.  
    Public Methodstatic (Shared in Visual Basic)TryParseA1ReferenceConverts the string representation of a range reference in A1 format its RangeReference equivalent. A return value indicates whether the conversion succeeded or failed.  
    Public Methodstatic (Shared in Visual Basic)TryParseR1C1ReferenceConverts the string representation of a range reference in R1C1 format its RangeReference equivalent. A return value indicates whether the conversion succeeded or failed.  
    Public MethodUnparseOverloaded. Unparses the specified expression to formula text.  
    Public Methodstatic (Shared in Visual Basic)UnparseA1ReferenceOverloaded. Unparses the range reference in A1 reference style.  
    Public Methodstatic (Shared in Visual Basic)UnparseErrorUnparses the specified CalcError value.  
    Public Methodstatic (Shared in Visual Basic)UnparseR1C1ReferenceOverloaded. Unparses the range reference in A1 reference style.  
    Public Methodstatic (Shared in Visual Basic)UnparseReferenceSourceOverloaded. Unparses the specified reference source  
    Public MethodUnstrictR1C1BoundaryStops verifying whether the R1C1 reference is unbound or not.  
    Top
    See Also

    Reference

    FormulaEngine Class
    GrapeCity.CalcEngine Namespace

     

     

    Copyright © 2021 GrapeCity, Inc. All rights reserved.

    Product Support Forum | Print this page