Search in sources :

Example 16 with XSSFCellBorder

use of org.apache.poi.xssf.usermodel.extensions.XSSFCellBorder in project poi by apache.

the class XSSFCellStyle method getLeftBorderXSSFColor.

/**
     * Get the color to use for the left border
     *
     * @return the index of the color definition or <code>null</code> if not set
     * @see org.apache.poi.ss.usermodel.IndexedColors
     */
public XSSFColor getLeftBorderXSSFColor() {
    if (!_cellXf.getApplyBorder())
        return null;
    int idx = (int) _cellXf.getBorderId();
    XSSFCellBorder border = _stylesSource.getBorderAt(idx);
    return border.getBorderColor(BorderSide.LEFT);
}
Also used : XSSFCellBorder(org.apache.poi.xssf.usermodel.extensions.XSSFCellBorder)

Example 17 with XSSFCellBorder

use of org.apache.poi.xssf.usermodel.extensions.XSSFCellBorder in project poi by apache.

the class XSSFCellStyle method setBottomBorderColor.

/**
     * 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);
}
Also used : CTBorder(org.openxmlformats.schemas.spreadsheetml.x2006.main.CTBorder) CTBorderPr(org.openxmlformats.schemas.spreadsheetml.x2006.main.CTBorderPr) XSSFCellBorder(org.apache.poi.xssf.usermodel.extensions.XSSFCellBorder)

Example 18 with XSSFCellBorder

use of org.apache.poi.xssf.usermodel.extensions.XSSFCellBorder in project poi by apache.

the class XSSFCellStyle method setBorderLeft.

/**
     * 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);
}
Also used : CTBorder(org.openxmlformats.schemas.spreadsheetml.x2006.main.CTBorder) CTBorderPr(org.openxmlformats.schemas.spreadsheetml.x2006.main.CTBorderPr) XSSFCellBorder(org.apache.poi.xssf.usermodel.extensions.XSSFCellBorder)

Aggregations

XSSFCellBorder (org.apache.poi.xssf.usermodel.extensions.XSSFCellBorder)18 CTBorder (org.openxmlformats.schemas.spreadsheetml.x2006.main.CTBorder)9 CTBorderPr (org.openxmlformats.schemas.spreadsheetml.x2006.main.CTBorderPr)8 XSSFCellFill (org.apache.poi.xssf.usermodel.extensions.XSSFCellFill)4 XSSFFont (org.apache.poi.xssf.usermodel.XSSFFont)3 IOException (java.io.IOException)1 StylesTable (org.apache.poi.xssf.model.StylesTable)1 CustomIndexedColorMap (org.apache.poi.xssf.usermodel.CustomIndexedColorMap)1 DefaultIndexedColorMap (org.apache.poi.xssf.usermodel.DefaultIndexedColorMap)1 IndexedColorMap (org.apache.poi.xssf.usermodel.IndexedColorMap)1 XSSFTableStyle (org.apache.poi.xssf.usermodel.XSSFTableStyle)1 XmlException (org.apache.xmlbeans.XmlException)1 Before (org.junit.Before)1