public void testGetSetColDefaultStyle() {
XSSFWorkbook workbook = new XSSFWorkbook();
XSSFSheet sheet = workbook.createSheet();
CTWorksheet ctWorksheet = sheet.getCTWorksheet();
ColumnHelper columnHelper = sheet.getColumnHelper();
// POI column 3, OOXML column 4
CTCol col = columnHelper.getOrCreateColumn1Based(4, false);
assertNotNull(col);
assertNotNull(columnHelper.getColumn(3, false));
columnHelper.setColDefaultStyle(3, 2);
assertEquals(2, columnHelper.getColDefaultStyle(3));
assertEquals(-1, columnHelper.getColDefaultStyle(4));
StylesTable stylesTable = workbook.getStylesSource();
CTXf cellXf = CTXf.Factory.newInstance();
cellXf.setFontId(0);
cellXf.setFillId(0);
cellXf.setBorderId(0);
cellXf.setNumFmtId(0);
cellXf.setXfId(0);
stylesTable.putCellXf(cellXf);
CTCol col_2 = ctWorksheet.getColsArray(0).addNewCol();
col_2.setMin(10);
col_2.setMax(12);
col_2.setStyle(1);
assertEquals(1, columnHelper.getColDefaultStyle(11));
XSSFCellStyle cellStyle = new XSSFCellStyle(0, 0, stylesTable, null);
columnHelper.setColDefaultStyle(11, cellStyle);
assertEquals(0, col_2.getStyle());
assertEquals(1, columnHelper.getColDefaultStyle(10));
}
public void setColumnAttributes(CTCol fromCol, CTCol toCol) {
if (fromCol.isSetBestFit()) toCol.setBestFit(fromCol.getBestFit());
if (fromCol.isSetCustomWidth()) toCol.setCustomWidth(fromCol.getCustomWidth());
if (fromCol.isSetHidden()) toCol.setHidden(fromCol.getHidden());
if (fromCol.isSetStyle()) toCol.setStyle(fromCol.getStyle());
if (fromCol.isSetWidth()) toCol.setWidth(fromCol.getWidth());
if (fromCol.isSetCollapsed()) toCol.setCollapsed(fromCol.getCollapsed());
if (fromCol.isSetPhonetic()) toCol.setPhonetic(fromCol.getPhonetic());
if (fromCol.isSetOutlineLevel()) toCol.setOutlineLevel(fromCol.getOutlineLevel());
toCol.setCollapsed(fromCol.isSetCollapsed());
}
