Search in sources :

Example 26 with CellReference

use of org.apache.poi.ss.util.CellReference in project poi by apache.

the class TestCellReference method testAbsRef3.

@Test
public void testAbsRef3() {
    CellReference cf = new CellReference("B$5");
    confirmCell(cf, null, 4, 1, true, false, "B$5");
}
Also used : CellReference(org.apache.poi.ss.util.CellReference) Test(org.junit.Test)

Example 27 with CellReference

use of org.apache.poi.ss.util.CellReference in project poi by apache.

the class TestCellReference method testAbsRef2.

@Test
public void testAbsRef2() {
    CellReference cf = new CellReference(4, 1, true, true);
    confirmCell(cf, null, 4, 1, true, true, "$B$5");
}
Also used : CellReference(org.apache.poi.ss.util.CellReference) Test(org.junit.Test)

Example 28 with CellReference

use of org.apache.poi.ss.util.CellReference in project poi by apache.

the class TestCellReference method testAbsRef6.

@Test
public void testAbsRef6() {
    CellReference cf = new CellReference(4, 1, false, true);
    confirmCell(cf, null, 4, 1, false, true, "$B5");
}
Also used : CellReference(org.apache.poi.ss.util.CellReference) Test(org.junit.Test)

Example 29 with CellReference

use of org.apache.poi.ss.util.CellReference in project poi by apache.

the class TestCellReference method testAbsRef4.

@Test
public void testAbsRef4() {
    CellReference cf = new CellReference(4, 1, true, false);
    confirmCell(cf, null, 4, 1, true, false, "B$5");
}
Also used : CellReference(org.apache.poi.ss.util.CellReference) Test(org.junit.Test)

Example 30 with CellReference

use of org.apache.poi.ss.util.CellReference in project poi by apache.

the class TestCellReference method testAbsRef7.

@Test
public void testAbsRef7() {
    CellReference cf = new CellReference("B5");
    confirmCell(cf, null, 4, 1, false, false, "B5");
}
Also used : CellReference(org.apache.poi.ss.util.CellReference) Test(org.junit.Test)

Aggregations

CellReference (org.apache.poi.ss.util.CellReference)116 Test (org.junit.Test)52 Cell (org.apache.poi.ss.usermodel.Cell)23 Row (org.apache.poi.ss.usermodel.Row)22 AreaReference (org.apache.poi.ss.util.AreaReference)19 Sheet (org.apache.poi.ss.usermodel.Sheet)13 CellRangeAddress (org.apache.poi.ss.util.CellRangeAddress)12 Workbook (org.apache.poi.ss.usermodel.Workbook)11 SXSSFWorkbook (org.apache.poi.xssf.streaming.SXSSFWorkbook)11 HSSFWorkbook (org.apache.poi.hssf.usermodel.HSSFWorkbook)10 XSSFWorkbook (org.apache.poi.xssf.usermodel.XSSFWorkbook)8 FormulaEvaluator (org.apache.poi.ss.usermodel.FormulaEvaluator)7 XSSFSheet (org.apache.poi.xssf.usermodel.XSSFSheet)6 FileOutputStream (java.io.FileOutputStream)4 ArrayList (java.util.ArrayList)4 CellStyle (org.apache.poi.ss.usermodel.CellStyle)4 XSSFRow (org.apache.poi.xssf.usermodel.XSSFRow)4 File (java.io.File)3 OutputStream (java.io.OutputStream)3 LinkedHashMap (java.util.LinkedHashMap)3