FormulaParser Service Reference

import"FormulaParser.idl";

Inheritance diagram for FormulaParser:

Included Services
service	com::sun::star::beans::PropertySet

Exported Interfaces
interface	XFormulaParser
Exported Interfaces inherited from PropertySet
interface	com::sun::star::beans::XPropertySet
interface	com::sun::star::beans::XFastPropertySet
interface	com::sun::star::beans::XMultiPropertySet
interface	com::sun::star::beans::XPropertyAccess
interface	com::sun::star::beans::XPropertyState

Public Attributes
boolean	CompileEnglish
	specifies whether to use English parser and formatter. More...
short	FormulaConvention
	specifies which address reference style convention to use when parsing a formula string. More...
boolean	IgnoreLeadingSpaces
string	ParameterSeparator
sequence< FormulaOpCodeMapEntry >	OpCodeMap
	contains the complete mapping of names to op-codes. More...
sequence< ExternalLinkInfo >	ExternalLinks
	contains a list of external links referenced in formulas. More...
boolean	RefConventionChartOOXML
	specifies that use special ooxml chart syntax in case of OOXML reference convention, when parsing a formula string. More...

Additional Inherited Members
Public Member Functions inherited from XPropertySet
com::sun::star::beans::XPropertySetInfo	getPropertySetInfo ()
void	setPropertyValue ([in] string aPropertyName, [in] any aValue) raises ( com::sun::star::beans::UnknownPropertyException, com::sun::star::beans::PropertyVetoException, com::sun::star::lang::IllegalArgumentException, com::sun::star::lang::WrappedTargetException )
	sets the value of the property with the specified name. More...
any	getPropertyValue ([in] string PropertyName) raises ( com::sun::star::beans::UnknownPropertyException, com::sun::star::lang::WrappedTargetException )
void	addPropertyChangeListener ([in] string aPropertyName, [in] com::sun::star::beans::XPropertyChangeListener xListener) raises ( com::sun::star::beans::UnknownPropertyException, com::sun::star::lang::WrappedTargetException )
	adds an XPropertyChangeListener to the specified property. More...
void	removePropertyChangeListener ([in] string aPropertyName, [in] com::sun::star::beans::XPropertyChangeListener aListener) raises ( com::sun::star::beans::UnknownPropertyException, com::sun::star::lang::WrappedTargetException )
	removes an XPropertyChangeListener from the listener list. More...
void	addVetoableChangeListener ([in] string PropertyName, [in] com::sun::star::beans::XVetoableChangeListener aListener) raises ( com::sun::star::beans::UnknownPropertyException, com::sun::star::lang::WrappedTargetException )
	adds an XVetoableChangeListener to the specified property with the name PropertyName. More...
void	removeVetoableChangeListener ([in] string PropertyName, [in] com::sun::star::beans::XVetoableChangeListener aListener) raises ( com::sun::star::beans::UnknownPropertyException, com::sun::star::lang::WrappedTargetException )
	removes an XVetoableChangeListener from the listener list. More...
Public Member Functions inherited from XInterface
any	queryInterface ([in] type aType)
	queries for a new interface to an existing UNO object. More...
void	acquire ()
	increases the reference counter by one. More...
void	release ()
	decreases the reference counter by one. More...
Public Member Functions inherited from XFormulaParser
sequence< FormulaToken >	parseFormula ([in] string aFormula, [in] ::com::sun::star::table::CellAddress aReferencePos)
	parses a formula into a sequence of tokens. More...
string	printFormula ([in] sequence< FormulaToken > aTokens, [in] ::com::sun::star::table::CellAddress aReferencePos)
	converts a formula into a string. More...
Protected Member Functions inherited from XFastPropertySet
void	setFastPropertyValue ([in] long nHandle, [in] any aValue) raises ( com::sun::star::beans::UnknownPropertyException, com::sun::star::beans::PropertyVetoException, com::sun::star::lang::IllegalArgumentException, com::sun::star::lang::WrappedTargetException )
	sets the value to the property with the specified name. More...
any	getFastPropertyValue ([in] long nHandle) raises ( com::sun::star::beans::UnknownPropertyException, com::sun::star::lang::WrappedTargetException )
Protected Member Functions inherited from XMultiPropertySet
com::sun::star::beans::XPropertySetInfo	getPropertySetInfo ()
void	setPropertyValues ([in] sequence< string > aPropertyNames, [in] sequence< any > aValues) raises ( com::sun::star::beans::PropertyVetoException, com::sun::star::lang::IllegalArgumentException, com::sun::star::lang::WrappedTargetException )
	sets the values to the properties with the specified names. More...
sequence< any >	getPropertyValues ([in] sequence< string > aPropertyNames)
void	addPropertiesChangeListener ([in] sequence< string > aPropertyNames, [in] com::sun::star::beans::XPropertiesChangeListener xListener)
	adds an XPropertiesChangeListener to the specified property with the specified names. More...
void	removePropertiesChangeListener ([in] com::sun::star::beans::XPropertiesChangeListener xListener)
	removes an XPropertiesChangeListener from the listener list. More...
void	firePropertiesChangeEvent ([in] sequence< string > aPropertyNames, [in] com::sun::star::beans::XPropertiesChangeListener xListener)
	fires a sequence of PropertyChangeEvents to the specified listener. More...
Protected Member Functions inherited from XPropertyAccess
sequence< com::sun::star::beans::PropertyValue >	getPropertyValues ()
void	setPropertyValues ([in] sequence< com::sun::star::beans::PropertyValue > aProps) raises ( com::sun::star::beans::UnknownPropertyException, com::sun::star::beans::PropertyVetoException, com::sun::star::lang::IllegalArgumentException, com::sun::star::lang::WrappedTargetException )
	sets the values of given properties. More...
Protected Member Functions inherited from XPropertyState
com::sun::star::beans::PropertyState	getPropertyState ([in] string PropertyName) raises ( com::sun::star::beans::UnknownPropertyException )
sequence< com::sun::star::beans::PropertyState >	getPropertyStates ([in] sequence< string > aPropertyName) raises ( com::sun::star::beans::UnknownPropertyException )
void	setPropertyToDefault ([in] string PropertyName) raises ( com::sun::star::beans::UnknownPropertyException )
	Sets the property to default value. More...
any	getPropertyDefault ([in] string aPropertyName) raises ( com::sun::star::beans::UnknownPropertyException, com::sun::star::lang::WrappedTargetException )

Exported Interfaces

com::sun::star::beans::PropertySet

service com::sun::star::beans::PropertySet

Exported Interfaces

XFormulaParser

interface XFormulaParser

Member Data Documentation

CompileEnglish

boolean CompileEnglish

property

specifies 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.

ExternalLinks

sequence< ExternalLinkInfo > ExternalLinks

property

contains a 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.

Since

OOo 3.1

FormulaConvention

short FormulaConvention

property

specifies which address reference style convention to use when parsing a formula string.

See also

AddressConvention

IgnoreLeadingSpaces

boolean IgnoreLeadingSpaces

property

OpCodeMap

sequence< FormulaOpCodeMapEntry > OpCodeMap

property

contains the complete mapping of names to op-codes.

Names and symbols not defined here lead to a parser/print error.

ParameterSeparator

string ParameterSeparator

property

RefConventionChartOOXML

boolean RefConventionChartOOXML

property

specifies that use special ooxml chart syntax in case of OOXML reference convention, when parsing a formula string.

Special syntax like: [0]!GlobalNamedRange, LocalSheet!LocalNamedRange

Since

LibreOffice 7.3

---

The documentation for this service was generated from the following file:

• com/sun/star/sheet/FormulaParser.idl