passing test case

bug60561-short.java (text/x-java), 1.36 KB, created by Javen O'Neal on 2017-01-19 07:11:35 UTC

(hide)

Description: passing test case

Filename:

MIME Type:

Creator: Javen O'Neal

Created: 2017-01-19 07:11:35 UTC

Size: 1.36 KB

patch

obsolete

>@Test >public void bug60561() throws IOException { > > Workbook wb = new XSSFWorkbook(); > Sheet hiddenSheet = wb.createSheet("HiddenSheet"); > Sheet dataSheet = wb.createSheet("DataSheet 1"); > Sheet dataSheet2 = wb.createSheet("DataSheet 2"); > hiddenSheet.createRow(15).createCell(10).setCellValue(5); > dataSheet.createRow(15).createCell(10).setCellValue(10); > dataSheet2.createRow(15).createCell(10).setCellValue(20); > > // set Active Sheet "DataSheet" > wb.setActiveSheet(1); > > // Hide "hiddenSheet" > wb.setSheetHidden(0, Workbook.SHEET_STATE_HIDDEN); > //wb.setSheetHidden(0, Workbook.SHEET_STATE_VERY_HIDDEN); > > Workbook wb2 = XSSFTestDataSamples.writeOutAndReadBack(wb); > wb.close(); > assertEquals(3, wb2.getNumberOfSheets()); > assertEquals(1, wb2.getActiveSheetIndex()); > hiddenSheet = wb2.getSheetAt(0); > dataSheet = wb2.getSheetAt(1); > dataSheet2 = wb2.getSheetAt(2); > assertEquals("HiddenSheet", hiddenSheet.getSheetName()); > assertEquals("DataSheet 1", dataSheet.getSheetName()); > assertEquals("DataSheet 2", dataSheet2.getSheetName()); > assertEquals(5, hiddenSheet.getRow(15).getCell(10).getNumericCellValue(), 0.0); > assertEquals(10, dataSheet.getRow(15).getCell(10).getNumericCellValue(), 0.0); > assertEquals(20, dataSheet2.getRow(15).getCell(10).getNumericCellValue(), 0.0); > wb2.close(); >} View Attachment As Raw

This is ASF Bugzilla: the Apache Software Foundation bug system. In case of problems with the functioning of ASF Bugzilla, please contact bugzilla-admin@apache.org. Please Note: this e-mail address is only for reporting problems with ASF Bugzilla. Mail about any other subject will be silently ignored.

• • Home
  • | New
  • | Browse
  • | Search
  • |
    [?]
  • | Reports
  • | Help
  • | New Account
  • | Log In
    Remember [x]
  • | Forgot Password
    Login: [x]