Example usage for org.apache.poi.xssf.usermodel XSSFName getRefersToFormula

Introduction

In this page you can find the example usage for org.apache.poi.xssf.usermodel XSSFName getRefersToFormula.

Prototype

public String getRefersToFormula() 

Source Link

Usage

From source file:uk.co.spudsoft.birt.emitters.excel.tests.AutoFilterTest.java

License:Open Source License

@Test
public void autoFilter() throws Exception {
    debug = false;//from ww  w.  j a  v  a  2 s . co  m
    autoFilter = true;
    InputStream inputStream = runAndRenderReport("SideBySideMultiColumns.rptdesign", "xlsx");
    assertNotNull(inputStream);
    try {
        XSSFWorkbook workbook = new XSSFWorkbook(inputStream);
        assertNotNull(workbook);

        assertEquals(1, workbook.getNumberOfSheets());
        assertEquals("Sheet0", workbook.getSheetAt(0).getSheetName());

        XSSFSheet sheet = workbook.getSheetAt(0);
        assertEquals(124, this.firstNullRow(sheet));

        assertEquals(297, sheet.getRow(0).getHeightInPoints(), 1.0);
        assertEquals(2048, sheet.getColumnWidth(0));
        assertEquals(6196, sheet.getColumnWidth(1));
        assertEquals(3749, sheet.getColumnWidth(2));
        assertEquals(2396, sheet.getColumnWidth(3));
        assertEquals(4516, sheet.getColumnWidth(4));
        assertEquals(7072, sheet.getColumnWidth(5));
        assertEquals(2048, sheet.getColumnWidth(6));
        assertEquals(3509, sheet.getColumnWidth(7));
        assertEquals(2048, sheet.getColumnWidth(8));
        assertEquals(2314, sheet.getColumnWidth(9));
        assertEquals(2338, sheet.getColumnWidth(10));
        assertEquals(2048, sheet.getColumnWidth(11));
        assertEquals(2048, sheet.getColumnWidth(12));

        assertTrue(mergedRegion(sheet, 0, 0, 0, 5));
        assertTrue(mergedRegion(sheet, 0, 7, 0, 12));

        XSSFName name = workbook.getName(XSSFName.BUILTIN_FILTER_DB);
        assertEquals(0, name.getSheetIndex());
        assertEquals("Sheet0!$A$1:$M$2", name.getRefersToFormula());
    } finally {
        inputStream.close();
    }
}

---

From source file:uk.co.spudsoft.birt.emitters.excel.tests.AutoFilterTest.java

License:Open Source License

@Test
public void autoFilterMultiSheets() throws Exception {
    debug = false;/*from   w  ww  . ja va 2  s . c o m*/
    autoFilter = true;
    InputStream inputStream = runAndRenderReport("MultiSheets1.rptdesign", "xlsx");
    assertNotNull(inputStream);
    try {
        XSSFWorkbook workbook = new XSSFWorkbook(inputStream);
        assertNotNull(workbook);

        assertEquals(3, workbook.getNumberOfSheets());
        assertEquals("Number Formats 1", workbook.getSheetAt(0).getSheetName());
        assertEquals("Number Formats 2", workbook.getSheetAt(1).getSheetName());
        assertEquals("Number Formats 3", workbook.getSheetAt(2).getSheetName());

        assertEquals(4, firstNullRow(workbook.getSheetAt(0)));
        assertEquals(4, firstNullRow(workbook.getSheetAt(1)));
        assertEquals(3, firstNullRow(workbook.getSheetAt(2)));

        assertEquals(true, workbook.getSheetAt(0).isDisplayGridlines());
        assertEquals(false, workbook.getSheetAt(1).isDisplayGridlines());
        assertEquals(false, workbook.getSheetAt(2).isDisplayGridlines());
        assertEquals(true, workbook.getSheetAt(0).isDisplayRowColHeadings());
        assertEquals(false, workbook.getSheetAt(1).isDisplayGridlines());
        assertEquals(true, workbook.getSheetAt(2).isDisplayRowColHeadings());

        XSSFName name = workbook.getName(XSSFName.BUILTIN_FILTER_DB);
        assertEquals(0, name.getSheetIndex());
        assertEquals("'Number Formats 1'!$A$1:$H$3", name.getRefersToFormula());

        assertNotNull(workbook.getSheetAt(0).getCTWorksheet().getAutoFilter());
        assertNotNull(workbook.getSheetAt(1).getCTWorksheet().getAutoFilter());
        assertNotNull(workbook.getSheetAt(2).getCTWorksheet().getAutoFilter());
    } finally {
        inputStream.close();
    }
}

---

From source file:uk.co.spudsoft.birt.emitters.excel.tests.AutoFilterTest.java

License:Open Source License

@Test
public void autoFilterMultiTables() throws Exception {
    debug = false;/*  ww w. j av a2 s  .c om*/
    autoFilter = true;
    InputStream inputStream = runAndRenderReport("NumberFormats.rptdesign", "xlsx");
    assertNotNull(inputStream);
    try {

        XSSFWorkbook workbook = new XSSFWorkbook(inputStream);
        assertNotNull(workbook);

        assertEquals(1, workbook.getNumberOfSheets());
        assertEquals("Number Formats Test Report", workbook.getSheetAt(0).getSheetName());

        Sheet sheet = workbook.getSheetAt(0);
        assertEquals(22, this.firstNullRow(sheet));

        assertEquals(3035, sheet.getColumnWidth(0));
        assertEquals(3913, sheet.getColumnWidth(1));
        assertEquals(7021, sheet.getColumnWidth(2));
        assertEquals(4205, sheet.getColumnWidth(3));
        assertEquals(3474, sheet.getColumnWidth(4));
        assertEquals(2852, sheet.getColumnWidth(5));
        assertEquals(3510, sheet.getColumnWidth(6));
        assertEquals(2889, sheet.getColumnWidth(7));
        assertEquals(2048, sheet.getColumnWidth(8));

        XSSFName name = workbook.getName(XSSFName.BUILTIN_FILTER_DB);
        assertEquals(0, name.getSheetIndex());
        assertEquals("'Number Formats Test Report'!$A$1:$H$3", name.getRefersToFormula());

        assertNotNull(workbook.getSheetAt(0).getCTWorksheet().getAutoFilter());
    } finally {
        inputStream.close();
    }
}

---