1*b1cdbd2cSJim Jagielski /**************************************************************
2*b1cdbd2cSJim Jagielski *
3*b1cdbd2cSJim Jagielski * Licensed to the Apache Software Foundation (ASF) under one
4*b1cdbd2cSJim Jagielski * or more contributor license agreements. See the NOTICE file
5*b1cdbd2cSJim Jagielski * distributed with this work for additional information
6*b1cdbd2cSJim Jagielski * regarding copyright ownership. The ASF licenses this file
7*b1cdbd2cSJim Jagielski * to you under the Apache License, Version 2.0 (the
8*b1cdbd2cSJim Jagielski * "License"); you may not use this file except in compliance
9*b1cdbd2cSJim Jagielski * with the License. You may obtain a copy of the License at
10*b1cdbd2cSJim Jagielski *
11*b1cdbd2cSJim Jagielski * http://www.apache.org/licenses/LICENSE-2.0
12*b1cdbd2cSJim Jagielski *
13*b1cdbd2cSJim Jagielski * Unless required by applicable law or agreed to in writing,
14*b1cdbd2cSJim Jagielski * software distributed under the License is distributed on an
15*b1cdbd2cSJim Jagielski * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
16*b1cdbd2cSJim Jagielski * KIND, either express or implied. See the License for the
17*b1cdbd2cSJim Jagielski * specific language governing permissions and limitations
18*b1cdbd2cSJim Jagielski * under the License.
19*b1cdbd2cSJim Jagielski *
20*b1cdbd2cSJim Jagielski *************************************************************/
21*b1cdbd2cSJim Jagielski
22*b1cdbd2cSJim Jagielski package fvt.uno.sc.rowcolumn;
23*b1cdbd2cSJim Jagielski
24*b1cdbd2cSJim Jagielski import static org.junit.Assert.*;
25*b1cdbd2cSJim Jagielski
26*b1cdbd2cSJim Jagielski import org.junit.After;
27*b1cdbd2cSJim Jagielski import org.junit.Before;
28*b1cdbd2cSJim Jagielski import org.junit.Test;
29*b1cdbd2cSJim Jagielski
30*b1cdbd2cSJim Jagielski import org.openoffice.test.uno.UnoApp;
31*b1cdbd2cSJim Jagielski
32*b1cdbd2cSJim Jagielski
33*b1cdbd2cSJim Jagielski import com.sun.star.lang.XComponent;
34*b1cdbd2cSJim Jagielski import com.sun.star.sheet.XSpreadsheet;
35*b1cdbd2cSJim Jagielski import com.sun.star.sheet.XSpreadsheetDocument;
36*b1cdbd2cSJim Jagielski import com.sun.star.sheet.XSpreadsheets;
37*b1cdbd2cSJim Jagielski import com.sun.star.table.XCell;
38*b1cdbd2cSJim Jagielski import com.sun.star.uno.UnoRuntime;
39*b1cdbd2cSJim Jagielski import com.sun.star.table.XTableColumns;
40*b1cdbd2cSJim Jagielski import com.sun.star.table.XTableRows;
41*b1cdbd2cSJim Jagielski import com.sun.star.table.XColumnRowRange;
42*b1cdbd2cSJim Jagielski
43*b1cdbd2cSJim Jagielski /**
44*b1cdbd2cSJim Jagielski * Test insert or delete rows and columns
45*b1cdbd2cSJim Jagielski * @author test
46*b1cdbd2cSJim Jagielski *
47*b1cdbd2cSJim Jagielski */
48*b1cdbd2cSJim Jagielski
49*b1cdbd2cSJim Jagielski public class InsertDeleteRowAndColumn {
50*b1cdbd2cSJim Jagielski
51*b1cdbd2cSJim Jagielski UnoApp unoApp = new UnoApp();
52*b1cdbd2cSJim Jagielski XSpreadsheetDocument scDocument = null;
53*b1cdbd2cSJim Jagielski XComponent scComponent = null;
54*b1cdbd2cSJim Jagielski
55*b1cdbd2cSJim Jagielski @Before
setUp()56*b1cdbd2cSJim Jagielski public void setUp() throws Exception {
57*b1cdbd2cSJim Jagielski unoApp.start();
58*b1cdbd2cSJim Jagielski }
59*b1cdbd2cSJim Jagielski
60*b1cdbd2cSJim Jagielski @After
tearDown()61*b1cdbd2cSJim Jagielski public void tearDown() throws Exception {
62*b1cdbd2cSJim Jagielski unoApp.closeDocument(scComponent);
63*b1cdbd2cSJim Jagielski unoApp.close();
64*b1cdbd2cSJim Jagielski }
65*b1cdbd2cSJim Jagielski
66*b1cdbd2cSJim Jagielski @Test
testInsertDeleteRows()67*b1cdbd2cSJim Jagielski public void testInsertDeleteRows() throws Exception {
68*b1cdbd2cSJim Jagielski
69*b1cdbd2cSJim Jagielski String sheetname = "sheet1";
70*b1cdbd2cSJim Jagielski scComponent = unoApp.newDocument("scalc");
71*b1cdbd2cSJim Jagielski scDocument = (XSpreadsheetDocument) UnoRuntime.queryInterface(XSpreadsheetDocument.class, scComponent);
72*b1cdbd2cSJim Jagielski XSpreadsheets spreadsheets = scDocument.getSheets();
73*b1cdbd2cSJim Jagielski Object sheetObj = spreadsheets.getByName(sheetname);
74*b1cdbd2cSJim Jagielski
75*b1cdbd2cSJim Jagielski
76*b1cdbd2cSJim Jagielski XSpreadsheet sheet = (XSpreadsheet) UnoRuntime.queryInterface(XSpreadsheet.class, sheetObj);
77*b1cdbd2cSJim Jagielski XColumnRowRange xCRRange = (XColumnRowRange) UnoRuntime.queryInterface( XColumnRowRange.class, sheet );
78*b1cdbd2cSJim Jagielski XTableRows xRows = xCRRange.getRows();
79*b1cdbd2cSJim Jagielski
80*b1cdbd2cSJim Jagielski // Create a cell series "A2:A8" with the values 1 ... 7.
81*b1cdbd2cSJim Jagielski int nRow = 1;
82*b1cdbd2cSJim Jagielski for (int i = 1; i < 8; ++i) {
83*b1cdbd2cSJim Jagielski sheet.getCellByPosition( 0, nRow ).setValue( nRow );
84*b1cdbd2cSJim Jagielski nRow += 1;
85*b1cdbd2cSJim Jagielski }
86*b1cdbd2cSJim Jagielski
87*b1cdbd2cSJim Jagielski //Insert a row between row 2 and row 3
88*b1cdbd2cSJim Jagielski xRows.insertByIndex( 2, 1 );
89*b1cdbd2cSJim Jagielski
90*b1cdbd2cSJim Jagielski //Get value of cell A3
91*b1cdbd2cSJim Jagielski XCell cell = sheet.getCellByPosition(0, 2);
92*b1cdbd2cSJim Jagielski double checkvalue = 0.0;
93*b1cdbd2cSJim Jagielski
94*b1cdbd2cSJim Jagielski //Verify after insert row
95*b1cdbd2cSJim Jagielski assertEquals("Verify one new row inserted after Row 2",checkvalue, cell.getValue(),0);
96*b1cdbd2cSJim Jagielski
97*b1cdbd2cSJim Jagielski //Delete the row 3 and row 4
98*b1cdbd2cSJim Jagielski xRows.removeByIndex( 2, 2 );
99*b1cdbd2cSJim Jagielski
100*b1cdbd2cSJim Jagielski //Get value of cell A3 and A4
101*b1cdbd2cSJim Jagielski XCell cellA3 = sheet.getCellByPosition(0, 2);
102*b1cdbd2cSJim Jagielski XCell cellA4 = sheet.getCellByPosition(0, 3);
103*b1cdbd2cSJim Jagielski double checkvalueA3 = 3.0;
104*b1cdbd2cSJim Jagielski double checkvalueA4 = 4.0;
105*b1cdbd2cSJim Jagielski
106*b1cdbd2cSJim Jagielski //Verify after delete row3 and row4
107*b1cdbd2cSJim Jagielski assertEquals("Verify tow rows deleted the value of row 3",checkvalueA3, cellA3.getValue(),0);
108*b1cdbd2cSJim Jagielski assertEquals("Verify tow rows deleted the value of row 4",checkvalueA4, cellA4.getValue(),0);
109*b1cdbd2cSJim Jagielski
110*b1cdbd2cSJim Jagielski }
111*b1cdbd2cSJim Jagielski
112*b1cdbd2cSJim Jagielski @Test
testInsertDeleteColumns()113*b1cdbd2cSJim Jagielski public void testInsertDeleteColumns() throws Exception {
114*b1cdbd2cSJim Jagielski
115*b1cdbd2cSJim Jagielski String sheetname = "sheet1";
116*b1cdbd2cSJim Jagielski scComponent = unoApp.newDocument("scalc");
117*b1cdbd2cSJim Jagielski scDocument = (XSpreadsheetDocument) UnoRuntime.queryInterface(XSpreadsheetDocument.class, scComponent);
118*b1cdbd2cSJim Jagielski XSpreadsheets spreadsheets = scDocument.getSheets();
119*b1cdbd2cSJim Jagielski Object sheetObj = spreadsheets.getByName(sheetname);
120*b1cdbd2cSJim Jagielski
121*b1cdbd2cSJim Jagielski
122*b1cdbd2cSJim Jagielski XSpreadsheet sheet = (XSpreadsheet) UnoRuntime.queryInterface(XSpreadsheet.class, sheetObj);
123*b1cdbd2cSJim Jagielski XColumnRowRange xCRRange = (XColumnRowRange) UnoRuntime.queryInterface( XColumnRowRange.class, sheet );
124*b1cdbd2cSJim Jagielski XTableColumns xColumns = xCRRange.getColumns();
125*b1cdbd2cSJim Jagielski
126*b1cdbd2cSJim Jagielski // Create a cell series "A2:A8" with the values 1 ... 7.
127*b1cdbd2cSJim Jagielski int nRow = 1;
128*b1cdbd2cSJim Jagielski for (int i = 1; i < 8; ++i) {
129*b1cdbd2cSJim Jagielski sheet.getCellByPosition( 1, nRow ).setValue( nRow );
130*b1cdbd2cSJim Jagielski nRow += 1;
131*b1cdbd2cSJim Jagielski }
132*b1cdbd2cSJim Jagielski
133*b1cdbd2cSJim Jagielski //Insert a row between row 2 and row 3
134*b1cdbd2cSJim Jagielski xColumns.insertByIndex( 0, 1 );
135*b1cdbd2cSJim Jagielski
136*b1cdbd2cSJim Jagielski //Get value of cell C2
137*b1cdbd2cSJim Jagielski XCell cell = sheet.getCellByPosition(2, 1);
138*b1cdbd2cSJim Jagielski double checkvalue = 1.0;
139*b1cdbd2cSJim Jagielski
140*b1cdbd2cSJim Jagielski //Verify after insert row
141*b1cdbd2cSJim Jagielski assertEquals("Verify if one new column inserted after Column A",checkvalue, cell.getValue(),0);
142*b1cdbd2cSJim Jagielski
143*b1cdbd2cSJim Jagielski //Delete the row 3 and row 4
144*b1cdbd2cSJim Jagielski xColumns.removeByIndex( 0, 1 );
145*b1cdbd2cSJim Jagielski
146*b1cdbd2cSJim Jagielski //Get value of cell A3 and A4
147*b1cdbd2cSJim Jagielski XCell cellA3 = sheet.getCellByPosition(1, 2);
148*b1cdbd2cSJim Jagielski XCell cellA4 = sheet.getCellByPosition(1, 3);
149*b1cdbd2cSJim Jagielski double checkvalueA3 = 2.0;
150*b1cdbd2cSJim Jagielski double checkvalueA4 = 3.0;
151*b1cdbd2cSJim Jagielski
152*b1cdbd2cSJim Jagielski //Verify after delete row3 and row4
153*b1cdbd2cSJim Jagielski assertEquals("Verify after tow rows deleted, the value of A3",checkvalueA3, cellA3.getValue(),0);
154*b1cdbd2cSJim Jagielski assertEquals("Verify after tow rows deleted, the value of A4",checkvalueA4, cellA4.getValue(),0);
155*b1cdbd2cSJim Jagielski
156*b1cdbd2cSJim Jagielski }
157*b1cdbd2cSJim Jagielski
158*b1cdbd2cSJim Jagielski }
159*b1cdbd2cSJim Jagielski
160