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

Introduction

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

Prototype

public void setPaletteOptions(short options) 

Source Link

Document

set the palette options bitmask (see the individual bitsetter methods that reference this one)

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

---