Example usage for org.apache.poi.ss.usermodel Sheet isDisplayFormulas

Introduction

In this page you can find the example usage for org.apache.poi.ss.usermodel Sheet isDisplayFormulas.

Prototype

boolean isDisplayFormulas();

Source Link

Document

Returns if formulas are displayed

Usage

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

License:Open Source License

@Test
public void testRunReportWithJpegXlsxFormulasRenderOption() throws BirtException, IOException {

    displayFormulas = true;/*from   w  ww. j  av a 2 s . c  o m*/
    InputStream inputStream = runAndRenderReport("SimpleWithJpeg.rptdesign", "xlsx");
    assertNotNull(inputStream);
    try {
        XSSFWorkbook workbook = new XSSFWorkbook(inputStream);
        assertNotNull(workbook);

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

        Sheet sheet = workbook.getSheetAt(0);
        assertEquals(true, sheet.isDisplayFormulas());
        assertEquals(true, sheet.isDisplayGridlines());
        assertEquals(true, sheet.isDisplayRowColHeadings());
        assertEquals(true, sheet.isDisplayZeros());
        performSimpleWithJpegTests(sheet);
    } finally {
        inputStream.close();
    }
}

---

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

License:Open Source License

@Test
public void testRunReportWithJpegXlsxFormulasReport() throws BirtException, IOException {

    InputStream inputStream = runAndRenderReport("SimpleWithJpegDisplayFormulas.rptdesign", "xlsx");
    assertNotNull(inputStream);//ww  w .  j  a v a2  s.  com
    try {
        XSSFWorkbook workbook = new XSSFWorkbook(inputStream);
        assertNotNull(workbook);

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

        Sheet sheet = workbook.getSheetAt(0);
        assertEquals(true, sheet.isDisplayFormulas());
        assertEquals(true, sheet.isDisplayGridlines());
        assertEquals(true, sheet.isDisplayRowColHeadings());
        assertEquals(true, sheet.isDisplayZeros());
        performSimpleWithJpegTests(sheet);
    } finally {
        inputStream.close();
    }
}

---

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

License:Open Source License

@Test
public void testRunReportWithJpegXlsxGridlinesRenderOption() throws BirtException, IOException {

    displayGridlines = false;/*from   w w w . j av a 2s.com*/
    InputStream inputStream = runAndRenderReport("SimpleWithJpeg.rptdesign", "xlsx");
    assertNotNull(inputStream);
    try {
        XSSFWorkbook workbook = new XSSFWorkbook(inputStream);
        assertNotNull(workbook);

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

        Sheet sheet = workbook.getSheetAt(0);
        assertEquals(false, sheet.isDisplayFormulas());
        assertEquals(false, sheet.isDisplayGridlines());
        assertEquals(true, sheet.isDisplayRowColHeadings());
        assertEquals(true, sheet.isDisplayZeros());
        performSimpleWithJpegTests(sheet);
    } finally {
        inputStream.close();
    }
}

---

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

License:Open Source License

@Test
public void testRunReportWithJpegXlsxGridlinesReport() throws BirtException, IOException {

    InputStream inputStream = runAndRenderReport("SimpleWithJpegHideGridlines.rptdesign", "xlsx");
    assertNotNull(inputStream);/* w w  w . ja v  a2 s . c o  m*/
    try {
        XSSFWorkbook workbook = new XSSFWorkbook(inputStream);
        assertNotNull(workbook);

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

        Sheet sheet = workbook.getSheetAt(0);
        assertEquals(false, sheet.isDisplayFormulas());
        assertEquals(false, sheet.isDisplayGridlines());
        assertEquals(true, sheet.isDisplayRowColHeadings());
        assertEquals(true, sheet.isDisplayZeros());
        performSimpleWithJpegTests(sheet);
    } finally {
        inputStream.close();
    }
}

---

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

License:Open Source License

@Test
public void testRunReportWithJpegXlsxRowColHeadingsRenderOption() throws BirtException, IOException {

    displayRowColHeadings = false;//from  ww  w.  java  2  s . c  om
    InputStream inputStream = runAndRenderReport("SimpleWithJpeg.rptdesign", "xlsx");
    assertNotNull(inputStream);
    try {
        XSSFWorkbook workbook = new XSSFWorkbook(inputStream);
        assertNotNull(workbook);

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

        Sheet sheet = workbook.getSheetAt(0);
        assertEquals(false, sheet.isDisplayFormulas());
        assertEquals(true, sheet.isDisplayGridlines());
        assertEquals(false, sheet.isDisplayRowColHeadings());
        assertEquals(true, sheet.isDisplayZeros());
        performSimpleWithJpegTests(sheet);
    } finally {
        inputStream.close();
    }
}

---

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

License:Open Source License

@Test
public void testRunReportWithJpegXlsxRowColHeadingsReport() throws BirtException, IOException {

    InputStream inputStream = runAndRenderReport("SimpleWithJpegHideRowColHeadings.rptdesign", "xlsx");
    assertNotNull(inputStream);/*  w  ww .  ja va2  s  .  co m*/
    try {
        XSSFWorkbook workbook = new XSSFWorkbook(inputStream);
        assertNotNull(workbook);

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

        Sheet sheet = workbook.getSheetAt(0);
        assertEquals(false, sheet.isDisplayFormulas());
        assertEquals(true, sheet.isDisplayGridlines());
        assertEquals(false, sheet.isDisplayRowColHeadings());
        assertEquals(true, sheet.isDisplayZeros());
        performSimpleWithJpegTests(sheet);
    } finally {
        inputStream.close();
    }
}

---

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

License:Open Source License

@Test
public void testRunReportWithJpegXlsxZerosRenderOption() throws BirtException, IOException {

    displayZeros = false;/*from   w w  w.j  a  va 2  s.c o  m*/
    InputStream inputStream = runAndRenderReport("SimpleWithJpeg.rptdesign", "xlsx");
    assertNotNull(inputStream);
    try {
        XSSFWorkbook workbook = new XSSFWorkbook(inputStream);
        assertNotNull(workbook);

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

        Sheet sheet = workbook.getSheetAt(0);
        assertEquals(false, sheet.isDisplayFormulas());
        assertEquals(true, sheet.isDisplayGridlines());
        assertEquals(true, sheet.isDisplayRowColHeadings());
        assertEquals(false, sheet.isDisplayZeros());
        performSimpleWithJpegTests(sheet);
    } finally {
        inputStream.close();
    }
}

---

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

License:Open Source License

@Test
public void testRunReportWithJpegXlsxZerosReport() throws BirtException, IOException {

    InputStream inputStream = runAndRenderReport("SimpleWithJpegHideZeros.rptdesign", "xlsx");
    assertNotNull(inputStream);//from  w  ww  .  ja v  a  2  s. com
    try {
        XSSFWorkbook workbook = new XSSFWorkbook(inputStream);
        assertNotNull(workbook);

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

        Sheet sheet = workbook.getSheetAt(0);
        assertEquals(false, sheet.isDisplayFormulas());
        assertEquals(true, sheet.isDisplayGridlines());
        assertEquals(true, sheet.isDisplayRowColHeadings());
        assertEquals(false, sheet.isDisplayZeros());
        performSimpleWithJpegTests(sheet);
    } finally {
        inputStream.close();
    }
}

---

• «
• 1
• 2
• »