Examples of 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

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

     * @return HSSFCellStyle object at the index
     */


    public HSSFCellStyle getCellStyleAt(short idx)
    {
        ExtendedFormatRecord xfr = workbook.getExFormatAt(idx);
        HSSFCellStyle style = new HSSFCellStyle(idx, xfr);


        return style;
    }

View Full Code Here

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


        // 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

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

                (( 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

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


            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

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


        // 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

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

                (( 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

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


            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

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


            case CELL_TYPE_FORMULA :
                _stringValue=new HSSFRichTextString(((FormulaRecordAggregate) cval).getStringValue());
                break;
        }
        ExtendedFormatRecord xf = book.getWorkbook().getExFormatAt(cval.getXFIndex());


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

View Full Code Here

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

     * @see org.apache.poi.hssf.usermodel.HSSFWorkbook#getCellStyleAt(short)
     */
    public HSSFCellStyle getCellStyle()
    {
      short styleIndex=_record.getXFIndex();
      ExtendedFormatRecord xf = _book.getWorkbook().getExFormatAt(styleIndex);
      return new HSSFCellStyle(styleIndex, xf, _book);
    }

View Full Code Here

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


    public ExtendedFormatRecord getExFormatAt(int index) {
        int xfptr = records.getXfpos() - (numxfs - 1);


        xfptr += index;
        ExtendedFormatRecord retval =
        ( ExtendedFormatRecord ) records.get(xfptr);


        return retval;
    }

View Full Code Here

0 1 2 3 4 5

TOP

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.