Examples of org.apache.poi.hssf.record.ExtendedFormatRecord

org.apache.poi.hssf.record.ExtendedFormatRecord
Title: Extended Format Record Description: Probably one of the more complex records. There are two breeds: Style and Cell.
It should be noted that fields in the extended format record are somewhat arbitrary. Almost all of the fields are bit-level, but we name them as best as possible by functional group. In some places this is better than others.
REFERENCE: PG 426 Microsoft Excel 97 Developer's Kit (ISBN: 1-57231-498-2)
@author Andrew C. Oliver (acoliver at apache dot org) @version 2.0-pre


        // Relying on the fact that by default the cellType is set to 0 which
        // is different to CELL_TYPE_BLANK hence the following method call correctly
        // creates a new blank cell.
        setCellType(CELL_TYPE_BLANK, false);
        ExtendedFormatRecord xf = book.getExFormatAt(0xf);


        setCellStyle(new HSSFCellStyle(( short ) 0xf, xf));
    }

View Full Code Here

                (( BoolErrRecord ) record).setRow(row);
                (( BoolErrRecord ) record).setXFIndex(( short ) 0);
                (( BoolErrRecord ) record).setValue(( byte ) 0);
                break;
        }
        ExtendedFormatRecord xf = book.getExFormatAt(0xf);


        setCellStyle(new HSSFCellStyle(( short ) 0xf, xf));
    }

View Full Code Here


            case CELL_TYPE_ERROR :
                errorValue = (( BoolErrRecord ) cval).getErrorValue();
                break;
        }
        ExtendedFormatRecord xf = book.getExFormatAt(cval.getXFIndex());


        setCellStyle(new HSSFCellStyle(( short ) cval.getXFIndex(), xf));
    }

View Full Code Here


        // Relying on the fact that by default the cellType is set to 0 which
        // is different to CELL_TYPE_BLANK hence the following method call correctly
        // creates a new blank cell.
        setCellType(CELL_TYPE_BLANK, false);
        ExtendedFormatRecord xf = book.getExFormatAt(0xf);


        setCellStyle(new HSSFCellStyle(( short ) 0xf, xf));
    }

View Full Code Here

                (( BoolErrRecord ) record).setRow(row);
                (( BoolErrRecord ) record).setXFIndex(( short ) 0);
                (( BoolErrRecord ) record).setValue(( byte ) 0);
                break;
        }
        ExtendedFormatRecord xf = book.getExFormatAt(0xf);


        setCellStyle(new HSSFCellStyle(( short ) 0xf, xf));
    }

View Full Code Here


            case CELL_TYPE_ERROR :
                errorValue = (( BoolErrRecord ) cval).getErrorValue();
                break;
        }
        ExtendedFormatRecord xf = book.getExFormatAt(cval.getXFIndex());


        setCellStyle(new HSSFCellStyle(( short ) cval.getXFIndex(), xf));
    }

View Full Code Here


        // Relying on the fact that by default the cellType is set to 0 which
        // is different to CELL_TYPE_BLANK hence the following method call correctly
        // creates a new blank cell.
        setCellType(CELL_TYPE_BLANK, false);
        ExtendedFormatRecord xf = book.getExFormatAt(0xf);


        setCellStyle(new HSSFCellStyle(( short ) 0xf, xf));
    }

View Full Code Here

                (( BoolErrRecord ) record).setRow(row);
                (( BoolErrRecord ) record).setXFIndex(( short ) 0);
                (( BoolErrRecord ) record).setValue(( byte ) 0);
                break;
        }
        ExtendedFormatRecord xf = book.getExFormatAt(0xf);


        setCellStyle(new HSSFCellStyle(( short ) 0xf, xf));
    }

View Full Code Here


            case CELL_TYPE_ERROR :
                errorValue = (( BoolErrRecord ) cval).getErrorValue();
                break;
        }
        ExtendedFormatRecord xf = book.getExFormatAt(cval.getXFIndex());


        setCellStyle(new HSSFCellStyle(( short ) cval.getXFIndex(), xf));
    }

View Full Code Here

    {
        if(workbook.getNumExFormats() == MAX_STYLES) {
            throw new IllegalStateException("The maximum number of cell styles was exceeded. " +
                    "You can define up to 4000 styles in a .xls workbook");
        }
        ExtendedFormatRecord xfr = workbook.createCellXF();
        short index = (short) (getNumCellStyles() - 1);
        HSSFCellStyle style = new HSSFCellStyle(index, xfr, this);


        return style;
    }

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of org.apache.poi.hssf.record.ExtendedFormatRecord

com.haulmont.yarg.formatters.impl.xls.HSSFWorkbookHelper

evolaris.framework.sys.business.XLS2CSVmra

org.apache.poi.hssf.eventusermodel.examples.XLS2CSVmra

org.apache.poi.hssf.eventusermodel.FormatTrackingHSSFListener

org.apache.poi.hssf.model.InternalWorkbook

org.apache.poi.hssf.model.Workbook

org.apache.poi.hssf.usermodel.HSSFCell

org.apache.poi.hssf.usermodel.HSSFOptimiser

org.apache.poi.hssf.usermodel.HSSFRow

org.apache.poi.hssf.usermodel.HSSFSheet

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.