}
@Test
public void testOverlapAdd()
{
CsvExcelWorkbook wb = new CsvExcelWorkbook();
UIWorkbook uiWorkbook = new UIWorkbook();
wb.createWorkbook(uiWorkbook);
UIWorksheet sheet = new UIWorksheet();
sheet.setName("sheet");
wb.createOrSelectWorksheet(sheet);
for (int i = 0; i < 2; i++)
{
for (int j = 0; j < 2; j++)
{
UICell cell = new UICell();
cell.setValue(i + "_" + j);
wb.addItem(cell);
}
wb.nextColumn();
}
sheet.setStartColumn(1);
sheet.setStartRow(1);
wb.createOrSelectWorksheet(sheet);
for (int i = 0; i < 2; i++)
{
for (int j = 0; j < 2; j++)
{
UICell cell = new UICell();
cell.setValue(i + "_" + j);
wb.addItem(cell);
}
wb.nextColumn();
}
byte[] correct = new String("\"0_0\",\"1_0\",\"\"\n\"0_1\",\"0_0\",\"1_0\"\n\"\",\"0_1\",\"1_1\"\n").getBytes();
byte[] created = wb.getBytes();
for (int i = 0; i < created.length; i++)
{
assert correct[i] == created[i];
}