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

Introduction

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

Prototype

public void setCellOptions(short options) 

Source Link

Document

sets the options bitmask - you can also use corresponding option bit setters (see other 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;
}

---