1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
|
/*
* ====================================================================
* 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 org.apache.poi.ss.usermodel;
import static org.junit.jupiter.api.Assertions.assertEquals;
import static org.junit.jupiter.api.Assertions.assertNull;
import static org.junit.jupiter.api.Assertions.assertThrows;
import org.apache.poi.ss.usermodel.helpers.ColumnShifter;
import org.junit.jupiter.api.BeforeEach;
import org.junit.jupiter.api.Test;
public abstract class BaseTestColumnShifting {
protected Workbook wb;
protected Sheet sheet1;
protected ColumnShifter columnShifter;
@BeforeEach
void init() {
int rowIndex = 0;
sheet1 = wb.createSheet("sheet1");
Row row = sheet1.createRow(rowIndex++);
row.createCell(0, CellType.NUMERIC).setCellValue(0);
row.createCell(3, CellType.NUMERIC).setCellValue(3);
row.createCell(4, CellType.NUMERIC).setCellValue(4);
row = sheet1.createRow(rowIndex++);
row.createCell(0, CellType.NUMERIC).setCellValue(0.1);
row.createCell(1, CellType.NUMERIC).setCellValue(1.1);
row.createCell(2, CellType.NUMERIC).setCellValue(2.1);
row.createCell(3, CellType.NUMERIC).setCellValue(3.1);
row.createCell(4, CellType.NUMERIC).setCellValue(4.1);
row.createCell(5, CellType.NUMERIC).setCellValue(5.1);
row.createCell(6, CellType.NUMERIC).setCellValue(6.1);
row.createCell(7, CellType.NUMERIC).setCellValue(7.1);
row = sheet1.createRow(rowIndex++);
row.createCell(3, CellType.NUMERIC).setCellValue(3.2);
row.createCell(5, CellType.NUMERIC).setCellValue(5.2);
row.createCell(7, CellType.NUMERIC).setCellValue(7.2);
initColumnShifter();
}
protected void initColumnShifter() {}
@Test
void testShift3ColumnsRight() {
columnShifter.shiftColumns(1, 2, 3);
Cell cell = sheet1.getRow(0).getCell(4);
assertNull(cell);
cell = sheet1.getRow(1).getCell(4);
assertEquals(1.1, cell.getNumericCellValue(), 0.01);
cell = sheet1.getRow(1).getCell(5);
assertEquals(2.1, cell.getNumericCellValue(), 0.01);
cell = sheet1.getRow(2).getCell(4);
assertNull(cell);
}
@Test
void testShiftLeft() {
assertThrows(IllegalStateException.class, () -> columnShifter.shiftColumns(1, 2, -3),
"Shift to negative indices should throw exception");
}
}
|
