:: com :: sun :: star :: sheet ::

service FormulaParser

Included Services - Summary
::com::sun::star::beans::PropertySet
(referenced entity's summary:)
This is a generic service which should be supported by all servies which have properties.
Exported Interfaces - Summary
XFormulaParser
(referenced entity's summary:)
converts between text and token representations of formulas.
Properties' Summary
::com::sun::star::table::CellAddress
ReferencePosition
 
boolean
CompileEnglish
Whether to use English parser and formatter. Note: When changing this, an already existing OpCodeMap needs to be recreated internally, so for performance reasons set this _before_ setting the OpCodeMap.  
short
FormulaConvention
Specifies which address reference style convention to use when parsing a formula string.  
boolean
IgnoreLeadingSpaces
 
string
ParameterSeparator
 
sequence< FormulaOpCodeMapEntry >
OpCodeMap
The complete mapping of Names to OpCodes. Names and symbols not defined here lead to a parser/print error.  
sequence< ExternalLinkInfo >
ExternalLinks
List of external links referenced in formulas. Use of this property depends on the FormulaConvention in use. It is relevant only for AddressConvention::XL_OOX to map indices to external documents. The sequence must be in the order of indices used. Note that indices are 1-based, the sequence must start with an empty element.  
Included Services - Details
::com::sun::star::beans::PropertySet
(referenced entity's summary:)
This is a generic service which should be supported by all servies which have properties.
Exported Interfaces - Details
XFormulaParser
(referenced entity's summary:)
converts between text and token representations of formulas.
Properties' Details
ReferencePosition
::com::sun::star::table::CellAddress ReferencePosition;
CompileEnglish
boolean CompileEnglish;
Description
Whether to use English parser and formatter. Note: When changing this, an already existing OpCodeMap needs to be recreated internally, so for performance reasons set this _before_ setting the OpCodeMap.
FormulaConvention
short FormulaConvention;
Description
Specifies which address reference style convention to use when parsing a formula string.
IgnoreLeadingSpaces
boolean IgnoreLeadingSpaces;
ParameterSeparator
string ParameterSeparator;
OpCodeMap
sequence< FormulaOpCodeMapEntry > OpCodeMap;
Description
The complete mapping of Names to OpCodes. Names and symbols not defined here lead to a parser/print error.
ExternalLinks
sequence< ExternalLinkInfo > ExternalLinks;
Description
List of external links referenced in formulas. Use of this property depends on the FormulaConvention in use. It is relevant only for AddressConvention::XL_OOX to map indices to external documents. The sequence must be in the order of indices used. Note that indices are 1-based, the sequence must start with an empty element.

 
Top of Page