Language

The Free and Open Productivity Suite
Released: Apache OpenOffice 4.1.15

API

SDK

Tips ‘n’ Tricks

Miscellaneous

Overview Module Use Devguide Index
Methods' Summary Attributes' Summary Methods' Details Attributes' Details

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

interface XSheetConditionalEntries
Base Interfaces
XSheetConditionalEntries
┗ ::com::sun::star::container::XIndexAccess
   ┗ ::com::sun::star::container::XElementAccess
::com::sun::star::container::XIndexAccess
(referenced interface's summary:)
provides access to the elements of a collection through an index.
Description
provides methods to add and remove conditions of a conditional format.
See also
TableConditionalFormat, TableConditionalEntry
Developers Guide
Spreadsheets - Conditional Formats
Methods' Summary
addNew adds a conditional entry to the format.  
removeByIndex removes a conditional entry from the format.  
clear clears all condition entries.  
Methods' Details
addNew
void
addNew( [in] sequence< ::com::sun::star::beans::PropertyValue >  aConditionalEntry );
Description
adds a conditional entry to the format.

Supported properties are:

ConditionOperator Operator
contains the operation to perform for this condition.
string Formula1
contains the value or formula for the operation.
string Formula2
contains the second value or formula for the operation (used with ConditionOperator::BETWEEN or ConditionOperator::NOT_BETWEEN operations).
::com::sun::star::table::CellAddress SourcePosition
contains the base address for relative cell references in formulas.
string StyleName
contains the name of the cell style used by this condition.
See also
TableConditionalFormat
removeByIndex
void
removeByIndex( [in] long  nIndex );
Description
removes a conditional entry from the format.
clear
void
clear();
Description
clears all condition entries.
Top of Page

Copyright © 2013, The Apache Software Foundation, Licensed under the Apache License, Version 2.0. Apache, the Apache feather logo, Apache OpenOffice and OpenOffice.org are trademarks of The Apache Software Foundation. Other names may be trademarks of their respective owners.

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.