Attachment 34675 Details for Bug 60561 – Unit test describing the bug (but pass)

Unit test describing the bug (but pass)

HiddenSheetTest.java (text/plain), 1.42 KB, created by Guillaume SANON on 2017-01-25 16:06:50 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Guillaume SANON

Created: 2017-01-25 16:06:50 UTC

Size: 1.42 KB

patch

obsolete

>package test;
>import java.io.FileOutputStream;
>import java.io.IOException;
>
>import org.apache.poi.ss.usermodel.Cell;
>import org.apache.poi.ss.usermodel.Row;
>import org.apache.poi.ss.usermodel.Sheet;
>import org.apache.poi.ss.usermodel.Workbook;
>import org.apache.poi.xssf.usermodel.XSSFWorkbook;
>
>public class HiddenSheetTest {
>
>	public static final int ROW_NUMBER = 15;
>	public static final int COLUMN_NUMBER = 10;
>	
>	public static void main(String[] args) {
>
>        Workbook wb = new XSSFWorkbook(); 
>        Sheet hiddenSheet = wb.createSheet("HiddenSheet"); 
>        Sheet dataSheet = wb.createSheet("DataSheet"); 
>        Sheet dataSheet2 = wb.createSheet("DataSheet 2"); 
>        populateSheetWithNumber(hiddenSheet, 5);
>        populateSheetWithNumber(dataSheet, 10);
>        populateSheetWithNumber(dataSheet2, 20);
>
>        // Hide "hiddenSheet"
>        wb.setSheetHidden(0, true);
>
>        // set Active Sheet "DataSheet"
>        wb.setActiveSheet(1);
>        
>        try {
>          	FileOutputStream out = new FileOutputStream("WBTest.xlsx");
>          	wb.write(out);
>        	out.close();
>			wb.close();
>		} catch (IOException e) {
>			e.printStackTrace();
>		}
>	}
>
>	private static void populateSheetWithNumber(Sheet sheet, int number)
>	{
>		for(int i = 0; i < ROW_NUMBER; i++)
>		{
>			Row row = sheet.createRow(i);
>			for(int j = 0;  j < COLUMN_NUMBER; j++)
>			{
>				Cell cell = row.createCell(j);
>				cell.setCellValue(number);
>			}
>		}
>	}
>}

Actions: View

Attachments on bug 60561: 34644 | 34645 | 34675