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

Introduction

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

Prototype

public void setFillPaletteOptions(short options) 

Source Link

Document

set the fill palette options bitmask (see bitfields for additional palette options)

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;
}

---