Adding new operator for duplicate-conditional formatting.

1 files changed, 120 insertions, 0 deletions

diff --git a/offapi/com/sun/star/sheet/ConditionOperator2.idl b/offapi/com/sun/star/sheet/ConditionOperator2.idl
new file mode 100644
index 000000000000..5092bb353487
--- /dev/null
+++ b/offapi/com/sun/star/sheet/ConditionOperator2.idl
@@ -0,0 +1,120 @@
+/*
+ * Version: MPL 1.1 / GPLv3+ / LGPLv3+
+ *
+ * The contents of this file are subject to the Mozilla Public License Version
+ * 1.1 (the "License"); you may not use this file except in compliance with
+ * the License. You may obtain a copy of the License at
+ * http://www.mozilla.org/MPL/
+ *
+ * Software distributed under the License is distributed on an "AS IS" basis,
+ * WITHOUT WARRANTY OF ANY KIND, either express or implied. See the License
+ * for the specific language governing rights and limitations under the
+ * License.
+ *
+ * The Initial Developer of the Original Code is
+ *                       Novell, Inc.
+ *
+ * Portions created by the Initial Developer are Copyright (C) 2011 the
+ * Initial Developer. All Rights Reserved.
+ *
+ * Contributor(s): Muthu Subramanian <sumuthu@novell.com>
+ *
+ * Alternatively, the contents of this file may be used under the terms of
+ * either the GNU General Public License Version 3 or later (the "GPLv3+"), or
+ * the GNU Lesser General Public License Version 3 or later (the "LGPLv3+"),
+ * in which case the provisions of the GPLv3+ or the LGPLv3+ are applicable
+ * instead of those above.
+ */
+
+#ifndef __com_sun_star_sheet_ConditionOperator2_idl__
+#define __com_sun_star_sheet_ConditionOperator2_idl__
+
+//=============================================================================
+
+module com {  module sun {  module star {  module sheet {
+
+//=============================================================================
+
+/** is used to specify the type of <type>XSheetCondition2</type>.
+ */
+constants ConditionOperator2
+{
+    //-------------------------------------------------------------------------
+
+    /** no condition is specified.
+     */
+    const long NONE = 0;
+
+    //-------------------------------------------------------------------------
+
+    /** value has to be equal to the specified value.
+     */
+    const long EQUAL = 1;
+
+    //-------------------------------------------------------------------------
+
+    /** the value must not be equal to the specified value.
+     */
+    const long NOT_EQUAL = 2;
+
+    //-------------------------------------------------------------------------
+
+    /** the value has to be greater than the specified value.
+     */
+    const long GREATER = 3;
+
+    //-------------------------------------------------------------------------
+
+    /** the value has to be greater than or equal to the specified value.
+     */
+    const long GREATER_EQUAL = 4;
+
+    //-------------------------------------------------------------------------
+
+    /** the value has to be less than the specified value.
+     */
+    const long LESS = 5;
+
+    //-------------------------------------------------------------------------
+
+    /** the value has to be less than or equal to the specified value.
+     */
+    const long LESS_EQUAL = 6;
+
+    //-------------------------------------------------------------------------
+
+    /** the value has to be between the two specified values.
+     */
+    const long BETWEEN = 7;
+
+    //-------------------------------------------------------------------------
+
+    /** the value has to be outside of the two specified values.
+     */
+    const long NOT_BETWEEN = 8;
+
+    //-------------------------------------------------------------------------
+
+    /** the specified formula has to give a non-zero result.
+     */
+    const long FORMULA = 9;
+
+    //-------------------------------------------------------------------------
+
+    /** Conditionally format duplicate values
+     */
+    const long DUPLICATE = 10;
+
+    //-------------------------------------------------------------------------
+
+    /** Conditionally format non-duplicate values
+     */
+    const long NOT_DUPLICATE = 11;
+};
+
+//=============================================================================
+
+}; }; }; };
+
+#endif
+