Language

The Free and Open Productivity Suite
Released: Apache OpenOffice 4.1.15

API

SDK

Tips ‘n’ Tricks

Miscellaneous


:: 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
boolean
CompileEnglish
specifies whether to use English parser and formatter.  
short
FormulaConvention
specifies which address reference style convention to use when parsing a formula string.  
boolean
IgnoreLeadingSpaces
 
string
ParameterSeparator
 
sequence< FormulaOpCodeMapEntry >
OpCodeMap
contains the complete mapping of names to op-codes.  
sequence< ExternalLinkInfo >
ExternalLinks
contains a list of external links referenced in formulas.  
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
CompileEnglish
boolean CompileEnglish;
Description
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.

FormulaConvention
short FormulaConvention;
Description
specifies which address reference style convention to use when parsing a formula string.
See also
AddressConvention
IgnoreLeadingSpaces
boolean IgnoreLeadingSpaces;
ParameterSeparator
string ParameterSeparator;
OpCodeMap
sequence< FormulaOpCodeMapEntry > OpCodeMap;
Description
contains the complete mapping of names to op-codes.

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

ExternalLinks
sequence< ExternalLinkInfo > ExternalLinks;
Description
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

 
Top of Page

Apache Software Foundation

Copyright & License | Privacy | Contact Us | Donate | Thanks

Apache, OpenOffice, OpenOffice.org and the seagull logo are registered trademarks of The Apache Software Foundation. The Apache feather logo is a trademark of The Apache Software Foundation. Other names appearing on the site may be trademarks of their respective owners.