Example usage for org.apache.poi.hssf.record ExtendedFormatRecord setBottomBorderPaletteIdx

Introduction

In this page you can find the example usage for org.apache.poi.hssf.record ExtendedFormatRecord setBottomBorderPaletteIdx.

Prototype

public void setBottomBorderPaletteIdx(short border) 

Source Link

Document

set the palette index for the bottom border

Usage

From source file:com.haulmont.yarg.formatters.impl.xls.HSSFWorkbookHelper.java

License:Apache License

public static ExtendedFormatRecord createExtendedFormat() {
    // CAUTION copied from org.apache.poi.hssf.model.InternalWorkbook#createExtendedFormat

    ExtendedFormatRecord retval = new ExtendedFormatRecord();

    retval.setFontIndex((short) 0);
    retval.setFormatIndex((short) 0x0);
    retval.setCellOptions((short) 0x1);
    retval.setAlignmentOptions((short) 0x20);
    retval.setIndentionOptions((short) 0);
    retval.setBorderOptions((short) 0);
    retval.setPaletteOptions((short) 0);
    retval.setAdtlPaletteOptions((short) 0);
    retval.setFillPaletteOptions((short) 0x20c0);
    retval.setTopBorderPaletteIdx(HSSFColor.BLACK.index);
    retval.setBottomBorderPaletteIdx(HSSFColor.BLACK.index);
    retval.setLeftBorderPaletteIdx(HSSFColor.BLACK.index);
    retval.setRightBorderPaletteIdx(HSSFColor.BLACK.index);
    return retval;
}

---