public void setLeftBorderColor(CTColor color) { CTBorderPr pr = _border.isSetLeft() ? _border.getLeft() : _border.addNewLeft(); if (color == null) { pr.unsetColor(); } else { pr.setColor(color); } }
@Override public void setBorderLeft(BorderStyle border) { CTBorderPr pr = _border.isSetLeft() ? _border.getLeft() : _border.addNewLeft(); if(border == BorderStyle.NONE) _border.unsetLeft(); else pr.setStyle(STBorderStyle.Enum.forInt(border.getCode() + 1)); }
/** * Set the color to use for the left border as a {@link XSSFColor} value * * @param color the color to use */ public void setLeftBorderColor(XSSFColor color) { CTBorder ct = getCTBorder(); if(color == null && !ct.isSetLeft()) return; CTBorderPr pr = ct.isSetLeft() ? ct.getLeft() : ct.addNewLeft(); if(color != null) pr.setColor(color.getCTColor()); else pr.unsetColor(); int idx = _stylesSource.putBorder(new XSSFCellBorder(ct, _theme,_stylesSource.getIndexedColors())); _cellXf.setBorderId(idx); _cellXf.setApplyBorder(true); }
@Override public BorderStyle getBorderLeft() { if(!_cellXf.getApplyBorder()) return BorderStyle.NONE; int idx = (int)_cellXf.getBorderId(); CTBorder ct = _stylesSource.getBorderAt(idx).getCTBorder(); STBorderStyle.Enum ptrn = ct.isSetLeft() ? ct.getLeft().getStyle() : null; if (ptrn == null) { return BorderStyle.NONE; } return BorderStyle.valueOf((short)(ptrn.intValue() - 1)); }
/** * Set the type of border to use for the left border of the cell * * @param border the type of border to use * @since POI 3.15 */ @Override public void setBorderLeft(BorderStyle border) { CTBorder ct = getCTBorder(); CTBorderPr pr = ct.isSetLeft() ? ct.getLeft() : ct.addNewLeft(); if(border == BorderStyle.NONE) ct.unsetLeft(); else pr.setStyle(STBorderStyle.Enum.forInt(border.getCode() + 1)); int idx = _stylesSource.putBorder(new XSSFCellBorder(ct, _theme, _stylesSource.getIndexedColors())); _cellXf.setBorderId(idx); _cellXf.setApplyBorder(true); }
public short getLeftBorderColor(){ if(!_border.isSetLeft()) return 0; CTBorderPr pr = _border.getLeft(); return (short)pr.getColor().getIndexed(); }
public short getBorderLeft(){ STBorderStyle.Enum ptrn = _border.isSetLeft() ? _border.getLeft().getStyle() : null; return ptrn == null ? BORDER_NONE : (short)(ptrn.intValue() - 1); }
public void setLeftBorderColor(CTColor color) { CTBorderPr pr = _border.isSetLeft() ? _border.getLeft() : _border.addNewLeft(); if (color == null) { pr.unsetColor(); } else { pr.setColor(color); } }
public void setBorderLeft(short border){ CTBorderPr pr = _border.isSetLeft() ? _border.getLeft() : _border.addNewLeft(); if(border == BORDER_NONE) _border.unsetLeft(); else pr.setStyle(STBorderStyle.Enum.forInt(border + 1)); }
public void setLeftBorderColor(short color){ CTBorderPr pr = _border.isSetLeft() ? _border.getLeft() : _border.addNewLeft(); CTColor ctColor = CTColor.Factory.newInstance(); ctColor.setIndexed(color); pr.setColor(ctColor); }
@Override public void setBorderLeft(BorderStyle border) { CTBorderPr pr = _border.isSetLeft() ? _border.getLeft() : _border.addNewLeft(); if(border == BorderStyle.NONE) _border.unsetLeft(); else pr.setStyle(STBorderStyle.Enum.forInt(border.getCode() + 1)); }
/** * Set the color to use for the left border as a {@link XSSFColor} value * * @param color the color to use */ public void setLeftBorderColor(XSSFColor color) { CTBorder ct = getCTBorder(); if(color == null && !ct.isSetLeft()) return; CTBorderPr pr = ct.isSetLeft() ? ct.getLeft() : ct.addNewLeft(); if(color != null) pr.setColor(color.getCTColor()); else pr.unsetColor(); int idx = _stylesSource.putBorder(new XSSFCellBorder(ct, _theme,_stylesSource.getIndexedColors())); _cellXf.setBorderId(idx); _cellXf.setApplyBorder(true); }
/** * Set the color to use for the left border as a {@link XSSFColor} value * * @param color the color to use */ public void setLeftBorderColor(XSSFColor color) { CTBorder ct = getCTBorder(); if(color == null && !ct.isSetLeft()) return; CTBorderPr pr = ct.isSetLeft() ? ct.getLeft() : ct.addNewLeft(); if(color != null) pr.setColor(color.getCTColor()); else pr.unsetColor(); int idx = _stylesSource.putBorder(new XSSFCellBorder(ct, _theme)); _cellXf.setBorderId(idx); _cellXf.setApplyBorder(true); }
@Override public BorderStyle getBorderLeft() { if(!_cellXf.getApplyBorder()) return BorderStyle.NONE; int idx = (int)_cellXf.getBorderId(); CTBorder ct = _stylesSource.getBorderAt(idx).getCTBorder(); STBorderStyle.Enum ptrn = ct.isSetLeft() ? ct.getLeft().getStyle() : null; if (ptrn == null) { return BorderStyle.NONE; } return BorderStyle.valueOf((short)(ptrn.intValue() - 1)); }
/** * Get the type of border to use for the left border of the cell * * @return short - border type, default value is {@link org.apache.poi.ss.usermodel.CellStyle#BORDER_NONE} * @see org.apache.poi.ss.usermodel.CellStyle#BORDER_NONE * @see org.apache.poi.ss.usermodel.CellStyle#BORDER_THIN * @see org.apache.poi.ss.usermodel.CellStyle#BORDER_MEDIUM * @see org.apache.poi.ss.usermodel.CellStyle#BORDER_DASHED * @see org.apache.poi.ss.usermodel.CellStyle#BORDER_DOTTED * @see org.apache.poi.ss.usermodel.CellStyle#BORDER_THICK * @see org.apache.poi.ss.usermodel.CellStyle#BORDER_DOUBLE * @see org.apache.poi.ss.usermodel.CellStyle#BORDER_HAIR * @see org.apache.poi.ss.usermodel.CellStyle#BORDER_MEDIUM_DASHED * @see org.apache.poi.ss.usermodel.CellStyle#BORDER_DASH_DOT * @see org.apache.poi.ss.usermodel.CellStyle#BORDER_MEDIUM_DASH_DOT * @see org.apache.poi.ss.usermodel.CellStyle#BORDER_DASH_DOT_DOT * @see org.apache.poi.ss.usermodel.CellStyle#BORDER_MEDIUM_DASH_DOT_DOT * @see org.apache.poi.ss.usermodel.CellStyle#BORDER_SLANTED_DASH_DOT */ public short getBorderLeft() { if(!_cellXf.getApplyBorder()) return BORDER_NONE; int idx = (int)_cellXf.getBorderId(); CTBorder ct = _stylesSource.getBorderAt(idx).getCTBorder(); STBorderStyle.Enum ptrn = ct.isSetLeft() ? ct.getLeft().getStyle() : null; return ptrn == null ? BORDER_NONE : (short)(ptrn.intValue() - 1); }
/** * Set the type of border to use for the left border of the cell * * @param border the type of border to use * @since POI 3.15 */ @Override public void setBorderLeft(BorderStyle border) { CTBorder ct = getCTBorder(); CTBorderPr pr = ct.isSetLeft() ? ct.getLeft() : ct.addNewLeft(); if(border == BorderStyle.NONE) ct.unsetLeft(); else pr.setStyle(STBorderStyle.Enum.forInt(border.getCode() + 1)); int idx = _stylesSource.putBorder(new XSSFCellBorder(ct, _theme, _stylesSource.getIndexedColors())); _cellXf.setBorderId(idx); _cellXf.setApplyBorder(true); }
/** * Set the type of border to use for the left border of the cell * @param border the type of border to use * @see org.apache.poi.ss.usermodel.CellStyle#BORDER_NONE * @see org.apache.poi.ss.usermodel.CellStyle#BORDER_THIN * @see org.apache.poi.ss.usermodel.CellStyle#BORDER_MEDIUM * @see org.apache.poi.ss.usermodel.CellStyle#BORDER_DASHED * @see org.apache.poi.ss.usermodel.CellStyle#BORDER_DOTTED * @see org.apache.poi.ss.usermodel.CellStyle#BORDER_THICK * @see org.apache.poi.ss.usermodel.CellStyle#BORDER_DOUBLE * @see org.apache.poi.ss.usermodel.CellStyle#BORDER_HAIR * @see org.apache.poi.ss.usermodel.CellStyle#BORDER_MEDIUM_DASHED * @see org.apache.poi.ss.usermodel.CellStyle#BORDER_DASH_DOT * @see org.apache.poi.ss.usermodel.CellStyle#BORDER_MEDIUM_DASH_DOT * @see org.apache.poi.ss.usermodel.CellStyle#BORDER_DASH_DOT_DOT * @see org.apache.poi.ss.usermodel.CellStyle#BORDER_MEDIUM_DASH_DOT_DOT * @see org.apache.poi.ss.usermodel.CellStyle#BORDER_SLANTED_DASH_DOT */ public void setBorderLeft(short border) { CTBorder ct = getCTBorder(); CTBorderPr pr = ct.isSetLeft() ? ct.getLeft() : ct.addNewLeft(); if(border == BORDER_NONE) ct.unsetLeft(); else pr.setStyle(STBorderStyle.Enum.forInt(border + 1)); int idx = _stylesSource.putBorder(new XSSFCellBorder(ct, _theme)); _cellXf.setBorderId(idx); _cellXf.setApplyBorder(true); }