(incubating) | The Free and Open Productivity Suite
Announcing Apache OpenOffice 3.4

Developer's Guide

API

SDK

Tips 'n' Tricks

Miscellaneous

Content for OpenOffice.org version 3.3.

:: 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
OOo3.1

 
Top of Page

Apache Feather

Copyright & License | Privacy | Contact Us

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

Apache OpenOffice is an effort undergoing incubation at The Apache Software Foundation (ASF), sponsored by the Apache Incubator. Incubation is required of all newly accepted projects until a further review indicates that the infrastructure, communications, and decision making process have stabilized in a manner consistent with other successful ASF projects. While incubation status is not necessarily a reflection of the completeness or stability of the code, it does indicate that the project has yet to be fully endorsed by the ASF.