ASF Bugzilla – Attachment 34644 Details for
Bug 60561
Values wrote in the first visible sheet are overwriting hidden sheet values
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
Remember
[x]
|
Forgot Password
Login:
[x]
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(); >}
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Raw
Actions:
View
Attachments on
bug 60561
: 34644 |
34645
|
34675