Language

The Free and Open Productivity Suite
Released: Apache OpenOffice 4.1.15

API

SDK

Tips ‘n’ Tricks

Miscellaneous


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

interface XSheetCondition
Description
provides methods to access the settings of a condition in a conditional format or data validation.
See also
TableConditionalEntry, TableValidation

Methods' Summary
getOperator returns the operator in the condition.  
setOperator sets the operator in the condition.  
getFormula1 returns either the comparison value, which is used in the condition, or the first value if two values are needed for the operator.  
setFormula1 sets either the comparison value, which is used in the condition, or the first value if two values are needed for the operator.  
getFormula2 if two values are needed for the operator, this method returns the second one.  
setFormula2 if two values are needed for the operator, this method sets the second one.  
getSourcePosition returns the position in the document which is used as a base for relative references in the formulas.  
setSourcePosition sets the position in the document which is used as a base for relative references in the formulas.  
Methods' Details
getOperator
ConditionOperator
getOperator();

Description
returns the operator in the condition.
setOperator
void
setOperator( [in] ConditionOperator  nOperator );

Description
sets the operator in the condition.
getFormula1
string
getFormula1();

Description
returns either the comparison value, which is used in the condition, or the first value if two values are needed for the operator.
Returns
a formula, a numeric constant, or a string constant in quotes.
setFormula1
void
setFormula1( [in] string  aFormula1 );

Description
sets either the comparison value, which is used in the condition, or the first value if two values are needed for the operator.
Parameter aFormula1
a formula, a numeric constant, or a string constant in quotes.
getFormula2
string
getFormula2();

Description
if two values are needed for the operator, this method returns the second one.
Returns
a formula, a numeric constant, or a string constant in quotes.
setFormula2
void
setFormula2( [in] string  aFormula2 );

Description
if two values are needed for the operator, this method sets the second one.
Parameter aFormula2
a formula, a numeric constant, or a string constant in quotes.
getSourcePosition
::com::sun::star::table::CellAddress
getSourcePosition();

Description
returns the position in the document which is used as a base for relative references in the formulas.
setSourcePosition
void
setSourcePosition( [in] ::com::sun::star::table::CellAddress  aSourcePosition );

Description
sets the position in the document which is used as a base for relative references in the formulas.
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.