public void setColors(Color[] colors) { CTColor[] ctcols = new CTColor[colors.length]; for (int i=0; i<colors.length; i++) { ctcols[i] = ((XSSFColor)colors[i]).getCTColor(); } _scale.setColorArray(ctcols); }
public void setColor(Color color) { _databar.setColor( ((XSSFColor)color).getCTColor() ); }
/** * Set background color of the sheet tab * * @param color the color to set */ public void setTabColor(XSSFColor color) { CTSheetPr pr = worksheet.getSheetPr(); if(pr == null) { pr = worksheet.addNewSheetPr(); } pr.setTabColor(color.getCTColor()); }
@Override public void setBottomBorderColor(Color color) { XSSFColor xcolor = XSSFColor.toXSSFColor(color); if (xcolor == null) setBottomBorderColor((CTColor)null); else setBottomBorderColor(xcolor.getCTColor()); } @Override
@Override public void setRightBorderColor(Color color) { XSSFColor xcolor = XSSFColor.toXSSFColor(color); if (xcolor == null) setRightBorderColor((CTColor)null); else setRightBorderColor(xcolor.getCTColor()); } @Override
@Override public void setDiagonalBorderColor(Color color) { XSSFColor xcolor = XSSFColor.toXSSFColor(color); if (xcolor == null) setDiagonalBorderColor((CTColor)null); else setDiagonalBorderColor(xcolor.getCTColor()); } @Override
public void setFillForegroundColor(Color fg) { XSSFColor xcolor = XSSFColor.toXSSFColor(fg); if (xcolor == null) setFillForegroundColor((CTColor)null); else setFillForegroundColor(xcolor.getCTColor()); } public void setFillForegroundColor(short fg) {
/** * Set the foreground fill color represented as a {@link XSSFColor} value. * * @param color - the color to use */ public void setFillForegroundColor(XSSFColor color) { CTPatternFill ptrn = ensureCTPatternFill(); if (color == null) { ptrn.unsetFgColor(); } else { ptrn.setFgColor(color.getCTColor()); } }
@Override public void setTopBorderColor(Color color) { XSSFColor xcolor = XSSFColor.toXSSFColor(color); if (xcolor == null) setTopBorderColor((CTColor)null); else setTopBorderColor(xcolor.getCTColor()); } @Override
public void setHorizontalBorderColor(Color color) { XSSFColor xcolor = XSSFColor.toXSSFColor(color); if (xcolor == null) setBottomBorderColor((CTColor)null); else setHorizontalBorderColor(xcolor.getCTColor()); }
public void setVerticalBorderColor(Color color) { XSSFColor xcolor = XSSFColor.toXSSFColor(color); if (xcolor == null) setBottomBorderColor((CTColor)null); else setVerticalBorderColor(xcolor.getCTColor()); }
/** * Set the color to use for the selected border * * @param side - where to apply the color definition * @param color - the color to use */ public void setBorderColor(BorderSide side, XSSFColor color) { CTBorderPr borderPr = getBorder(side, true); if (color == null) borderPr.unsetColor(); else borderPr.setColor(color.getCTColor()); }
public void setFillBackgroundColor(Color bg) { XSSFColor xcolor = XSSFColor.toXSSFColor(bg); if (xcolor == null) setFillBackgroundColor((CTColor)null); else setFillBackgroundColor(xcolor.getCTColor()); } public void setFillBackgroundColor(short bg) {
@Override public void setLeftBorderColor(Color color) { XSSFColor xcolor = XSSFColor.toXSSFColor(color); if (xcolor == null) setLeftBorderColor((CTColor)null); else setLeftBorderColor(xcolor.getCTColor()); } @Override
/** * Set the background fill color represented as a {@link XSSFColor} value. * * @param color */ public void setFillBackgroundColor(XSSFColor color) { CTPatternFill ptrn = ensureCTPatternFill(); if (color == null) { ptrn.unsetBgColor(); } else { ptrn.setBgColor(color.getCTColor()); } }
@Override public void setFontColor(Color color) { XSSFColor xcolor = XSSFColor.toXSSFColor(color); if (xcolor == null) { _font.getColorList().clear(); } else if(_font.sizeOfColorArray() == 0) { _font.addNewColor().setRgb(xcolor.getRGB()); } else { _font.setColorArray(0, xcolor.getCTColor()); } }
/** * Set the color to use for the top border as a {@link XSSFColor} value * * @param color the color to use */ public void setTopBorderColor(XSSFColor color) { CTBorder ct = getCTBorder(); if(color == null && !ct.isSetTop()) return; CTBorderPr pr = ct.isSetTop() ? ct.getTop() : ct.addNewTop(); 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 bottom border * * @param color the color to use, null means no color */ public void setBottomBorderColor(XSSFColor color) { CTBorder ct = getCTBorder(); if(color == null && !ct.isSetBottom()) return; CTBorderPr pr = ct.isSetBottom() ? ct.getBottom() : ct.addNewBottom(); 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 right border as a {@link XSSFColor} value * * @param color the color to use */ public void setRightBorderColor(XSSFColor color) { CTBorder ct = getCTBorder(); if(color == null && !ct.isSetRight()) return; CTBorderPr pr = ct.isSetRight() ? ct.getRight() : ct.addNewRight(); 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,_stylesSource.getIndexedColors())); _cellXf.setBorderId(idx); _cellXf.setApplyBorder(true); }