/************************************************************************* * * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. * * Copyright 2000, 2010 Oracle and/or its affiliates. * * OpenOffice.org - a multi-platform office productivity suite * * This file is part of OpenOffice.org. * * OpenOffice.org is free software: you can redistribute it and/or modify * it under the terms of the GNU Lesser General Public License version 3 * only, as published by the Free Software Foundation. * * OpenOffice.org is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * GNU Lesser General Public License version 3 for more details * (a copy is included in the LICENSE file that accompanied this code). * * You should have received a copy of the GNU Lesser General Public License * version 3 along with OpenOffice.org. If not, see * * for a copy of the LGPLv3 License. * ************************************************************************/ #ifndef __com_sun_star_sheet_XSheetConditionalEntries_idl__ #define __com_sun_star_sheet_XSheetConditionalEntries_idl__ #ifndef __com_sun_star_container_XIndexAccess_idl__ #include #endif #ifndef __com_sun_star_beans_PropertyValue_idl__ #include #endif //============================================================================= module com { module sun { module star { module sheet { //============================================================================= /** provides methods to add and remove conditions of a conditional format. @see com::sun::star::sheet::TableConditionalFormat @see com::sun::star::sheet::TableConditionalEntry */ published interface XSheetConditionalEntries: com::sun::star::container::XIndexAccess { //------------------------------------------------------------------------- /** 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).
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 com::sun::star::sheet::TableConditionalFormat */ void addNew( [in] sequence< com::sun::star::beans::PropertyValue > aConditionalEntry ); //------------------------------------------------------------------------- /** removes a conditional entry from the format. */ void removeByIndex( [in] long nIndex ); //------------------------------------------------------------------------- /** clears all condition entries. */ void clear(); }; //============================================================================= }; }; }; }; #endif