diff options
15 files changed, 329 insertions, 1725 deletions
diff --git a/test/testoo/src/testcase/sc/subtotals/SubtotalsFunctionAverage.java b/test/testoo/src/testcase/sc/subtotals/SubtotalsFunctionAverage.java deleted file mode 100644 index afd15f0021ce..000000000000 --- a/test/testoo/src/testcase/sc/subtotals/SubtotalsFunctionAverage.java +++ /dev/null @@ -1,122 +0,0 @@ -/************************************************************** - * - * 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 testcase.sc.subtotals; - -import static testlib.AppUtil.*; -import static testlib.UIMap.*; - -import java.awt.Rectangle; -import java.io.File; - -import org.junit.After; -import static org.junit.Assert.*; -import static org.openoffice.test.vcl.Tester.*; - -import org.junit.Before; -import org.junit.Rule; -import org.junit.Test; -import org.openoffice.test.common.FileUtil; -import org.openoffice.test.common.GraphicsUtil; - -import testlib.CalcUtil; -import testlib.Log; - - -/** - * - * - */ -public class SubtotalsFunctionAverage { - /** - * TestCapture helps us to do 1. Take a screenshot when failure occurs. 2. - * Collect extra data when OpenOffice crashes. - */ - @Rule - public Log LOG = new Log(); - - /** - * initApp helps us to do 1. Patch the OpenOffice to enable automation if - * necessary. 2. Start OpenOffice with automation enabled if necessary. 3. - * Reset OpenOffice to startcenter. - * - * @throws java.lang.Exception - */ - @Before - public void setUp() throws Exception { - initApp(); - } - /** - * - * Verify Average function in SubTotals - */ - @Test - public void test() { - String file = testFile("sc/SubtotalsSampleFile.ods"); - startcenter.menuItem("File->Open...").select(); - submitOpenDlg(file); - sleep(2); - CalcUtil.selectRange("A1:E7"); - calc.menuItem("Data->Subtotals...").select(); - - assertTrue(SCSubTotalsGroup1Dialog.exists()); - assertEquals("- none -",SCSubTotalsGroupByListBox.getItemText(0)); - assertEquals("Level",SCSubTotalsGroupByListBox.getItemText(1)); - assertEquals("Code",SCSubTotalsGroupByListBox.getItemText(2)); - assertEquals("No.",SCSubTotalsGroupByListBox.getItemText(3)); - assertEquals("Team",SCSubTotalsGroupByListBox.getItemText(4)); - assertEquals("Name",SCSubTotalsGroupByListBox.getItemText(5)); - - - SCSubTotalsGroupByListBox.select("Team"); - sleep(1); - SCCalcSubTotalForColumns.click(10,25); - sleep(1); - typeKeys("<tab>"); - typeKeys("<down>"); - typeKeys("<down>"); - sleep(1); - SCSubTotalsGroup1Dialog.ok(); - sleep(1); - - assertEquals("20",CalcUtil.getCellText("B5")); - assertEquals("=SUBTOTAL(1;$B$2:$B$4)",CalcUtil.getCellInput("B5")); - assertEquals("A Average",CalcUtil.getCellText("D5")); - - assertEquals("15",CalcUtil.getCellText("B8")); - assertEquals("=SUBTOTAL(1;$B$6:$B$7)",CalcUtil.getCellInput("B8")); - assertEquals("B Average",CalcUtil.getCellText("D8")); - - assertEquals("20",CalcUtil.getCellText("B10")); - assertEquals("=SUBTOTAL(1;$B$9:$B$9)",CalcUtil.getCellInput("B10")); - assertEquals("C Average",CalcUtil.getCellText("D10")); - - assertEquals("18.33333333",CalcUtil.getCellText("B11")); - assertEquals("=SUBTOTAL(1;$B$2:$B$10)",CalcUtil.getCellInput("B11")); - assertEquals("Grand Total",CalcUtil.getCellText("D11")); - } - -} diff --git a/test/testoo/src/testcase/sc/subtotals/SubtotalsFunctionCountNumbersOnly.java b/test/testoo/src/testcase/sc/subtotals/SubtotalsFunctionCountNumbersOnly.java deleted file mode 100644 index c38fd3bdd28e..000000000000 --- a/test/testoo/src/testcase/sc/subtotals/SubtotalsFunctionCountNumbersOnly.java +++ /dev/null @@ -1,122 +0,0 @@ -/************************************************************** - * - * 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 testcase.sc.subtotals; - -import static testlib.AppUtil.*; -import static testlib.UIMap.*; - -import java.awt.Rectangle; -import java.io.File; - -import org.junit.After; -import static org.junit.Assert.*; -import static org.openoffice.test.vcl.Tester.*; - -import org.junit.Before; -import org.junit.Rule; -import org.junit.Test; -import org.openoffice.test.common.FileUtil; -import org.openoffice.test.common.GraphicsUtil; - -import testlib.CalcUtil; -import testlib.Log; - -/** - * - * - */ -public class SubtotalsFunctionCountNumbersOnly { - /** - * TestCapture helps us to do 1. Take a screenshot when failure occurs. 2. - * Collect extra data when OpenOffice crashes. - */ - @Rule - public Log LOG = new Log(); - - /** - * initApp helps us to do 1. Patch the OpenOffice to enable automation if - * necessary. 2. Start OpenOffice with automation enabled if necessary. 3. - * Reset OpenOffice to startcenter. - * - * @throws java.lang.Exception - */ - @Before - public void setUp() throws Exception { - initApp(); - } - /** - * - * Verify Count Numbers only function in SubTotals - */ - @Test - public void test() { - String file = testFile("sc/SubtotalsSampleFile.ods"); - startcenter.menuItem("File->Open...").select(); - submitOpenDlg(file); - sleep(2); - CalcUtil.selectRange("A1:E7"); - calc.menuItem("Data->Subtotals...").select(); - - assertTrue(SCSubTotalsGroup1Dialog.exists()); - assertEquals("- none -",SCSubTotalsGroupByListBox.getItemText(0)); - assertEquals("Level",SCSubTotalsGroupByListBox.getItemText(1)); - assertEquals("Code",SCSubTotalsGroupByListBox.getItemText(2)); - assertEquals("No.",SCSubTotalsGroupByListBox.getItemText(3)); - assertEquals("Team",SCSubTotalsGroupByListBox.getItemText(4)); - assertEquals("Name",SCSubTotalsGroupByListBox.getItemText(5)); - - SCCalcSubTotalForColumns.click(10,45); - sleep(1); - typeKeys("<tab>"); - typeKeys("<down>"); - typeKeys("<down>"); - typeKeys("<down>"); - typeKeys("<down>"); - typeKeys("<down>"); - typeKeys("<down>"); - sleep(1); - SCSubTotalsGroup1Dialog.ok(); - sleep(1); - - assertEquals("BS Count",CalcUtil.getCellText("A5")); - assertEquals("=SUBTOTAL(2;$C$2:$C$4)",CalcUtil.getCellInput("C5")); - assertEquals("3",CalcUtil.getCellText("C5")); - - assertEquals("CS Count",CalcUtil.getCellText("A7")); - assertEquals("=SUBTOTAL(2;$C$6:$C$6)",CalcUtil.getCellInput("C7")); - assertEquals("1",CalcUtil.getCellText("C7")); - - assertEquals("MS Count",CalcUtil.getCellText("A10")); - assertEquals("=SUBTOTAL(2;$C$8:$C$9)",CalcUtil.getCellInput("C10")); - assertEquals("2",CalcUtil.getCellText("C10")); - - assertEquals("Grand Total",CalcUtil.getCellText("A11")); - assertEquals("=SUBTOTAL(2;$C$2:$C$10)",CalcUtil.getCellInput("C11")); - assertEquals("6",CalcUtil.getCellText("C11")); - } - -} diff --git a/test/testoo/src/testcase/sc/subtotals/SubtotalsFunctionMax.java b/test/testoo/src/testcase/sc/subtotals/SubtotalsFunctionMax.java deleted file mode 100644 index e57ab4a5c206..000000000000 --- a/test/testoo/src/testcase/sc/subtotals/SubtotalsFunctionMax.java +++ /dev/null @@ -1,120 +0,0 @@ -/************************************************************** - * - * 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 testcase.sc.subtotals; - -import static testlib.AppUtil.*; -import static testlib.UIMap.*; - -import java.awt.Rectangle; -import java.io.File; - -import org.junit.After; -import static org.junit.Assert.*; -import static org.openoffice.test.vcl.Tester.*; - -import org.junit.Before; -import org.junit.Rule; -import org.junit.Test; -import org.openoffice.test.common.FileUtil; -import org.openoffice.test.common.GraphicsUtil; - -import testlib.CalcUtil; -import testlib.Log; - -/** - * - * - */ -public class SubtotalsFunctionMax { - /** - * TestCapture helps us to do 1. Take a screenshot when failure occurs. 2. - * Collect extra data when OpenOffice crashes. - */ - @Rule - public Log LOG = new Log(); - - /** - * initApp helps us to do 1. Patch the OpenOffice to enable automation if - * necessary. 2. Start OpenOffice with automation enabled if necessary. 3. - * Reset OpenOffice to startcenter. - * - * @throws java.lang.Exception - */ - @Before - public void setUp() throws Exception { - initApp(); - } - /** - * - * Verify Max Numbers function in SubTotals - */ - @Test - public void test() { - String file = testFile("sc/SubtotalsSampleFile.ods"); - startcenter.menuItem("File->Open...").select(); - submitOpenDlg(file); - sleep(2); - CalcUtil.selectRange("A1:E7"); - calc.menuItem("Data->Subtotals...").select(); - sleep(1); - - assertTrue(SCSubTotalsGroup1Dialog.exists()); - assertEquals("- none -",SCSubTotalsGroupByListBox.getItemText(0)); - assertEquals("Level",SCSubTotalsGroupByListBox.getItemText(1)); - assertEquals("Code",SCSubTotalsGroupByListBox.getItemText(2)); - assertEquals("No.",SCSubTotalsGroupByListBox.getItemText(3)); - assertEquals("Team",SCSubTotalsGroupByListBox.getItemText(4)); - assertEquals("Name",SCSubTotalsGroupByListBox.getItemText(5)); - - SCCalcSubTotalForColumns.click(10,45); - sleep(1); - typeKeys("<tab>"); - typeKeys("<down>"); - typeKeys("<down>"); - typeKeys("<down>"); - sleep(1); - SCSubTotalsGroup1Dialog.ok(); - sleep(1); - - assertEquals("BS Max",CalcUtil.getCellText("A5")); - assertEquals("=SUBTOTAL(4;$C$2:$C$4)",CalcUtil.getCellInput("C5")); - assertEquals("6",CalcUtil.getCellText("C5")); - - assertEquals("CS Max",CalcUtil.getCellText("A7")); - assertEquals("=SUBTOTAL(4;$C$6:$C$6)",CalcUtil.getCellInput("C7")); - assertEquals("5",CalcUtil.getCellText("C7")); - - assertEquals("MS Max",CalcUtil.getCellText("A10")); - assertEquals("=SUBTOTAL(4;$C$8:$C$9)",CalcUtil.getCellInput("C10")); - assertEquals("3",CalcUtil.getCellText("C10")); - - assertEquals("Grand Total",CalcUtil.getCellText("A11")); - assertEquals("=SUBTOTAL(4;$C$2:$C$10)",CalcUtil.getCellInput("C11")); - assertEquals("6",CalcUtil.getCellText("C11")); - } - -} diff --git a/test/testoo/src/testcase/sc/subtotals/SubtotalsFunctionMin.java b/test/testoo/src/testcase/sc/subtotals/SubtotalsFunctionMin.java deleted file mode 100644 index 035f13598b6f..000000000000 --- a/test/testoo/src/testcase/sc/subtotals/SubtotalsFunctionMin.java +++ /dev/null @@ -1,121 +0,0 @@ -/************************************************************** - * - * 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 testcase.sc.subtotals; - -import static testlib.AppUtil.*; -import static testlib.UIMap.*; - -import java.awt.Rectangle; -import java.io.File; - -import org.junit.After; -import static org.junit.Assert.*; -import static org.openoffice.test.vcl.Tester.*; - -import org.junit.Before; -import org.junit.Rule; -import org.junit.Test; -import org.openoffice.test.common.FileUtil; -import org.openoffice.test.common.GraphicsUtil; - -import testlib.CalcUtil; -import testlib.Log; - -/** - * - * - */ -public class SubtotalsFunctionMin { - /** - * TestCapture helps us to do 1. Take a screenshot when failure occurs. 2. - * Collect extra data when OpenOffice crashes. - */ - @Rule - public Log LOG = new Log(); - - /** - * initApp helps us to do 1. Patch the OpenOffice to enable automation if - * necessary. 2. Start OpenOffice with automation enabled if necessary. 3. - * Reset OpenOffice to startcenter. - * - * @throws java.lang.Exception - */ - @Before - public void setUp() throws Exception { - initApp(); - } - /** - * - * Verify Min Numbers function in SubTotals - */ - @Test - public void test() { - String file = testFile("sc/SubtotalsSampleFile.ods"); - startcenter.menuItem("File->Open...").select(); - submitOpenDlg(file); - sleep(2); - CalcUtil.selectRange("A1:E7"); - calc.menuItem("Data->Subtotals...").select(); - sleep(1); - - assertTrue(SCSubTotalsGroup1Dialog.exists()); - assertEquals("- none -",SCSubTotalsGroupByListBox.getItemText(0)); - assertEquals("Level",SCSubTotalsGroupByListBox.getItemText(1)); - assertEquals("Code",SCSubTotalsGroupByListBox.getItemText(2)); - assertEquals("No.",SCSubTotalsGroupByListBox.getItemText(3)); - assertEquals("Team",SCSubTotalsGroupByListBox.getItemText(4)); - assertEquals("Name",SCSubTotalsGroupByListBox.getItemText(5)); - - SCCalcSubTotalForColumns.click(10,45); - sleep(1); - typeKeys("<tab>"); - typeKeys("<down>"); - typeKeys("<down>"); - typeKeys("<down>"); - typeKeys("<down>"); - sleep(1); - SCSubTotalsGroup1Dialog.ok(); - sleep(1); - - assertEquals("BS Min",CalcUtil.getCellText("A5")); - assertEquals("=SUBTOTAL(5;$C$2:$C$4)",CalcUtil.getCellInput("C5")); - assertEquals("2",CalcUtil.getCellText("C5")); - - assertEquals("CS Min",CalcUtil.getCellText("A7")); - assertEquals("=SUBTOTAL(5;$C$6:$C$6)",CalcUtil.getCellInput("C7")); - assertEquals("5",CalcUtil.getCellText("C7")); - - assertEquals("MS Min",CalcUtil.getCellText("A10")); - assertEquals("=SUBTOTAL(5;$C$8:$C$9)",CalcUtil.getCellInput("C10")); - assertEquals("1",CalcUtil.getCellText("C10")); - - assertEquals("Grand Total",CalcUtil.getCellText("A11")); - assertEquals("=SUBTOTAL(5;$C$2:$C$10)",CalcUtil.getCellInput("C11")); - assertEquals("1",CalcUtil.getCellText("C11")); - } - -} diff --git a/test/testoo/src/testcase/sc/subtotals/SubtotalsFunctionProduct.java b/test/testoo/src/testcase/sc/subtotals/SubtotalsFunctionProduct.java deleted file mode 100644 index 1f3df11b4554..000000000000 --- a/test/testoo/src/testcase/sc/subtotals/SubtotalsFunctionProduct.java +++ /dev/null @@ -1,122 +0,0 @@ -/************************************************************** - * - * 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 testcase.sc.subtotals; - -import static testlib.AppUtil.*; -import static testlib.UIMap.*; - -import java.awt.Rectangle; -import java.io.File; - -import org.junit.After; -import static org.junit.Assert.*; -import static org.openoffice.test.vcl.Tester.*; - -import org.junit.Before; -import org.junit.Rule; -import org.junit.Test; -import org.openoffice.test.common.FileUtil; -import org.openoffice.test.common.GraphicsUtil; - -import testlib.CalcUtil; -import testlib.Log; - -/** - * - * - */ -public class SubtotalsFunctionProduct { - /** - * TestCapture helps us to do 1. Take a screenshot when failure occurs. 2. - * Collect extra data when OpenOffice crashes. - */ - @Rule - public Log LOG = new Log(); - - /** - * initApp helps us to do 1. Patch the OpenOffice to enable automation if - * necessary. 2. Start OpenOffice with automation enabled if necessary. 3. - * Reset OpenOffice to startcenter. - * - * @throws java.lang.Exception - */ - @Before - public void setUp() throws Exception { - initApp(); - } - /** - * - * Verify Product Numbers function in SubTotals - */ - @Test - public void test() { - String file = testFile("sc/SubtotalsSampleFile.ods"); - startcenter.menuItem("File->Open...").select(); - submitOpenDlg(file); - sleep(2); - CalcUtil.selectRange("A1:E7"); - calc.menuItem("Data->Subtotals...").select(); - sleep(1); - - assertTrue(SCSubTotalsGroup1Dialog.exists()); - assertEquals("- none -",SCSubTotalsGroupByListBox.getItemText(0)); - assertEquals("Level",SCSubTotalsGroupByListBox.getItemText(1)); - assertEquals("Code",SCSubTotalsGroupByListBox.getItemText(2)); - assertEquals("No.",SCSubTotalsGroupByListBox.getItemText(3)); - assertEquals("Team",SCSubTotalsGroupByListBox.getItemText(4)); - assertEquals("Name",SCSubTotalsGroupByListBox.getItemText(5)); - - SCCalcSubTotalForColumns.click(10,45); - sleep(1); - typeKeys("<tab>"); - typeKeys("<down>"); - typeKeys("<down>"); - typeKeys("<down>"); - typeKeys("<down>"); - typeKeys("<down>"); - sleep(1); - SCSubTotalsGroup1Dialog.ok(); - sleep(1); - - assertEquals("BS Product",CalcUtil.getCellText("A5")); - assertEquals("=SUBTOTAL(6;$C$2:$C$4)",CalcUtil.getCellInput("C5")); - assertEquals("48",CalcUtil.getCellText("C5")); - - assertEquals("CS Product",CalcUtil.getCellText("A7")); - assertEquals("=SUBTOTAL(6;$C$6:$C$6)",CalcUtil.getCellInput("C7")); - assertEquals("5",CalcUtil.getCellText("C7")); - - assertEquals("MS Product",CalcUtil.getCellText("A10")); - assertEquals("=SUBTOTAL(6;$C$8:$C$9)",CalcUtil.getCellInput("C10")); - assertEquals("3",CalcUtil.getCellText("C10")); - - assertEquals("Grand Total",CalcUtil.getCellText("A11")); - assertEquals("=SUBTOTAL(6;$C$2:$C$10)",CalcUtil.getCellInput("C11")); - assertEquals("720",CalcUtil.getCellText("C11")); - } - -} diff --git a/test/testoo/src/testcase/sc/subtotals/SubtotalsFunctionStDevPPopulation.java b/test/testoo/src/testcase/sc/subtotals/SubtotalsFunctionStDevPPopulation.java deleted file mode 100644 index 3207bdd5b43e..000000000000 --- a/test/testoo/src/testcase/sc/subtotals/SubtotalsFunctionStDevPPopulation.java +++ /dev/null @@ -1,125 +0,0 @@ -/************************************************************** - * - * 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 testcase.sc.subtotals; - -import static testlib.AppUtil.*; -import static testlib.UIMap.*; - -import java.awt.Rectangle; -import java.io.File; - -import org.junit.After; -import static org.junit.Assert.*; -import static org.openoffice.test.vcl.Tester.*; - -import org.junit.Before; -import org.junit.Rule; -import org.junit.Test; -import org.openoffice.test.common.FileUtil; -import org.openoffice.test.common.GraphicsUtil; - -import testlib.CalcUtil; -import testlib.Log; - -/** - * - * - */ -public class SubtotalsFunctionStDevPPopulation { - /** - * TestCapture helps us to do 1. Take a screenshot when failure occurs. 2. - * Collect extra data when OpenOffice crashes. - */ - @Rule - public Log LOG = new Log(); - - /** - * initApp helps us to do 1. Patch the OpenOffice to enable automation if - * necessary. 2. Start OpenOffice with automation enabled if necessary. 3. - * Reset OpenOffice to startcenter. - * - * @throws java.lang.Exception - */ - @Before - public void setUp() throws Exception { - initApp(); - } - /** - * - * Verify Product Numbers function in SubTotals - */ - @Test - public void test() { - String file = testFile("sc/SubtotalsSampleFile.ods"); - startcenter.menuItem("File->Open...").select(); - submitOpenDlg(file); - sleep(2); - CalcUtil.selectRange("A1:E7"); - calc.menuItem("Data->Subtotals...").select(); - sleep(1); - - assertTrue(SCSubTotalsGroup1Dialog.exists()); - assertEquals("- none -",SCSubTotalsGroupByListBox.getItemText(0)); - assertEquals("Level",SCSubTotalsGroupByListBox.getItemText(1)); - assertEquals("Code",SCSubTotalsGroupByListBox.getItemText(2)); - assertEquals("No.",SCSubTotalsGroupByListBox.getItemText(3)); - assertEquals("Team",SCSubTotalsGroupByListBox.getItemText(4)); - assertEquals("Name",SCSubTotalsGroupByListBox.getItemText(5)); - - SCCalcSubTotalForColumns.click(10,45); - sleep(1); - typeKeys("<tab>"); - typeKeys("<down>"); - typeKeys("<down>"); - typeKeys("<down>"); - typeKeys("<down>"); - typeKeys("<down>"); - typeKeys("<down>"); - typeKeys("<down>"); - typeKeys("<down>"); - sleep(1); - SCSubTotalsGroup1Dialog.ok(); - sleep(1); - - assertEquals("BS StDev",CalcUtil.getCellText("A5")); - assertEquals("=SUBTOTAL(8;$C$2:$C$4)",CalcUtil.getCellInput("C5")); - assertEquals("1.63299316",CalcUtil.getCellText("C5")); - - assertEquals("CS StDev",CalcUtil.getCellText("A7")); - assertEquals("=SUBTOTAL(8;$C$6:$C$6)",CalcUtil.getCellInput("C7")); - assertEquals("0",CalcUtil.getCellText("C7")); - - assertEquals("MS StDev",CalcUtil.getCellText("A10")); - assertEquals("=SUBTOTAL(8;$C$8:$C$9)",CalcUtil.getCellInput("C10")); - assertEquals("1",CalcUtil.getCellText("C10")); - - assertEquals("Grand Total",CalcUtil.getCellText("A11")); - assertEquals("=SUBTOTAL(8;$C$2:$C$10)",CalcUtil.getCellInput("C11")); - assertEquals("1.70782513",CalcUtil.getCellText("C11")); - } - -} diff --git a/test/testoo/src/testcase/sc/subtotals/SubtotalsFunctionSum.java b/test/testoo/src/testcase/sc/subtotals/SubtotalsFunctionSum.java deleted file mode 100644 index da6ddde5e511..000000000000 --- a/test/testoo/src/testcase/sc/subtotals/SubtotalsFunctionSum.java +++ /dev/null @@ -1,115 +0,0 @@ -/************************************************************** - * - * 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 testcase.sc.subtotals; - -import static testlib.AppUtil.*; -import static testlib.UIMap.*; - -import java.awt.Rectangle; -import java.io.File; - -import org.junit.After; -import static org.junit.Assert.*; -import static org.openoffice.test.vcl.Tester.*; - -import org.junit.Before; -import org.junit.Rule; -import org.junit.Test; -import org.openoffice.test.common.FileUtil; -import org.openoffice.test.common.GraphicsUtil; - -import testlib.CalcUtil; -import testlib.Log; - -/** - * - * - */ -public class SubtotalsFunctionSum { - /** - * TestCapture helps us to do 1. Take a screenshot when failure occurs. 2. - * Collect extra data when OpenOffice crashes. - */ - @Rule - public Log LOG = new Log(); - - /** - * initApp helps us to do 1. Patch the OpenOffice to enable automation if - * necessary. 2. Start OpenOffice with automation enabled if necessary. 3. - * Reset OpenOffice to startcenter. - * - * @throws java.lang.Exception - */ - @Before - public void setUp() throws Exception { - initApp(); - } - /** - * - * Verify Product Numbers function in SubTotals - */ - @Test - public void test() { - String file = testFile("sc/SubtotalsSampleFile.ods"); - startcenter.menuItem("File->Open...").select(); - submitOpenDlg(file); - sleep(2); - CalcUtil.selectRange("A1:E7"); - calc.menuItem("Data->Subtotals...").select(); - sleep(1); - - assertTrue(SCSubTotalsGroup1Dialog.exists()); - assertEquals("- none -",SCSubTotalsGroupByListBox.getItemText(0)); - assertEquals("Level",SCSubTotalsGroupByListBox.getItemText(1)); - assertEquals("Code",SCSubTotalsGroupByListBox.getItemText(2)); - assertEquals("No.",SCSubTotalsGroupByListBox.getItemText(3)); - assertEquals("Team",SCSubTotalsGroupByListBox.getItemText(4)); - assertEquals("Name",SCSubTotalsGroupByListBox.getItemText(5)); - - SCCalcSubTotalForColumns.click(10,45); - sleep(1); - SCSubTotalsGroup1Dialog.ok(); - sleep(1); - - assertEquals("BS Sum",CalcUtil.getCellText("A5")); - assertEquals("=SUBTOTAL(9;$C$2:$C$4)",CalcUtil.getCellInput("C5")); - assertEquals("12",CalcUtil.getCellText("C5")); - - assertEquals("CS Sum",CalcUtil.getCellText("A7")); - assertEquals("=SUBTOTAL(9;$C$6:$C$6)",CalcUtil.getCellInput("C7")); - assertEquals("5",CalcUtil.getCellText("C7")); - - assertEquals("MS Sum",CalcUtil.getCellText("A10")); - assertEquals("=SUBTOTAL(9;$C$8:$C$9)",CalcUtil.getCellInput("C10")); - assertEquals("4",CalcUtil.getCellText("C10")); - - assertEquals("Grand Total",CalcUtil.getCellText("A11")); - assertEquals("=SUBTOTAL(9;$C$2:$C$10)",CalcUtil.getCellInput("C11")); - assertEquals("21",CalcUtil.getCellText("C11")); - } - -} diff --git a/test/testoo/src/testcase/sc/subtotals/SubtotalsFunctionVarSample.java b/test/testoo/src/testcase/sc/subtotals/SubtotalsFunctionVarSample.java deleted file mode 100644 index 47b9835829fe..000000000000 --- a/test/testoo/src/testcase/sc/subtotals/SubtotalsFunctionVarSample.java +++ /dev/null @@ -1,126 +0,0 @@ -/************************************************************** - * - * 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 testcase.sc.subtotals; - -import static testlib.AppUtil.*; -import static testlib.UIMap.*; - -import java.awt.Rectangle; -import java.io.File; - -import org.junit.After; -import static org.junit.Assert.*; -import static org.openoffice.test.vcl.Tester.*; - -import org.junit.Before; -import org.junit.Rule; -import org.junit.Test; -import org.openoffice.test.common.FileUtil; -import org.openoffice.test.common.GraphicsUtil; - -import testlib.CalcUtil; -import testlib.Log; - -/** - * - * - */ -public class SubtotalsFunctionVarSample { - /** - * TestCapture helps us to do 1. Take a screenshot when failure occurs. 2. - * Collect extra data when OpenOffice crashes. - */ - @Rule - public Log LOG = new Log(); - - /** - * initApp helps us to do 1. Patch the OpenOffice to enable automation if - * necessary. 2. Start OpenOffice with automation enabled if necessary. 3. - * Reset OpenOffice to startcenter. - * - * @throws java.lang.Exception - */ - @Before - public void setUp() throws Exception { - initApp(); - } - /** - * - * Verify Product Numbers function in SubTotals - */ - @Test - public void test() { - String file = testFile("sc/SubtotalsSampleFile.ods"); - startcenter.menuItem("File->Open...").select(); - submitOpenDlg(file); - sleep(2); - CalcUtil.selectRange("A1:E7"); - calc.menuItem("Data->Subtotals...").select(); - sleep(1); - - assertTrue(SCSubTotalsGroup1Dialog.exists()); - assertEquals("- none -",SCSubTotalsGroupByListBox.getItemText(0)); - assertEquals("Level",SCSubTotalsGroupByListBox.getItemText(1)); - assertEquals("Code",SCSubTotalsGroupByListBox.getItemText(2)); - assertEquals("No.",SCSubTotalsGroupByListBox.getItemText(3)); - assertEquals("Team",SCSubTotalsGroupByListBox.getItemText(4)); - assertEquals("Name",SCSubTotalsGroupByListBox.getItemText(5)); - - SCCalcSubTotalForColumns.click(10,45); - sleep(1); - typeKeys("<tab>"); - typeKeys("<down>"); - typeKeys("<down>"); - typeKeys("<down>"); - typeKeys("<down>"); - typeKeys("<down>"); - typeKeys("<down>"); - typeKeys("<down>"); - typeKeys("<down>"); - typeKeys("<down>"); - sleep(1); - SCSubTotalsGroup1Dialog.ok(); - sleep(1); - - assertEquals("BS Var",CalcUtil.getCellText("A5")); - assertEquals("=SUBTOTAL(10;$C$2:$C$4)",CalcUtil.getCellInput("C5")); - assertEquals("4",CalcUtil.getCellText("C5")); - - assertEquals("CS Var",CalcUtil.getCellText("A7")); - assertEquals("=SUBTOTAL(10;$C$6:$C$6)",CalcUtil.getCellInput("C7")); - assertEquals("#DIV/0!",CalcUtil.getCellText("C7")); - - assertEquals("MS Var",CalcUtil.getCellText("A10")); - assertEquals("=SUBTOTAL(10;$C$8:$C$9)",CalcUtil.getCellInput("C10")); - assertEquals("2",CalcUtil.getCellText("C10")); - - assertEquals("Grand Total",CalcUtil.getCellText("A11")); - assertEquals("=SUBTOTAL(10;$C$2:$C$10)",CalcUtil.getCellInput("C11")); - assertEquals("3.5",CalcUtil.getCellText("C11")); - } - -} diff --git a/test/testoo/src/testcase/sc/subtotals/SubtotalsFunctions.java b/test/testoo/src/testcase/sc/subtotals/SubtotalsFunctions.java new file mode 100644 index 000000000000..c62c4902878a --- /dev/null +++ b/test/testoo/src/testcase/sc/subtotals/SubtotalsFunctions.java @@ -0,0 +1,329 @@ +/************************************************************** + * + * 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 testcase.sc.subtotals; + +import static org.junit.Assert.*; +import static org.openoffice.test.vcl.Tester.*; +import static testlib.AppUtil.*; +import static testlib.UIMap.*; + +import org.junit.After; +import org.junit.Before; +import org.junit.Rule; +import org.junit.Test; + +import testlib.CalcUtil; +import testlib.Log; + +/** + * + * + */ +public class SubtotalsFunctions { + + @Rule + public Log LOG = new Log(); + + @Before + public void setUp() throws Exception { + app.start(); + String file = testFile("sc/SubtotalsSampleFile.ods"); + startcenter.menuItem("File->Open...").select(); + submitOpenDlg(file); + sleep(2); + CalcUtil.selectRange("A1:E7"); + calc.menuItem("Data->Subtotals...").select(); + } + + @After + public void tearDown() throws Exception { + app.close(); + } + + /** + * + * Verify Average function in SubTotals + */ + @Test + public void testAverage() { + SCSubTotalsGroupByListBox.select("Team"); + SCCalcSubTotalForColumns.click(10, 25); + SCCalcSubTotolsFuncionList.select("Average"); + SCSubTotalsGroup1Dialog.ok(); + sleep(1); + + assertArrayEquals("Subtotal table", new String[][] { { "Level", "Code", "No.", "Team", "Name" }, { "BS", "20", "2", "A", "Chcomic" }, + { "CS", "30", "5", "A", "Ally" }, { "MS", "10", "1", "A", "Joker" }, { "", "20", "", "A Average", "" }, { "BS", "20", "4", "B", "Elle" }, + { "MS", "10", "3", "B", "Kevin" }, { "", "15", "", "B Average", "" }, { "BS", "20", "6", "C", "Sweet" }, { "", "20", "", "C Average", "" }, + { "", "18.33333333", "", "Grand Total", "" } }, CalcUtil.getCellTexts("A1:E11")); + } + + /** + * + * Verify Count Numbers only function in SubTotals + */ + @Test + public void testCountNumbersOnly() { + SCCalcSubTotalForColumns.click(10, 45); + SCCalcSubTotolsFuncionList.select("Count (numbers only)"); + SCSubTotalsGroup1Dialog.ok(); + sleep(1); + + assertArrayEquals("Subtotal table", new String[][] { { "Level", "Code", "No.", "Team", "Name" }, { "BS", "20", "4", "B", "Elle" }, + { "BS", "20", "6", "C", "Sweet" }, { "BS", "20", "2", "A", "Chcomic" }, { "BS Count", "", "3", "", "" }, { "CS", "30", "5", "A", "Ally" }, + { "CS Count", "", "1", "", "" }, { "MS", "10", "1", "A", "Joker" }, { "MS", "10", "3", "B", "Kevin" }, { "MS Count", "", "2", "", "" }, + { "Grand Total", "", "6", "", "" } }, CalcUtil.getCellTexts("A1:E11")); + } + + /** + * + * Verify Max Numbers function in SubTotals + */ + @Test + public void testMax() { + SCCalcSubTotalForColumns.click(10, 45); + SCCalcSubTotolsFuncionList.select("Max"); + SCSubTotalsGroup1Dialog.ok(); + sleep(1); + + assertArrayEquals("Subtotal table", new String[][] { { "Level", "Code", "No.", "Team", "Name" }, { "BS", "20", "4", "B", "Elle" }, + { "BS", "20", "6", "C", "Sweet" }, { "BS", "20", "2", "A", "Chcomic" }, { "BS Max", "", "6", "", "" }, { "CS", "30", "5", "A", "Ally" }, + { "CS Max", "", "5", "", "" }, { "MS", "10", "1", "A", "Joker" }, { "MS", "10", "3", "B", "Kevin" }, { "MS Max", "", "3", "", "" }, + { "Grand Total", "", "6", "", "" } }, CalcUtil.getCellTexts("A1:E11")); + } + + /** + * + * Verify Min Numbers function in SubTotals + */ + @Test + public void testMin() { + SCCalcSubTotalForColumns.click(10, 45); + SCCalcSubTotolsFuncionList.select("Min"); + SCSubTotalsGroup1Dialog.ok(); + sleep(1); + + assertArrayEquals("Subtotal table", new String[][] { { "Level", "Code", "No.", "Team", "Name" }, { "BS", "20", "4", "B", "Elle" }, + { "BS", "20", "6", "C", "Sweet" }, { "BS", "20", "2", "A", "Chcomic" }, { "BS Min", "", "2", "", "" }, { "CS", "30", "5", "A", "Ally" }, + { "CS Min", "", "5", "", "" }, { "MS", "10", "1", "A", "Joker" }, { "MS", "10", "3", "B", "Kevin" }, { "MS Min", "", "1", "", "" }, + { "Grand Total", "", "1", "", "" } }, CalcUtil.getCellTexts("A1:E11")); + } + + /** + * + * Verify Product function in SubTotals + */ + @Test + public void testProduct() { + SCCalcSubTotalForColumns.click(10, 45); + SCCalcSubTotolsFuncionList.select("Product"); + SCSubTotalsGroup1Dialog.ok(); + sleep(1); + + assertArrayEquals("Subtotal table", new String[][] { { "Level", "Code", "No.", "Team", "Name" }, { "BS", "20", "4", "B", "Elle" }, + { "BS", "20", "6", "C", "Sweet" }, { "BS", "20", "2", "A", "Chcomic" }, { "BS Product", "", "48", "", "" }, { "CS", "30", "5", "A", "Ally" }, + { "CS Product", "", "5", "", "" }, { "MS", "10", "1", "A", "Joker" }, { "MS", "10", "3", "B", "Kevin" }, { "MS Product", "", "3", "", "" }, + { "Grand Total", "", "720", "", "" } }, CalcUtil.getCellTexts("A1:E11")); + } + + /** + * + * Verify StDevP (Population) function in SubTotals + */ + @Test + public void testStDevPPopulation() { + SCCalcSubTotalForColumns.click(10, 45); + SCCalcSubTotolsFuncionList.select("StDevP (Population)"); + SCSubTotalsGroup1Dialog.ok(); + sleep(1); + + assertArrayEquals("Subtotal table", new String[][] { { "Level", "Code", "No.", "Team", "Name" }, { "BS", "20", "4", "B", "Elle" }, + { "BS", "20", "6", "C", "Sweet" }, { "BS", "20", "2", "A", "Chcomic" }, { "BS StDev", "", "1.63299316", "", "" }, + { "CS", "30", "5", "A", "Ally" }, { "CS StDev", "", "0", "", "" }, { "MS", "10", "1", "A", "Joker" }, { "MS", "10", "3", "B", "Kevin" }, + { "MS StDev", "", "1", "", "" }, { "Grand Total", "", "1.70782513", "", "" } }, CalcUtil.getCellTexts("A1:E11")); + } + + /** + * + * Verify sum function in SubTotals + */ + @Test + public void testSum() { + SCCalcSubTotalForColumns.click(10, 45); + SCCalcSubTotolsFuncionList.select("Sum"); + SCSubTotalsGroup1Dialog.ok(); + sleep(1); + + assertArrayEquals("Subtotal table", new String[][] { { "Level", "Code", "No.", "Team", "Name" }, { "BS", "20", "4", "B", "Elle" }, + { "BS", "20", "6", "C", "Sweet" }, { "BS", "20", "2", "A", "Chcomic" }, { "BS Sum", "", "12", "", "" }, { "CS", "30", "5", "A", "Ally" }, + { "CS Sum", "", "5", "", "" }, { "MS", "10", "1", "A", "Joker" }, { "MS", "10", "3", "B", "Kevin" }, { "MS Sum", "", "4", "", "" }, + { "Grand Total", "", "21", "", "" } }, CalcUtil.getCellTexts("A1:E11")); + } + + /** + * + * Verify Var Sample function in SubTotals + */ + @Test + public void testVarSample() { + SCCalcSubTotalForColumns.click(10, 45); + SCCalcSubTotolsFuncionList.select("Var (Sample)"); + SCSubTotalsGroup1Dialog.ok(); + sleep(1); + + assertArrayEquals("Subtotal table", new String[][] { { "Level", "Code", "No.", "Team", "Name" }, { "BS", "20", "4", "B", "Elle" }, + { "BS", "20", "6", "C", "Sweet" }, { "BS", "20", "2", "A", "Chcomic" }, { "BS Var", "", "4", "", "" }, { "CS", "30", "5", "A", "Ally" }, + { "CS Var", "", "#DIV/0!", "", "" }, { "MS", "10", "1", "A", "Joker" }, { "MS", "10", "3", "B", "Kevin" }, { "MS Var", "", "2", "", "" }, + { "Grand Total", "", "3.5", "", "" } }, CalcUtil.getCellTexts("A1:E11")); + } + + /** + * + * Verify Don't sort in Sub totals + */ + @Test + public void testDoNotSortOption() { + SCSubTotalsGroupByListBox.select("Team"); + SCCalcSubTotalForColumns.click(10, 25); + SCSubTotalsOptionsTabPage.select(); + SCSubtotalsPreSortToGroupCheckBox.uncheck(); + SCSubTotalsOptionsTabPage.ok(); + sleep(1); + + assertArrayEquals("Subtotal table", new String[][] { { "Level", "Code", "No.", "Team", "Name" }, { "BS", "20", "4", "B", "Elle" }, + { "", "20", "", "B Sum", "" }, { "BS", "20", "6", "C", "Sweet" }, { "", "20", "", "C Sum", "" }, { "BS", "20", "2", "A", "Chcomic" }, + { "CS", "30", "5", "A", "Ally" }, { "MS", "10", "1", "A", "Joker" }, { "", "60", "", "A Sum", "" }, { "MS", "10", "3", "B", "Kevin" }, + { "", "10", "", "B Sum", "" }, { "", "110", "", "Grand Total", "" } }, CalcUtil.getCellTexts("A1:E12")); + } + + /** + * + * Verify SubTotals Options default UI + */ + @Test + public void testDefaultUI() { + assertArrayEquals("Group List: ", new String[] { "- none -", "Level", "Code", "No.", "Team", "Name" }, SCSubTotalsGroupByListBox.getItemsText()); + + SCSubTotalsOptionsTabPage.select(); + assertFalse(SCSubtotalsInsertPageBreakCheckBox.isChecked()); + assertFalse(SCSubtotalsCaseSensitiveCheckBox.isChecked()); + assertTrue(SCSubtotalsPreSortToGroupCheckBox.isChecked()); + assertTrue(SCSubtotalSortAscendingRadioButton.isChecked()); + assertFalse(SCSubtotalSortDescendingRadioButton.isChecked()); + assertFalse(SCSubtotalsIncludeFormatsCheckBox.isChecked()); + assertFalse(SCSubtotalsCustomSortOrderCheckBox.isChecked()); + assertFalse(SCSubtotalsCustomSortListBox.isEnabled()); + SCSubTotalsOptionsTabPage.ok(); + } + + /** + * + * Verify Subtotals using all group + */ + @Test + public void testUsingAllGroup() { + SCSubTotalsGroup1Dialog.select(); + SCSubTotalsGroupByListBox.select("Level"); + SCCalcSubTotalForColumns.click(10, 45); + SCSubTotalsGroup2Dialog.select(); + SCSubTotalsGroupByListBox.select("Team"); + SCCalcSubTotalForColumns.click(10, 25); + SCCalcSubTotolsFuncionList.select("Max"); + SCSubTotalsGroup3Dialog.select(); + SCSubTotalsGroupByListBox.select("Name"); + SCCalcSubTotalForColumns.click(10, 25); + SCSubTotalsGroup1Dialog.select(); + SCSubTotalsGroup1Dialog.ok(); + sleep(1); + + assertArrayEquals("Subtotal table", new String[][] { { "Level", "Code", "No.", "Team", "Name" }, { "BS", "20", "2", "A", "Chcomic" }, + { "", "20", "", "", "Chcomic Sum" }, { "", "20", "", "A Max", "" }, { "BS", "20", "4", "B", "Elle" }, { "", "20", "", "", "Elle Sum" }, + { "", "20", "", "B Max", "" }, { "BS", "20", "6", "C", "Sweet" }, { "", "20", "", "", "Sweet Sum" }, { "", "20", "", "C Max", "" }, + { "BS Sum", "", "12", "", "" }, { "CS", "30", "5", "A", "Ally" }, { "", "30", "", "", "Ally Sum" }, { "", "30", "", "A Max", "" }, + { "CS Sum", "", "5", "", "" }, { "MS", "10", "1", "A", "Joker" }, { "", "10", "", "", "Joker Sum" }, { "", "10", "", "A Max", "" }, + { "MS", "10", "3", "B", "Kevin" }, { "", "10", "", "", "Kevin Sum" }, { "", "10", "", "B Max", "" }, { "MS Sum", "", "4", "", "" }, + { "Grand Total", "", "21", "", "" } }, CalcUtil.getCellTexts("A1:E23")); + } + + + /** + * + * Verify Subtotals_Recalculate and refresh results when data rows deleted. + */ + @Test + public void testRecalculateAfterRowDeleted() { + SCCalcSubTotalForColumns.click(10,45); + SCSubTotalsGroup1Dialog.ok(); + sleep(1); + + assertArrayEquals("Subtotal table before deleting row", new String[][] { { "Level", "Code", "No.", "Team", "Name" }, { "BS", "20", "4", "B", "Elle" }, + { "BS", "20", "6", "C", "Sweet" }, { "BS", "20", "2", "A", "Chcomic" }, { "BS Sum", "", "12", "", "" }, { "CS", "30", "5", "A", "Ally" }, + { "CS Sum", "", "5", "", "" }, { "MS", "10", "1", "A", "Joker" }, { "MS", "10", "3", "B", "Kevin" }, { "MS Sum", "", "4", "", "" }, + { "Grand Total", "", "21", "", "" } }, CalcUtil.getCellTexts("A1:E11")); + + CalcUtil.selectRange("A3:E3"); + calc.menuItem("Edit->Delete Cells...").select(); + SCDeleteCellsDeleteRowsRadioButton.check(); + SCDeleteCellsDialog.ok(); + sleep(1); + + assertArrayEquals("Subtotal table after deleting row", new String[][] { { "Level", "Code", "No.", "Team", "Name" }, { "BS", "20", "4", "B", "Elle" }, + { "BS", "20", "2", "A", "Chcomic" }, { "BS Sum", "", "6", "", "" }, { "CS", "30", "5", "A", "Ally" }, { "CS Sum", "", "5", "", "" }, + { "MS", "10", "1", "A", "Joker" }, { "MS", "10", "3", "B", "Kevin" }, { "MS Sum", "", "4", "", "" }, { "Grand Total", "", "15", "", "" }, + { "", "", "", "", "" } }, CalcUtil.getCellTexts("A1:E11")); + + } + + /** + * + * Verify Recalculates when source data changed with Average function in SubTotals + */ + @Test + public void testRecalculateWhenDataChanged() { + SCSubTotalsGroupByListBox.select("Team"); + SCCalcSubTotalForColumns.click(10,25); + SCCalcSubTotolsFuncionList.select("Average"); + SCSubTotalsGroup1Dialog.ok(); + sleep(1); + + CalcUtil.selectRange("B4"); + typeKeys("40" + "<enter>"); + sleep(1); + assertEquals("30",CalcUtil.getCellText("B5")); + assertEquals("23.33333333",CalcUtil.getCellText("B11")); + + CalcUtil.selectRange("B7"); + typeKeys("50" + "<enter>"); + sleep(1); + assertEquals("35",CalcUtil.getCellText("B8")); + assertEquals("30",CalcUtil.getCellText("B11")); + + CalcUtil.selectRange("B9"); + typeKeys("30" + "<enter>"); + sleep(1); + assertEquals("30",CalcUtil.getCellText("B10")); + assertEquals("31.66666667",CalcUtil.getCellText("B11")); + } +} diff --git a/test/testoo/src/testcase/sc/subtotals/SubtotalsNoColumnSelectedForGroupBy.java b/test/testoo/src/testcase/sc/subtotals/SubtotalsNoColumnSelectedForGroupBy.java deleted file mode 100644 index 816848ac2021..000000000000 --- a/test/testoo/src/testcase/sc/subtotals/SubtotalsNoColumnSelectedForGroupBy.java +++ /dev/null @@ -1,96 +0,0 @@ -/************************************************************** - * - * 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 testcase.sc.subtotals; - -import static testlib.AppUtil.*; -import static testlib.UIMap.*; - -import java.awt.Rectangle; -import java.io.File; - -import org.junit.After; -import static org.junit.Assert.*; -import static org.openoffice.test.vcl.Tester.*; - -import org.junit.Before; -import org.junit.Rule; -import org.junit.Test; -import org.openoffice.test.common.FileUtil; -import org.openoffice.test.common.GraphicsUtil; - -import testlib.CalcUtil; -import testlib.Log; - -public class SubtotalsNoColumnSelectedForGroupBy { - /** - * TestCapture helps us to do 1. Take a screenshot when failure occurs. 2. - * Collect extra data when OpenOffice crashes. - */ - @Rule - public Log LOG = new Log(); - - /** - * initApp helps us to do 1. Patch the OpenOffice to enable automation if - * necessary. 2. Start OpenOffice with automation enabled if necessary. 3. - * Reset OpenOffice to startcenter. - * - * @throws java.lang.Exception - */ - @Before - public void setUp() throws Exception { - initApp(); - } - /** - * - * Verify Subtotals_No column selected for Group by. - */ - @Test - public void test() { - String file = testFile("sc/SubtotalsSampleFile.ods"); - startcenter.menuItem("File->Open...").select(); - submitOpenDlg(file); - sleep(2); - String[][] Expect = CalcUtil.getCellTexts("A1:E7"); - CalcUtil.selectRange("A1:E7"); - calc.menuItem("Data->Subtotals...").select(); - sleep(1); - - assertTrue(SCSubTotalsGroup1Dialog.exists()); - assertEquals("- none -",SCSubTotalsGroupByListBox.getItemText(0)); - assertEquals("Level",SCSubTotalsGroupByListBox.getItemText(1)); - assertEquals("Code",SCSubTotalsGroupByListBox.getItemText(2)); - assertEquals("No.",SCSubTotalsGroupByListBox.getItemText(3)); - assertEquals("Team",SCSubTotalsGroupByListBox.getItemText(4)); - assertEquals("Name",SCSubTotalsGroupByListBox.getItemText(5)); - SCSubTotalsGroupByListBox.select(0); - sleep(1); - - SCSubTotalsGroup1Dialog.ok(); - extracted(Expect); - } - private void extracted(String[][] Expect) { - CalcUtil.getCellTexts("A1:E7"); - } - -} diff --git a/test/testoo/src/testcase/sc/subtotals/SubtotalsOptionsSortDoNotSort.java b/test/testoo/src/testcase/sc/subtotals/SubtotalsOptionsSortDoNotSort.java deleted file mode 100644 index 2df936e536ec..000000000000 --- a/test/testoo/src/testcase/sc/subtotals/SubtotalsOptionsSortDoNotSort.java +++ /dev/null @@ -1,119 +0,0 @@ -/************************************************************** - * - * 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 testcase.sc.subtotals; - -import static testlib.AppUtil.*; -import static testlib.UIMap.*; - -import java.awt.Rectangle; -import java.io.File; - -import org.junit.After; -import static org.junit.Assert.*; -import static org.openoffice.test.vcl.Tester.*; - -import org.junit.Before; -import org.junit.Rule; -import org.junit.Test; -import org.openoffice.test.common.FileUtil; -import org.openoffice.test.common.GraphicsUtil; - -import testlib.CalcUtil; -import testlib.Log; - - -public class SubtotalsOptionsSortDoNotSort { - /** - * TestCapture helps us to do 1. Take a screenshot when failure occurs. 2. - * Collect extra data when OpenOffice crashes. - */ - @Rule - public Log LOG = new Log(); - - /** - * initApp helps us to do 1. Patch the OpenOffice to enable automation if - * necessary. 2. Start OpenOffice with automation enabled if necessary. 3. - * Reset OpenOffice to startcenter. - * - * @throws java.lang.Exception - */ - @Before - public void setUp() throws Exception { - initApp(); - } - /** - * - * Verify Don't sort in Sub totals - */ - @Test - public void test() { - String file = testFile("sc/SubtotalsSampleFile.ods"); - startcenter.menuItem("File->Open...").select(); - submitOpenDlg(file); - sleep(2); - CalcUtil.selectRange("A1:E7"); - calc.menuItem("Data->Subtotals...").select(); - sleep(1); - - assertTrue(SCSubTotalsGroup1Dialog.exists()); - assertEquals("- none -",SCSubTotalsGroupByListBox.getItemText(0)); - assertEquals("Level",SCSubTotalsGroupByListBox.getItemText(1)); - assertEquals("Code",SCSubTotalsGroupByListBox.getItemText(2)); - assertEquals("No.",SCSubTotalsGroupByListBox.getItemText(3)); - assertEquals("Team",SCSubTotalsGroupByListBox.getItemText(4)); - assertEquals("Name",SCSubTotalsGroupByListBox.getItemText(5)); - - SCSubTotalsGroupByListBox.select("Team"); - sleep(1); - SCCalcSubTotalForColumns.click(10,25); - sleep(1); - - SCSubTotalsOptionsTabPage.select(); - SCSubtotalsPreSortToGroupCheckBox.uncheck(); - SCSubTotalsGroup1Dialog .select(); - SCSubTotalsGroup1Dialog .ok(); - sleep(1); - - assertEquals("20",CalcUtil.getCellText("B3")); - assertEquals("=SUBTOTAL(9;$B$2:$B$2)",CalcUtil.getCellInput("B3")); - assertEquals("B Sum",CalcUtil.getCellText("D3")); - - assertEquals("20",CalcUtil.getCellText("B5")); - assertEquals("=SUBTOTAL(9;$B$4:$B$4)",CalcUtil.getCellInput("B5")); - assertEquals("C Sum",CalcUtil.getCellText("D5")); - - assertEquals("60",CalcUtil.getCellText("B9")); - assertEquals("=SUBTOTAL(9;$B$6:$B$8)",CalcUtil.getCellInput("B9")); - assertEquals("A Sum",CalcUtil.getCellText("D9")); - - assertEquals("10",CalcUtil.getCellText("B11")); - assertEquals("=SUBTOTAL(9;$B$10:$B$10)",CalcUtil.getCellInput("B11")); - assertEquals("B Sum",CalcUtil.getCellText("D11")); - - assertEquals("110",CalcUtil.getCellText("B12")); - assertEquals("=SUBTOTAL(9;$B$2:$B$11)",CalcUtil.getCellInput("B12")); - assertEquals("Grand Total",CalcUtil.getCellText("D12")); - } - -} diff --git a/test/testoo/src/testcase/sc/subtotals/SubtotalsRecalculateRefreshAfterSourceRowDeleted.java b/test/testoo/src/testcase/sc/subtotals/SubtotalsRecalculateRefreshAfterSourceRowDeleted.java deleted file mode 100644 index 04c586ddc55a..000000000000 --- a/test/testoo/src/testcase/sc/subtotals/SubtotalsRecalculateRefreshAfterSourceRowDeleted.java +++ /dev/null @@ -1,131 +0,0 @@ -/************************************************************** - * - * 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 testcase.sc.subtotals; - -import static testlib.AppUtil.*; -import static testlib.UIMap.*; - -import java.awt.Rectangle; -import java.io.File; - -import org.junit.After; -import static org.junit.Assert.*; -import static org.openoffice.test.vcl.Tester.*; - -import org.junit.Before; -import org.junit.Rule; -import org.junit.Test; -import org.openoffice.test.common.FileUtil; -import org.openoffice.test.common.GraphicsUtil; - -import testlib.CalcUtil; -import testlib.Log; - -public class SubtotalsRecalculateRefreshAfterSourceRowDeleted { - /** - * TestCapture helps us to do 1. Take a screenshot when failure occurs. 2. - * Collect extra data when OpenOffice crashes. - */ - @Rule - public Log LOG = new Log(); - - /** - * initApp helps us to do 1. Patch the OpenOffice to enable automation if - * necessary. 2. Start OpenOffice with automation enabled if necessary. 3. - * Reset OpenOffice to startcenter. - * - * @throws java.lang.Exception - */ - @Before - public void setUp() throws Exception { - initApp(); - } - /** - * - * Verify Subtotals_Recalculate and refresh results when data rows deleted. - */ - @Test - public void test() { - String file = testFile("sc/SubtotalsSampleFile.ods"); - startcenter.menuItem("File->Open...").select(); - submitOpenDlg(file); - sleep(2); - CalcUtil.selectRange("A1:E7"); - calc.menuItem("Data->Subtotals...").select(); - sleep(1); - - assertTrue(SCSubTotalsGroup1Dialog.exists()); - assertEquals("- none -",SCSubTotalsGroupByListBox.getItemText(0)); - assertEquals("Level",SCSubTotalsGroupByListBox.getItemText(1)); - assertEquals("Code",SCSubTotalsGroupByListBox.getItemText(2)); - assertEquals("No.",SCSubTotalsGroupByListBox.getItemText(3)); - assertEquals("Team",SCSubTotalsGroupByListBox.getItemText(4)); - assertEquals("Name",SCSubTotalsGroupByListBox.getItemText(5)); - - SCCalcSubTotalForColumns.click(10,45); - sleep(1); - SCSubTotalsGroup1Dialog.ok(); - sleep(1); - - assertEquals("BS Sum",CalcUtil.getCellText("A5")); - assertEquals("=SUBTOTAL(9;$C$2:$C$4)",CalcUtil.getCellInput("C5")); - assertEquals("12",CalcUtil.getCellText("C5")); - - assertEquals("CS Sum",CalcUtil.getCellText("A7")); - assertEquals("=SUBTOTAL(9;$C$6:$C$6)",CalcUtil.getCellInput("C7")); - assertEquals("5",CalcUtil.getCellText("C7")); - - assertEquals("MS Sum",CalcUtil.getCellText("A10")); - assertEquals("=SUBTOTAL(9;$C$8:$C$9)",CalcUtil.getCellInput("C10")); - assertEquals("4",CalcUtil.getCellText("C10")); - - assertEquals("Grand Total",CalcUtil.getCellText("A11")); - assertEquals("=SUBTOTAL(9;$C$2:$C$10)",CalcUtil.getCellInput("C11")); - assertEquals("21",CalcUtil.getCellText("C11")); - - CalcUtil.selectRange("A3:E3"); - calc.menuItem("Edit->Delete Cells...").select(); - SCDeleteCellsDeleteRowsRadioButton.check(); - SCDeleteCellsDialog.ok(); - sleep(1); - - assertEquals("BS Sum",CalcUtil.getCellText("A4")); - assertEquals("=SUBTOTAL(9;$C$2:$C$3)",CalcUtil.getCellInput("C4")); - assertEquals("6",CalcUtil.getCellText("C4")); - - assertEquals("CS Sum",CalcUtil.getCellText("A6")); - assertEquals("=SUBTOTAL(9;$C$5:$C$5)",CalcUtil.getCellInput("C6")); - assertEquals("5",CalcUtil.getCellText("C6")); - - assertEquals("MS Sum",CalcUtil.getCellText("A9")); - assertEquals("=SUBTOTAL(9;$C$7:$C$8)",CalcUtil.getCellInput("C9")); - assertEquals("4",CalcUtil.getCellText("C9")); - - assertEquals("Grand Total",CalcUtil.getCellText("A10")); - assertEquals("=SUBTOTAL(9;$C$2:$C$9)",CalcUtil.getCellInput("C10")); - assertEquals("15",CalcUtil.getCellText("C10")); - - } - -} diff --git a/test/testoo/src/testcase/sc/subtotals/SubtotalsRecalculatesWhenSourceDataChanged.java b/test/testoo/src/testcase/sc/subtotals/SubtotalsRecalculatesWhenSourceDataChanged.java deleted file mode 100644 index ffb042f970e9..000000000000 --- a/test/testoo/src/testcase/sc/subtotals/SubtotalsRecalculatesWhenSourceDataChanged.java +++ /dev/null @@ -1,133 +0,0 @@ -/************************************************************** - * - * 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 testcase.sc.subtotals; - -import static testlib.AppUtil.*; -import static testlib.UIMap.*; - -import java.awt.Rectangle; -import java.io.File; - -import org.junit.After; -import static org.junit.Assert.*; -import static org.openoffice.test.vcl.Tester.*; - -import org.junit.Before; -import org.junit.Rule; -import org.junit.Test; -import org.openoffice.test.common.FileUtil; -import org.openoffice.test.common.GraphicsUtil; - -import testlib.CalcUtil; -import testlib.Log; - - -public class SubtotalsRecalculatesWhenSourceDataChanged { - /** - * TestCapture helps us to do 1. Take a screenshot when failure occurs. 2. - * Collect extra data when OpenOffice crashes. - */ - @Rule - public Log LOG = new Log(); - - /** - * initApp helps us to do 1. Patch the OpenOffice to enable automation if - * necessary. 2. Start OpenOffice with automation enabled if necessary. 3. - * Reset OpenOffice to startcenter. - * - * @throws java.lang.Exception - */ - @Before - public void setUp() throws Exception { - initApp(); - } - /** - * - * Verify Recalculates when source data changed with Average function in SubTotals - */ - @Test - public void test() { - String file = testFile("sc/SubtotalsSampleFile.ods"); - startcenter.menuItem("File->Open...").select(); - submitOpenDlg(file); - sleep(2); - CalcUtil.selectRange("A1:E7"); - calc.menuItem("Data->Subtotals...").select(); - - assertTrue(SCSubTotalsGroup1Dialog.exists()); - assertEquals("- none -",SCSubTotalsGroupByListBox.getItemText(0)); - assertEquals("Level",SCSubTotalsGroupByListBox.getItemText(1)); - assertEquals("Code",SCSubTotalsGroupByListBox.getItemText(2)); - assertEquals("No.",SCSubTotalsGroupByListBox.getItemText(3)); - assertEquals("Team",SCSubTotalsGroupByListBox.getItemText(4)); - assertEquals("Name",SCSubTotalsGroupByListBox.getItemText(5)); - - - SCSubTotalsGroupByListBox.select("Team"); - sleep(1); - SCCalcSubTotalForColumns.click(10,25); - sleep(1); - typeKeys("<tab>"); - typeKeys("<down>"); - typeKeys("<down>"); - sleep(1); - SCSubTotalsGroup1Dialog.ok(); - sleep(1); - - assertEquals("20",CalcUtil.getCellText("B5")); - assertEquals("=SUBTOTAL(1;$B$2:$B$4)",CalcUtil.getCellInput("B5")); - assertEquals("A Average",CalcUtil.getCellText("D5")); - - assertEquals("15",CalcUtil.getCellText("B8")); - assertEquals("=SUBTOTAL(1;$B$6:$B$7)",CalcUtil.getCellInput("B8")); - assertEquals("B Average",CalcUtil.getCellText("D8")); - - assertEquals("20",CalcUtil.getCellText("B10")); - assertEquals("=SUBTOTAL(1;$B$9:$B$9)",CalcUtil.getCellInput("B10")); - assertEquals("C Average",CalcUtil.getCellText("D10")); - - assertEquals("18.33333333",CalcUtil.getCellText("B11")); - assertEquals("=SUBTOTAL(1;$B$2:$B$10)",CalcUtil.getCellInput("B11")); - assertEquals("Grand Total",CalcUtil.getCellText("D11")); - - CalcUtil.selectRange("B4"); - typeKeys("40" + "<enter>"); - sleep(1); - assertEquals("30",CalcUtil.getCellText("B5")); - assertEquals("23.33333333",CalcUtil.getCellText("B11")); - - CalcUtil.selectRange("B7"); - typeKeys("50" + "<enter>"); - sleep(1); - assertEquals("35",CalcUtil.getCellText("B8")); - assertEquals("30",CalcUtil.getCellText("B11")); - - CalcUtil.selectRange("B9"); - typeKeys("30" + "<enter>"); - sleep(1); - assertEquals("30",CalcUtil.getCellText("B10")); - assertEquals("31.66666667",CalcUtil.getCellText("B11")); - } - -} diff --git a/test/testoo/src/testcase/sc/subtotals/SubtotalsUIOptionsDefaultStatus.java b/test/testoo/src/testcase/sc/subtotals/SubtotalsUIOptionsDefaultStatus.java deleted file mode 100644 index 5c3056ea0a47..000000000000 --- a/test/testoo/src/testcase/sc/subtotals/SubtotalsUIOptionsDefaultStatus.java +++ /dev/null @@ -1,102 +0,0 @@ -/************************************************************** - * - * 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 testcase.sc.subtotals; - -import static testlib.AppUtil.*; -import static testlib.UIMap.*; - -import java.awt.Rectangle; -import java.io.File; - -import org.junit.After; -import static org.junit.Assert.*; -import static org.openoffice.test.vcl.Tester.*; - -import org.junit.Before; -import org.junit.Rule; -import org.junit.Test; -import org.openoffice.test.common.FileUtil; -import org.openoffice.test.common.GraphicsUtil; - -import testlib.CalcUtil; -import testlib.Log; - -public class SubtotalsUIOptionsDefaultStatus { - /** - * TestCapture helps us to do 1. Take a screenshot when failure occurs. 2. - * Collect extra data when OpenOffice crashes. - */ - @Rule - public Log LOG = new Log(); - - /** - * initApp helps us to do 1. Patch the OpenOffice to enable automation if - * necessary. 2. Start OpenOffice with automation enabled if necessary. 3. - * Reset OpenOffice to startcenter. - * - * @throws java.lang.Exception - */ - @Before - public void setUp() throws Exception { - initApp(); - } - /** - * - * Verify SubTotals Options default UI - */ - @Test - public void test() { - String file = testFile("sc/SubtotalsSampleFile.ods"); - startcenter.menuItem("File->Open...").select(); - submitOpenDlg(file); - sleep(2); - CalcUtil.selectRange("A1:E7"); - calc.menuItem("Data->Subtotals...").select(); - - assertTrue(SCSubTotalsGroup1Dialog.exists()); - assertEquals("- none -",SCSubTotalsGroupByListBox.getItemText(0)); - assertEquals("Level",SCSubTotalsGroupByListBox.getItemText(1)); - assertEquals("Code",SCSubTotalsGroupByListBox.getItemText(2)); - assertEquals("No.",SCSubTotalsGroupByListBox.getItemText(3)); - assertEquals("Team",SCSubTotalsGroupByListBox.getItemText(4)); - assertEquals("Name",SCSubTotalsGroupByListBox.getItemText(5)); - SCSubTotalsOptionsTabPage.select(); - sleep(1); - - assertFalse(SCSubtotalsInsertPageBreakCheckBox.isChecked()); - assertFalse(SCSubtotalsCaseSensitiveCheckBox.isChecked()); - assertTrue(SCSubtotalsPreSortToGroupCheckBox.isChecked()); - assertTrue(SCSubtotalSortAscendingRadioButton.isChecked()); - assertFalse(SCSubtotalSortDescendingRadioButton.isChecked()); - assertFalse(SCSubtotalsIncludeFormatsCheckBox.isChecked()); - assertFalse(SCSubtotalsCustomSortOrderCheckBox.isChecked()); - assertFalse(SCSubtotalsCustomSortListBox.isEnabled()); - sleep(1); - SCSubTotalsGroup1Dialog.select(); - sleep(1); - SCSubTotalsGroup1Dialog.ok(); - - } - -} diff --git a/test/testoo/src/testcase/sc/subtotals/SubtotalsUsingAllGroup.java b/test/testoo/src/testcase/sc/subtotals/SubtotalsUsingAllGroup.java deleted file mode 100644 index 537b7cc2ffa5..000000000000 --- a/test/testoo/src/testcase/sc/subtotals/SubtotalsUsingAllGroup.java +++ /dev/null @@ -1,171 +0,0 @@ -/************************************************************** - * - * 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 testcase.sc.subtotals; - -import static testlib.AppUtil.*; -import static testlib.UIMap.*; - -import java.awt.Rectangle; -import java.io.File; - -import org.junit.After; -import static org.junit.Assert.*; -import static org.openoffice.test.vcl.Tester.*; - -import org.junit.Before; -import org.junit.Rule; -import org.junit.Test; -import org.openoffice.test.common.FileUtil; -import org.openoffice.test.common.GraphicsUtil; - -import testlib.CalcUtil; -import testlib.Log; - -public class SubtotalsUsingAllGroup { - /** - * TestCapture helps us to do 1. Take a screenshot when failure occurs. 2. - * Collect extra data when OpenOffice crashes. - */ - @Rule - public Log LOG = new Log(); - - /** - * initApp helps us to do 1. Patch the OpenOffice to enable automation if - * necessary. 2. Start OpenOffice with automation enabled if necessary. 3. - * Reset OpenOffice to startcenter. - * - * @throws java.lang.Exception - */ - @Before - public void setUp() throws Exception { - initApp(); - } - /** - * - * Verify Subtotals using all group - */ - @Test - public void test() { - String file = testFile("sc/SubtotalsSampleFile.ods"); - startcenter.menuItem("File->Open...").select(); - submitOpenDlg(file); - sleep(2); - CalcUtil.selectRange("A1:E7"); - calc.menuItem("Data->Subtotals...").select(); - sleep(1); - - assertTrue(SCSubTotalsGroup1Dialog.exists()); - assertEquals("- none -",SCSubTotalsGroupByListBox.getItemText(0)); - assertEquals("Level",SCSubTotalsGroupByListBox.getItemText(1)); - assertEquals("Code",SCSubTotalsGroupByListBox.getItemText(2)); - assertEquals("No.",SCSubTotalsGroupByListBox.getItemText(3)); - assertEquals("Team",SCSubTotalsGroupByListBox.getItemText(4)); - assertEquals("Name",SCSubTotalsGroupByListBox.getItemText(5)); - - SCSubTotalsGroup1Dialog.select(); - SCSubTotalsGroupByListBox.select("Level"); - SCCalcSubTotalForColumns.click(10,45); - sleep(1); - - SCSubTotalsGroup2Dialog.select(); - SCSubTotalsGroupByListBox.select("Team"); - SCCalcSubTotalForColumns.click(10,25); - SCCalcSubTotolsFuncionList.click(15,60); - sleep(1); - - SCSubTotalsGroup3Dialog.select(); - SCSubTotalsGroupByListBox.select("Name"); - SCCalcSubTotalForColumns.click(10,25); - sleep(1); - - SCSubTotalsGroup1Dialog.select(); - SCSubTotalsGroup1Dialog.ok(); - sleep(1); - - assertEquals("20",CalcUtil.getCellText("B3")); - assertEquals("=SUBTOTAL(9;$B$2:$B$2)",CalcUtil.getCellInput("B3")); - assertEquals("Chcomic Sum",CalcUtil.getCellText("E3")); - - assertEquals("20",CalcUtil.getCellText("B4")); - assertEquals("=SUBTOTAL(4;$B$2:$B$3)",CalcUtil.getCellInput("B4")); - assertEquals("A Max",CalcUtil.getCellText("D4")); - - assertEquals("20",CalcUtil.getCellText("B6")); - assertEquals("=SUBTOTAL(9;$B$5:$B$5)",CalcUtil.getCellInput("B6")); - assertEquals("Elle Sum",CalcUtil.getCellText("E6")); - - assertEquals("20",CalcUtil.getCellText("B7")); - assertEquals("=SUBTOTAL(4;$B$5:$B$6)",CalcUtil.getCellInput("B7")); - assertEquals("B Max",CalcUtil.getCellText("D7")); - - assertEquals("20",CalcUtil.getCellText("B9")); - assertEquals("=SUBTOTAL(9;$B$8:$B$8)",CalcUtil.getCellInput("B9")); - assertEquals("Sweet Sum",CalcUtil.getCellText("E9")); - - assertEquals("20",CalcUtil.getCellText("B10")); - assertEquals("=SUBTOTAL(4;$B$8:$B$9)",CalcUtil.getCellInput("B10")); - assertEquals("C Max",CalcUtil.getCellText("D10")); - - assertEquals("12",CalcUtil.getCellText("C11")); - assertEquals("=SUBTOTAL(9;$C$2:$C$10)",CalcUtil.getCellInput("C11")); - assertEquals("BS Sum",CalcUtil.getCellText("A11")); - - assertEquals("30",CalcUtil.getCellText("B13")); - assertEquals("=SUBTOTAL(9;$B$12:$B$12)",CalcUtil.getCellInput("B13")); - assertEquals("Ally Sum",CalcUtil.getCellText("E13")); - - assertEquals("30",CalcUtil.getCellText("B14")); - assertEquals("=SUBTOTAL(4;$B$12:$B$13)",CalcUtil.getCellInput("B14")); - assertEquals("A Max",CalcUtil.getCellText("D14")); - - assertEquals("5",CalcUtil.getCellText("C15")); - assertEquals("=SUBTOTAL(9;$C$12:$C$14)",CalcUtil.getCellInput("C15")); - assertEquals("CS Sum",CalcUtil.getCellText("A15")); - - assertEquals("10",CalcUtil.getCellText("B17")); - assertEquals("=SUBTOTAL(9;$B$16:$B$16)",CalcUtil.getCellInput("B17")); - assertEquals("Joker Sum",CalcUtil.getCellText("E17")); - - assertEquals("10",CalcUtil.getCellText("B18")); - assertEquals("=SUBTOTAL(4;$B$16:$B$17)",CalcUtil.getCellInput("B18")); - assertEquals("A Max",CalcUtil.getCellText("D18")); - - assertEquals("10",CalcUtil.getCellText("B20")); - assertEquals("=SUBTOTAL(9;$B$19:$B$19)",CalcUtil.getCellInput("B20")); - assertEquals("Kevin Sum",CalcUtil.getCellText("E20")); - - assertEquals("10",CalcUtil.getCellText("B21")); - assertEquals("=SUBTOTAL(4;$B$19:$B$20)",CalcUtil.getCellInput("B21")); - assertEquals("B Max",CalcUtil.getCellText("D21")); - - assertEquals("4",CalcUtil.getCellText("C22")); - assertEquals("=SUBTOTAL(9;$C$16:$C$21)",CalcUtil.getCellInput("C22")); - assertEquals("MS Sum",CalcUtil.getCellText("A22")); - - assertEquals("21",CalcUtil.getCellText("C23")); - assertEquals("=SUBTOTAL(9;$C$2:$C$22)",CalcUtil.getCellInput("C23")); - assertEquals("Grand Total",CalcUtil.getCellText("A23")); - } - -} |