Author: wanglf
Date: Wed Oct 24 10:29:46 2012
New Revision: 1401611
URL: http://svn.apache.org/viewvc?rev=1401611&view=rev
Log:
#121108 - [testUNO patch]validity test script include Criterial/Error
Alert/Input Help
patch by Terry Yang, reviewed by WangLiFeng
Added:
incubator/ooo/trunk/test/testuno/source/fvt/uno/sc/data/ValidityTypeTest.java
Added:
incubator/ooo/trunk/test/testuno/source/fvt/uno/sc/data/ValidityTypeTest.java
URL:
http://svn.apache.org/viewvc/incubator/ooo/trunk/test/testuno/source/fvt/uno/sc/data/ValidityTypeTest.java?rev=1401611&view=auto
==============================================================================
---
incubator/ooo/trunk/test/testuno/source/fvt/uno/sc/data/ValidityTypeTest.java
(added)
+++
incubator/ooo/trunk/test/testuno/source/fvt/uno/sc/data/ValidityTypeTest.java
Wed Oct 24 10:29:46 2012
@@ -0,0 +1,247 @@
+/**************************************************************
+ *
+ * Licensed to the Apache Software Foundation (ASF) under one
+ * or more contributor license agreements. See the NOTICE file
+ * distributed with this work for additional information
+ * regarding copyright ownership. The ASF licenses this file
+ * to you under the Apache License, Version 2.0 (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.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing,
+ * software distributed under the License is distributed on an
+ * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+ * KIND, either express or implied. See the License for the
+ * specific language governing permissions and limitations
+ * under the License.
+ *
+ *************************************************************/
+package fvt.uno.sc.data;
+
+import static org.junit.Assert.*;
+
+import java.util.Arrays;
+import java.util.Collection;
+
+import org.junit.After;
+import org.junit.AfterClass;
+import org.junit.Before;
+import org.junit.BeforeClass;
+import org.junit.Test;
+import org.junit.runner.RunWith;
+import org.junit.runners.Parameterized;
+import org.junit.runners.Parameterized.Parameters;
+import org.openoffice.test.uno.UnoApp;
+
+import testlib.uno.SCUtil;
+import testlib.uno.TestUtil;
+
+import com.sun.star.beans.XPropertySet;
+import com.sun.star.lang.XComponent;
+import com.sun.star.sheet.ConditionOperator;
+import com.sun.star.sheet.GeneralFunction;
+import com.sun.star.sheet.ValidationAlertStyle;
+import com.sun.star.sheet.ValidationType;
+import com.sun.star.sheet.XSheetCondition;
+import com.sun.star.sheet.XSpreadsheet;
+import com.sun.star.sheet.XSpreadsheetDocument;
+import com.sun.star.table.XCellRange;
+import com.sun.star.uno.Enum;
+import com.sun.star.uno.UnoRuntime;
+
+@RunWith(value = Parameterized.class)
+public class ValidityTypeTest {
+ private static final UnoApp app = new UnoApp();
+
+ UnoApp unoApp = new UnoApp();
+ XSpreadsheetDocument scDocument = null;
+ XComponent scComponent = null;
+
+ private Enum validationtype;
+
+ private boolean ignoreBlankCells;
+
+ private Enum validationAlertStyle;
+
+ private boolean showInputMessage;
+
+ private boolean showErrorMessage;
+
+ private Enum conditionOperator;
+
+ private String formula1;
+
+ private String formula2;
+
+ private String extName;
+
+ @Parameters
+ public static Collection<Object[]> data() throws Exception {
+ return Arrays
+ .asList(new Object[][] {
+ { ValidationType.ANY, false,
ValidationAlertStyle.STOP,
+ false, false,
ConditionOperator.EQUAL, "0",
+ "5", "xls" },
+ //Custom type
is not exist in GUI so remove this
+ // { ValidationType.CUSTOM,
true,
+ // ValidationAlertStyle.INFO,
false, true,
+ // ConditionOperator.EQUAL,
"0", "5", "ods"},
+ { ValidationType.DATE, false,
+
ValidationAlertStyle.MACRO, false, false,
+
ConditionOperator.EQUAL, "0", "0", "ods" },
+ { ValidationType.DECIMAL, true,
+
ValidationAlertStyle.WARNING, false, true,
+
ConditionOperator.BETWEEN, "0", "5", "ods" },
+ { ValidationType.LIST, false,
+
ValidationAlertStyle.STOP, true, false,
+
ConditionOperator.EQUAL, "\"Joe\";\"Jane\"",
+ "0", "ods" },
+ { ValidationType.LIST, false,
+
ValidationAlertStyle.STOP, true, false,
+
ConditionOperator.EQUAL, "a;b;c", "0", "ods" },
+ { ValidationType.TEXT_LEN, true,
+
ValidationAlertStyle.INFO, true, true,
+
ConditionOperator.GREATER, "0", "5", "xls" },
+ { ValidationType.TIME, false,
+
ValidationAlertStyle.STOP, true, false,
+
ConditionOperator.GREATER_EQUAL, "0", "5",
+ "xls" },
+ { ValidationType.WHOLE, true,
+
ValidationAlertStyle.WARNING, true, true,
+
ConditionOperator.LESS, "0", "5", "xls" },
+ { ValidationType.DECIMAL, false,
+
ValidationAlertStyle.STOP, true, false,
+
ConditionOperator.LESS_EQUAL, "0", "5", "xls" },
+ { ValidationType.WHOLE, true,
+
ValidationAlertStyle.INFO, false, true,
+
ConditionOperator.NOT_BETWEEN, "0", "5", "ods" },
+ { ValidationType.TEXT_LEN,
false,
+
ValidationAlertStyle.MACRO, true, false,
+
ConditionOperator.NOT_EQUAL, "5", "0", "ods" }, });
+ }
+
+ @Before
+ public void setUpDocument() throws Exception {
+ unoApp.start();
+ }
+
+ @After
+ public void tearDownDocument() {
+ unoApp.close();
+ unoApp.closeDocument(scComponent);
+
+ }
+
+ @BeforeClass
+ public static void setUpConnection() throws Exception {
+
+ }
+
+ @AfterClass
+ public static void tearDownConnection() throws InterruptedException,
+ Exception {
+
+ }
+
+ public ValidityTypeTest(Enum validationtype, boolean ignoreBlankCells,
+ Enum validationAlertStyle, boolean showInputMessage,
+ boolean showErrorMessage, Enum conditionOperator,
String formula1,
+ String formula2, String extName) {
+ this.validationtype = validationtype;
+ this.ignoreBlankCells = ignoreBlankCells;
+ this.validationAlertStyle = validationAlertStyle;
+ this.showInputMessage = showInputMessage;
+ this.showErrorMessage = showErrorMessage;
+ this.conditionOperator = conditionOperator;
+ this.formula1 = formula1;
+ this.formula2 = formula2;
+ this.extName = extName;
+ }
+
+ @Test
+ public void test() throws Exception {
+ // New a SC document
+ scComponent = unoApp.newDocument("scalc");
+ scDocument = SCUtil.getSCDocument(scComponent);
+ XSpreadsheet currentsheet = SCUtil.getCurrentSheet(scDocument);
+ // --- Data validation ---
+ XCellRange xCellRange =
currentsheet.getCellRangeByName("A7:C7");
+ XPropertySet xCellPropSet = (XPropertySet)
UnoRuntime.queryInterface(
+ XPropertySet.class, xCellRange);
+
+ // validation properties
+ XPropertySet xValidPropSet = (XPropertySet) UnoRuntime
+ .queryInterface(XPropertySet.class,
+
xCellPropSet.getPropertyValue("Validation"));
+
+ String errorTitle = "This is an Error title";
+ String inputHelp = "This is an input help";
+ String inputTitle = "This is an input title";
+ String errorMessage = "This is an invalid value!";
+ xValidPropSet.setPropertyValue("IgnoreBlankCells",
ignoreBlankCells);
+ xValidPropSet.setPropertyValue("Type", validationtype);
+ xValidPropSet.setPropertyValue("ErrorTitle", errorTitle);
+ xValidPropSet.setPropertyValue("ShowErrorMessage",
showErrorMessage);
+ xValidPropSet.setPropertyValue("ErrorMessage", errorMessage);
+ xValidPropSet.setPropertyValue("ErrorAlertStyle",
validationAlertStyle);
+ xValidPropSet.setPropertyValue("ShowInputMessage",
showInputMessage);
+ xValidPropSet.setPropertyValue("InputMessage", inputHelp);
+ xValidPropSet.setPropertyValue("InputTitle", inputTitle);
+
+ // condition
+ XSheetCondition xCondition = (XSheetCondition) UnoRuntime
+ .queryInterface(XSheetCondition.class,
xValidPropSet);
+ xCondition.setOperator((ConditionOperator) conditionOperator);
+ xCondition.setFormula1(formula1);
+ xCondition.setFormula2(formula2);
+
+ // apply on cell range
+ xCellPropSet.setPropertyValue("Validation", xValidPropSet);
+
+ // Save and reload the file
+ SCUtil.saveFileAs(scComponent, "Validationtest", extName);
+ XSpreadsheetDocument scDocumentTemp = SCUtil.reloadFile(unoApp,
+ scDocument, "Validationtest." + extName);
+ scDocument = scDocumentTemp;
+ currentsheet = SCUtil.getCurrentSheet(scDocument);
+
+ // --- Data validation ---
+ xCellRange = currentsheet.getCellRangeByName("A7:C7");
+ xCellPropSet = (XPropertySet) UnoRuntime.queryInterface(
+ XPropertySet.class, xCellRange);
+ // validation properties
+ xValidPropSet = (XPropertySet) UnoRuntime
+ .queryInterface(XPropertySet.class,
+
xCellPropSet.getPropertyValue("Validation"));
+
+ // Verify the validation property
+ //If validation Alert Style is Macro, after save the error
message will be clean
+ if (validationAlertStyle == ValidationAlertStyle.MACRO) {
+ assertEquals("",
xValidPropSet.getPropertyValue("ErrorMessage"));
+ } else {
+ assertEquals(errorMessage,
+
xValidPropSet.getPropertyValue("ErrorMessage"));
+ }
+ assertEquals(showErrorMessage,
+
xValidPropSet.getPropertyValue("ShowErrorMessage"));
+ assertEquals(showInputMessage,
+
xValidPropSet.getPropertyValue("ShowInputMessage"));
+ assertEquals(inputHelp,
xValidPropSet.getPropertyValue("InputMessage"));
+ assertEquals(ignoreBlankCells,
+
xValidPropSet.getPropertyValue("IgnoreBlankCells"));
+ assertEquals(validationtype,
xValidPropSet.getPropertyValue("Type"));
+ assertEquals(errorTitle,
xValidPropSet.getPropertyValue("ErrorTitle"));
+ assertEquals(validationAlertStyle,
+
xValidPropSet.getPropertyValue("ErrorAlertStyle"));
+ assertEquals(inputTitle,
xValidPropSet.getPropertyValue("InputTitle"));
+
+ xCondition = (XSheetCondition) UnoRuntime.queryInterface(
+ XSheetCondition.class, xValidPropSet);
+ assertEquals(formula1, xCondition.getFormula1());
+ assertEquals(formula2, xCondition.getFormula2());
+ assertEquals(conditionOperator, xCondition.getOperator());
+
+ }
+}
