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


            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

     * @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


        // 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(styleIndex == 0xf) {
        // None set
        return null;
      }
      
        ExtendedFormatRecord xf = _book.getExFormatAt(styleIndex);
        return new HSSFCellStyle(styleIndex, xf, _book);
    }

View Full Code Here

     * @return the new Cell Style object
     */


    public HSSFCellStyle createCellStyle()
    {
        ExtendedFormatRecord xfr = workbook.createCellXF();
        short index = (short) (getNumCellStyles() - 1);
        HSSFCellStyle style = new HSSFCellStyle(index, xfr, this);


        return style;
    }

View Full Code Here

     * @param idx  index within the set of styles
     * @return HSSFCellStyle object at the index
     */
    public HSSFCellStyle getCellStyleAt(short idx)
    {
        ExtendedFormatRecord xfr = workbook.getExFormatAt((int)idx);
        HSSFCellStyle style = new HSSFCellStyle(idx, xfr, this);


        return style;
    }

View Full Code Here


            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

     * @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

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.