Examples of DimensionsRecord

org.apache.poi.hssf.record.DimensionsRecord
Title: Dimensions Record
Description: provides the minumum and maximum bounds of a sheet.
REFERENCE: PG 303 Microsoft Excel 97 Developer's Kit (ISBN: 1-57231-498-2)
@author Andrew C. Oliver (acoliver at apache dot org) @author Jason Height (jheight at chariot dot net dot au) @version 2.0-pre

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

  }
  public void updateFormulasAfterRowShift(FormulaShifter formulaShifter, int currentExternSheetIndex) {
    _valuesAgg.updateFormulasAfterRowShift(formulaShifter, currentExternSheetIndex);
  }
  public DimensionsRecord createDimensions() {
    DimensionsRecord result = new DimensionsRecord();
    result.setFirstRow(_firstrow);
    result.setLastRow(_lastrow);
    result.setFirstCol((short) _valuesAgg.getFirstCellNum());
    result.setLastCol((short) _valuesAgg.getLastCellNum());
    return result;
  }

View Full Code Here

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

    public void addValueRecord(int row, CellValueRecordInterface col) {


        if(log.check(POILogger.DEBUG)) {
          log.log(POILogger.DEBUG, "add value record  row" + row);
        }
        DimensionsRecord d = _dimensions;


        if (col.getColumn() > d.getLastCol()) {
            d.setLastCol(( short ) (col.getColumn() + 1));
        }
        if (col.getColumn() < d.getFirstCol()) {
            d.setFirstCol(col.getColumn());
        }
        _rowsAggregate.insertCell(col);
    }

View Full Code Here

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

     */


    public void addRow(RowRecord row) {
        if (log.check( POILogger.DEBUG ))
            log.log(POILogger.DEBUG, "addRow ");
        DimensionsRecord d = _dimensions;


        if (row.getRowNumber() >= d.getLastRow()) {
            d.setLastRow(row.getRowNumber() + 1);
        }
        if (row.getRowNumber() < d.getFirstRow()) {
            d.setFirstRow(row.getRowNumber());
        }


        //If the row exists remove it, so that any cells attached to the row are removed
        RowRecord existingRow = _rowsAggregate.getRow(row.getRowNumber());
        if (existingRow != null) {

View Full Code Here

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

    /**
     * creates the Dimensions Record and sets it to bogus values (you should set this yourself
     * or let the high level API do it for you)
     */
    private static DimensionsRecord createDimensions() {
        DimensionsRecord retval = new DimensionsRecord();


        retval.setFirstCol(( short ) 0);
        retval.setLastRow(1);             // one more than it is
        retval.setFirstRow(0);
        retval.setLastCol(( short ) 1);   // one more than it is
        return retval;
    }

View Full Code Here

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

    public void addValueRecord(int row, CellValueRecordInterface col) {


        if(log.check(POILogger.DEBUG)) {
          log.log(POILogger.DEBUG, "add value record  row" + row);
        }
        DimensionsRecord d = _dimensions;


        if (col.getColumn() > d.getLastCol()) {
            d.setLastCol(( short ) (col.getColumn() + 1));
        }
        if (col.getColumn() < d.getFirstCol()) {
            d.setFirstCol(col.getColumn());
        }
        _rowsAggregate.insertCell(col);
    }

View Full Code Here

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

     */


    public void addRow(RowRecord row) {
        if (log.check( POILogger.DEBUG ))
            log.log(POILogger.DEBUG, "addRow ");
        DimensionsRecord d = _dimensions;


        if (row.getRowNumber() >= d.getLastRow()) {
            d.setLastRow(row.getRowNumber() + 1);
        }
        if (row.getRowNumber() < d.getFirstRow()) {
            d.setFirstRow(row.getRowNumber());
        }


        //If the row exists remove it, so that any cells attached to the row are removed
        RowRecord existingRow = _rowsAggregate.getRow(row.getRowNumber());
        if (existingRow != null) {

View Full Code Here

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

    /**
     * creates the Dimensions Record and sets it to bogus values (you should set this yourself
     * or let the high level API do it for you)
     */
    private static DimensionsRecord createDimensions() {
        DimensionsRecord retval = new DimensionsRecord();


        retval.setFirstCol(( short ) 0);
        retval.setLastRow(1);             // one more than it is
        retval.setFirstRow(0);
        retval.setLastCol(( short ) 1);   // one more than it is
        return retval;
    }

View Full Code Here

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

    Record[] recs = {
        BOFRecord.createSheetBOF(),
        new HeaderRecord("&LSales Figures"),
        new FooterRecord("&LJanuary"),
        ur(UnknownRecord.HEADER_FOOTER_089C, "9C 08 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 C4 60 00 00 00 00 00 00 00 00"),
        new DimensionsRecord(),
        new WindowTwoRecord(),
        ur(UnknownRecord.USERSVIEWBEGIN_01AA, "ED 77 3B 86 BC 3F 37 4C A9 58 60 23 43 68 54 4B 01 00 00 00 64 00 00 00 40 00 00 00 02 00 00 00 3D 80 04 00 00 00 00 00 00 00 0C 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 F0 3F FF FF 01 00"),
        new HeaderRecord("&LSales Figures"),
        new FooterRecord("&LJanuary"),
        ur(UnknownRecord.HEADER_FOOTER_089C, "9C 08 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 C4 60 00 00 00 00 00 00 00 00"),

View Full Code Here

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


    Record[] recs = {
        BOFRecord.createSheetBOF(),
        new HeaderRecord("&LSales Figures"),
        new FooterRecord("&LJanuary"),
        new DimensionsRecord(),
        new WindowTwoRecord(),
        ur(UnknownRecord.HEADER_FOOTER_089C, "9C 08 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 C4 60 00 00 00 00 00 00 00 00"),
        EOFRecord.instance,
    };
    RecordStream rs = new RecordStream(Arrays.asList(recs), 0);

View Full Code Here

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


    Record[] recs = {
        BOFRecord.createSheetBOF(),
        new HeaderRecord("&LSales Figures"),
        new FooterRecord("&LJanuary"),
        new DimensionsRecord(),
        createBottomMargin(0.787F),
        new WindowTwoRecord(),
        EOFRecord.instance,
    };
    RecordStream rs = new RecordStream(Arrays.asList(recs), 0);

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.