Index: src/java/org/apache/poi/hssf/model/Sheet.java =================================================================== RCS file: /home/cvspublic/jakarta-poi/src/java/org/apache/poi/hssf/model/Sheet.java,v retrieving revision 1.6 diff -u -b -r1.6 Sheet.java --- src/java/org/apache/poi/hssf/model/Sheet.java 12 Apr 2002 08:26:29 -0000 1.6 +++ src/java/org/apache/poi/hssf/model/Sheet.java 30 Apr 2002 19:59:57 -0000 @@ -62,14 +62,12 @@ import java.util.Iterator; import org.apache.poi.util.POILogFactory; -import org.apache.poi.hssf - .record.*; // normally I don't do this, buy we literally mean ALL +import org.apache.poi.hssf.record.*; // normally I don't do this, buy we literally mean ALL import org.apache.poi.hssf.record.formula.FormulaUtil; import org.apache.poi.hssf.record.formula.Ptg; import org.apache.poi.util.IntList; import org.apache.poi.util.POILogger; -import org.apache.poi.hssf.record - .aggregates.*; // normally I don't do this, buy we literally mean ALL +import org.apache.poi.hssf.record.aggregates.*; // normally I don't do this, buy we literally mean ALL /** * Low level model implementation of a Sheet (one workbook contains many sheets) @@ -84,17 +82,16 @@ *

* @author Andrew C. Oliver (acoliver at apache dot org) * @author Glen Stampoultzis (glens at apache.org) + * @author Shawn Laubach (laubach at acm.org) Just Gridlines, Headers, Footers, and PrintSetup * @see org.apache.poi.hssf.model.Workbook * @see org.apache.poi.hssf.usermodel.HSSFSheet * @version 1.0-pre */ -public class Sheet - extends java.lang.Object +public class Sheet extends java.lang.Object { protected ArrayList records = null; - int preoffset = - 0; // offset of the sheet in a new file + int preoffset = 0; // offset of the sheet in a new file int loc = 0; protected boolean containsLabels = false; ; @@ -103,12 +100,14 @@ protected DefaultColWidthRecord defaultcolwidth = null; protected DefaultRowHeightRecord defaultrowheight = null; protected GridsetRecord gridset = null; + protected PrintSetupRecord printSetup = null; + protected HeaderRecord header = null; + protected FooterRecord footer = null; + protected PrintGridlinesRecord printGridlines = null; protected MergeCellsRecord merged = null; protected int mergedloc = 0; - private static POILogger log = - POILogFactory.getLogger(Sheet.class); - private ArrayList columnSizes = - null; // holds column info + private static POILogger log = POILogFactory.getLogger (Sheet.class); + private ArrayList columnSizes = null; // holds column info protected ValueRecordsAggregate cells = null; protected RowRecordsAggregate rows = null; private Iterator valueRecIterator = null; @@ -119,7 +118,7 @@ * @see #createSheet(List,int,int) */ - public Sheet() + public Sheet () { } @@ -140,70 +139,70 @@ * @see org.apache.poi.hssf.model.Workbook * @see org.apache.poi.hssf.record.Record */ - public static Sheet createSheet(List recs, int sheetnum, int offset) + public static Sheet createSheet (List recs, int sheetnum, int offset) { - log.logFormatted(log.DEBUG, + log.logFormatted (log.DEBUG, "Sheet createSheet (existing file) with %", - new Integer(recs.size())); - Sheet retval = new Sheet(); - ArrayList records = new ArrayList(recs.size() / 5); + new Integer (recs.size ())); + Sheet retval = new Sheet (); + ArrayList records = new ArrayList (recs.size () / 5); boolean isfirstcell = true; boolean isfirstrow = true; int bofEofNestingLevel = 0; - for (int k = offset; k < recs.size(); k++) + for (int k = offset; k < recs.size (); k++) { - Record rec = ( Record ) recs.get(k); + Record rec = (Record) recs.get (k); - if (rec.getSid() == LabelRecord.sid) + if (rec.getSid () == LabelRecord.sid) { - log.log(log.DEBUG, "Hit label record"); + log.log (log.DEBUG, "Hit label record"); retval.containsLabels = true; } - else if (rec.getSid() == BOFRecord.sid) + else if (rec.getSid () == BOFRecord.sid) { bofEofNestingLevel++; } - else if ((rec.getSid() == EOFRecord.sid) + else if ((rec.getSid () == EOFRecord.sid) && (--bofEofNestingLevel == 0)) { - log.log(log.DEBUG, "Hit EOF record at "); - records.add(rec); + log.log (log.DEBUG, "Hit EOF record at "); + records.add (rec); break; } - else if (rec.getSid() == DimensionsRecord.sid) + else if (rec.getSid () == DimensionsRecord.sid) { - retval.dims = ( DimensionsRecord ) rec; - retval.dimsloc = records.size(); + retval.dims = (DimensionsRecord) rec; + retval.dimsloc = records.size (); } - else if (rec.getSid() == MergeCellsRecord.sid) + else if (rec.getSid () == MergeCellsRecord.sid) { - retval.merged = ( MergeCellsRecord ) rec; + retval.merged = (MergeCellsRecord) rec; retval.mergedloc = k - offset; } - else if (rec.getSid() == ColumnInfoRecord.sid) + else if (rec.getSid () == ColumnInfoRecord.sid) { if (retval.columnSizes == null) { - retval.columnSizes = new ArrayList(); + retval.columnSizes = new ArrayList (); } - retval.columnSizes.add(( ColumnInfoRecord ) rec); + retval.columnSizes.add ((ColumnInfoRecord) rec); } - else if (rec.getSid() == DefaultColWidthRecord.sid) + else if (rec.getSid () == DefaultColWidthRecord.sid) { - retval.defaultcolwidth = ( DefaultColWidthRecord ) rec; + retval.defaultcolwidth = (DefaultColWidthRecord) rec; } - else if (rec.getSid() == DefaultRowHeightRecord.sid) + else if (rec.getSid () == DefaultRowHeightRecord.sid) { - retval.defaultrowheight = ( DefaultRowHeightRecord ) rec; + retval.defaultrowheight = (DefaultRowHeightRecord) rec; } - else if (rec.isValue()) + else if (rec.isValue ()) { if (isfirstcell) { - retval.cells = new ValueRecordsAggregate(); + retval.cells = new ValueRecordsAggregate (); rec = retval.cells; - retval.cells.construct(k, recs); + retval.cells.construct (k, recs); isfirstcell = false; } else @@ -211,13 +210,13 @@ rec = null; } } - else if (rec.getSid() == RowRecord.sid) + else if (rec.getSid () == RowRecord.sid) { if (isfirstrow) { - retval.rows = new RowRecordsAggregate(); + retval.rows = new RowRecordsAggregate (); rec = retval.rows; - retval.rows.construct(k, recs); + retval.rows.construct (k, recs); isfirstrow = false; } else @@ -225,13 +224,29 @@ rec = null; } } + else if (rec.getSid () == PrintGridlinesRecord.sid) + { + retval.printGridlines = (PrintGridlinesRecord) rec; + } + else if (rec.getSid () == HeaderRecord.sid) + { + retval.header = (HeaderRecord) rec; + } + else if (rec.getSid () == FooterRecord.sid) + { + retval.footer = (FooterRecord) rec; + } + else if (rec.getSid () == PrintSetupRecord.sid) + { + retval.printSetup = (PrintSetupRecord) rec; + } if (rec != null) { - records.add(rec); + records.add (rec); } } retval.records = records; - log.log(log.DEBUG, "sheet createSheet (existing file) exited"); + log.log (log.DEBUG, "sheet createSheet (existing file) exited"); return retval; } @@ -244,11 +259,11 @@ * @return Sheet object */ - public static Sheet createSheet(List records, int sheetnum) + public static Sheet createSheet (List records, int sheetnum) { - log.log(log.DEBUG, + log.log (log.DEBUG, "Sheet createSheet (exisiting file) assumed offset 0"); - return createSheet(records, sheetnum, 0); + return createSheet (records, sheetnum, 0); } /** @@ -259,99 +274,104 @@ * @return Sheet object with all values set to defaults */ - public static Sheet createSheet() + public static Sheet createSheet () { - log.log(log.DEBUG, "Sheet createsheet from scratch called"); - Sheet retval = new Sheet(); - ArrayList records = new ArrayList(30); + log.log (log.DEBUG, "Sheet createsheet from scratch called"); + Sheet retval = new Sheet (); + ArrayList records = new ArrayList (30); - records.add(retval.createBOF()); + records.add (retval.createBOF ()); // records.add(retval.createIndex()); - records.add(retval.createCalcMode()); - records.add(retval.createCalcCount()); - records.add(retval.createRefMode()); - records.add(retval.createIteration()); - records.add(retval.createDelta()); - records.add(retval.createSaveRecalc()); - records.add(retval.createPrintHeaders()); - records.add(retval.createPrintGridlines()); - retval.gridset = ( GridsetRecord ) retval.createGridset(); - records.add(retval.gridset); - records.add(retval.createGuts()); + records.add (retval.createCalcMode ()); + records.add (retval.createCalcCount ()); + records.add (retval.createRefMode ()); + records.add (retval.createIteration ()); + records.add (retval.createDelta ()); + records.add (retval.createSaveRecalc ()); + records.add (retval.createPrintHeaders ()); + retval.printGridlines = + (PrintGridlinesRecord) retval.createPrintGridlines (); + records.add (retval.printGridlines); + retval.gridset = (GridsetRecord) retval.createGridset (); + records.add (retval.gridset); + records.add (retval.createGuts ()); retval.defaultrowheight = - ( DefaultRowHeightRecord ) retval.createDefaultRowHeight(); - records.add(retval.defaultrowheight); - records.add(retval.createWSBool()); - records.add(retval.createHeader()); - records.add(retval.createFooter()); - records.add(retval.createHCenter()); - records.add(retval.createVCenter()); - records.add(retval.createPrintSetup()); + (DefaultRowHeightRecord) retval.createDefaultRowHeight (); + records.add (retval.defaultrowheight); + records.add (retval.createWSBool ()); + retval.header = (HeaderRecord) retval.createHeader (); + records.add (retval.header); + retval.footer = (FooterRecord) retval.createFooter (); + records.add (retval.footer); + records.add (retval.createHCenter ()); + records.add (retval.createVCenter ()); + retval.printSetup = (PrintSetupRecord) retval.createPrintSetup (); + records.add (retval.printSetup); retval.defaultcolwidth = - ( DefaultColWidthRecord ) retval.createDefaultColWidth(); - records.add(retval.defaultcolwidth); - retval.dims = ( DimensionsRecord ) retval.createDimensions(); + (DefaultColWidthRecord) retval.createDefaultColWidth (); + records.add (retval.defaultcolwidth); + retval.dims = (DimensionsRecord) retval.createDimensions (); retval.dimsloc = 19; - records.add(retval.dims); - records.add(retval.createWindowTwo()); - retval.setLoc(records.size() - 1); - records.add(retval.createSelection()); - records.add(retval.createEOF()); + records.add (retval.dims); + records.add (retval.createWindowTwo ()); + retval.setLoc (records.size () - 1); + records.add (retval.createSelection ()); + records.add (retval.createEOF ()); retval.records = records; - log.log(log.DEBUG, "Sheet createsheet from scratch exit"); + log.log (log.DEBUG, "Sheet createsheet from scratch exit"); return retval; } - private void checkCells() + private void checkCells () { if (cells == null) { - cells = new ValueRecordsAggregate(); - records.add(getDimsLoc() + 1, cells); + cells = new ValueRecordsAggregate (); + records.add (getDimsLoc () + 1, cells); } } - private void checkRows() + private void checkRows () { if (rows == null) { - rows = new RowRecordsAggregate(); - records.add(getDimsLoc() + 1, rows); + rows = new RowRecordsAggregate (); + records.add (getDimsLoc () + 1, rows); } } - public int addMergedRegion(short rowFrom, short colFrom, short rowTo, + public int addMergedRegion (short rowFrom, short colFrom, short rowTo, short colTo) { if (merged == null) { - merged = ( MergeCellsRecord ) createMergedCells(); - mergedloc = records.size() - 1; - records.add(records.size() - 1, merged); + merged = (MergeCellsRecord) createMergedCells (); + mergedloc = records.size () - 1; + records.add (records.size () - 1, merged); } - return merged.addArea(rowFrom, colFrom, rowTo, colTo); + return merged.addArea (rowFrom, colFrom, rowTo, colTo); } - public void removeMergedRegion(int index) + public void removeMergedRegion (int index) { - merged.removeAreaAt(index); - if (merged.getNumAreas() == 0) + merged.removeAreaAt (index); + if (merged.getNumAreas () == 0) { merged = null; - records.remove(mergedloc); + records.remove (mergedloc); mergedloc = 0; } } - public MergeCellsRecord.MergedRegion getMergedRegionAt(int index) + public MergeCellsRecord.MergedRegion getMergedRegionAt (int index) { - return merged.getAreaAt(index); + return merged.getAreaAt (index); } - public int getNumMergedRegions() + public int getNumMergedRegions () { - return merged.getNumAreas(); + return merged.getNumAreas (); } /** @@ -370,33 +390,32 @@ * @see org.apache.poi.hssf.record.SSTRecord */ - public void convertLabelRecords(Workbook wb) + public void convertLabelRecords (Workbook wb) { - log.log(log.DEBUG, "convertLabelRecords called"); + log.log (log.DEBUG, "convertLabelRecords called"); if (containsLabels) { - for (int k = 0; k < records.size(); k++) + for (int k = 0; k < records.size (); k++) { - Record rec = ( Record ) records.get(k); + Record rec = (Record) records.get (k); - if (rec.getSid() == LabelRecord.sid) + if (rec.getSid () == LabelRecord.sid) { - LabelRecord oldrec = ( LabelRecord ) rec; + LabelRecord oldrec = (LabelRecord) rec; - records.remove(k); - LabelSSTRecord newrec = new LabelSSTRecord(); - int stringid = - wb.addSSTString(oldrec.getValue()); + records.remove (k); + LabelSSTRecord newrec = new LabelSSTRecord (); + int stringid = wb.addSSTString (oldrec.getValue ()); - newrec.setRow(oldrec.getRow()); - newrec.setColumn(oldrec.getColumn()); - newrec.setXFIndex(oldrec.getXFIndex()); - newrec.setSSTIndex(stringid); - records.add(k, newrec); + newrec.setRow (oldrec.getRow ()); + newrec.setColumn (oldrec.getColumn ()); + newrec.setXFIndex (oldrec.getXFIndex ()); + newrec.setSSTIndex (stringid); + records.add (k, newrec); } } } - log.log(log.DEBUG, "convertLabelRecords exit"); + log.log (log.DEBUG, "convertLabelRecords exit"); } /** @@ -406,20 +425,20 @@ * @see org.apache.poi.hssf.record.Record */ - public int getNumRecords() + public int getNumRecords () { - checkCells(); - checkRows(); - log.log(log.DEBUG, "Sheet.getNumRecords"); - log.logFormatted(log.DEBUG, "returning % + % + % - 2 = %", new int[] - { - records.size(), cells.getPhysicalNumberOfCells(), - rows.getPhysicalNumberOfRows(), - records.size() + cells.getPhysicalNumberOfCells() - + rows.getPhysicalNumberOfRows() - 2 - }); - return records.size() + cells.getPhysicalNumberOfCells() - + rows.getPhysicalNumberOfRows() - 2; + checkCells (); + checkRows (); + log.log (log.DEBUG, "Sheet.getNumRecords"); + log.logFormatted (log.DEBUG, "returning % + % + % - 2 = %", new int[] + { + records.size (), cells.getPhysicalNumberOfCells (), + rows.getPhysicalNumberOfRows (), + records.size () + cells.getPhysicalNumberOfCells () + + rows.getPhysicalNumberOfRows () - 2} + ); + return records.size () + cells.getPhysicalNumberOfCells () + + rows.getPhysicalNumberOfRows () - 2; } /** @@ -430,20 +449,20 @@ * @see org.apache.poi.hssf.record.DimensionsRecord */ - public void setDimensions(short firstrow, short firstcol, short lastrow, + public void setDimensions (short firstrow, short firstcol, short lastrow, short lastcol) { - log.log(log.DEBUG, "Sheet.setDimensions"); - log.log(log.DEBUG, - (new StringBuffer("firstrow")).append(firstrow) - .append("firstcol").append(firstcol).append("lastrow") - .append(lastrow).append("lastcol").append(lastcol) - .toString()); - dims.setFirstCol(firstcol); - dims.setFirstRow(firstrow); - dims.setLastCol(lastcol); - dims.setLastRow(lastrow); - log.log(log.DEBUG, "Sheet.setDimensions exiting"); + log.log (log.DEBUG, "Sheet.setDimensions"); + log.log (log.DEBUG, + (new StringBuffer ("firstrow")).append (firstrow). + append ("firstcol").append (firstcol).append ("lastrow"). + append (lastrow).append ("lastcol").append (lastcol). + toString ()); + dims.setFirstCol (firstcol); + dims.setFirstRow (firstrow); + dims.setLastCol (lastcol); + dims.setLastRow (lastrow); + log.log (log.DEBUG, "Sheet.setDimensions exiting"); } /** @@ -462,10 +481,10 @@ * */ - public void setLoc(int loc) + public void setLoc (int loc) { valueRecIterator = null; - log.log(log.DEBUG, "sheet.setLoc(): " + loc); + log.log (log.DEBUG, "sheet.setLoc(): " + loc); this.loc = loc; } @@ -474,9 +493,9 @@ * */ - public int getLoc() + public int getLoc () { - log.log(log.DEBUG, "sheet.getLoc():" + loc); + log.log (log.DEBUG, "sheet.getLoc():" + loc); return loc; } @@ -487,7 +506,7 @@ * @param offset the offset of the sheet's BOF within the file. */ - public void setPreOffset(int offset) + public void setPreOffset (int offset) { this.preoffset = offset; } @@ -499,7 +518,7 @@ * @return offset the offset of the sheet's BOF within the file. */ - public int getPreOffset() + public int getPreOffset () { return preoffset; } @@ -512,15 +531,15 @@ * */ - public byte [] serialize() + public byte[] serialize () { - log.log(log.DEBUG, "Sheet.serialize"); + log.log (log.DEBUG, "Sheet.serialize"); // addDBCellRecords(); - byte[] retval = null; + byte[]retval = null; // ArrayList bytes = new ArrayList(4096); - int arraysize = getSize(); + int arraysize = getSize (); int pos = 0; // for (int k = 0; k < records.size(); k++) @@ -534,16 +553,15 @@ // log.debug((new StringBuffer("arraysize=")).append(arraysize) // .toString()); // } - retval = new byte[ arraysize ]; - for (int k = 0; k < records.size(); k++) + retval = new byte[arraysize]; + for (int k = 0; k < records.size (); k++) { // byte[] rec = (( byte [] ) bytes.get(k)); // System.arraycopy(rec, 0, retval, pos, rec.length); - pos += (( Record ) records.get(k)).serialize(pos, - retval); // rec.length; + pos += ((Record) records.get (k)).serialize (pos, retval); // rec.length; } - log.log(log.DEBUG, "Sheet.serialize returning " + retval); + log.log (log.DEBUG, "Sheet.serialize returning " + retval); return retval; } @@ -556,9 +574,9 @@ * */ - public int serialize(int offset, byte [] data) + public int serialize (int offset, byte[]data) { - log.log(log.DEBUG, "Sheet.serialize using offsets"); + log.log (log.DEBUG, "Sheet.serialize using offsets"); // addDBCellRecords(); // ArrayList bytes = new ArrayList(4096); @@ -576,15 +594,14 @@ // log.debug((new StringBuffer("arraysize=")).append(arraysize) // .toString()); // } - for (int k = 0; k < records.size(); k++) + for (int k = 0; k < records.size (); k++) { // byte[] rec = (( byte [] ) bytes.get(k)); // System.arraycopy(rec, 0, data, offset + pos, rec.length); - pos += (( Record ) records.get(k)).serialize(pos + offset, - data); // rec.length; + pos += ((Record) records.get (k)).serialize (pos + offset, data); // rec.length; } - log.log(log.DEBUG, "Sheet.serialize returning "); + log.log (log.DEBUG, "Sheet.serialize returning "); return pos; } @@ -596,16 +613,16 @@ * @see org.apache.poi.hssf.record.RowRecord */ - public RowRecord createRow(int row) + public RowRecord createRow (int row) { - log.log(log.DEBUG, "create row number " + row); - RowRecord rowrec = new RowRecord(); + log.log (log.DEBUG, "create row number " + row); + RowRecord rowrec = new RowRecord (); - rowrec.setRowNumber(( short ) row); - rowrec.setHeight(( short ) 0xff); - rowrec.setOptimize(( short ) 0x0); - rowrec.setOptionFlags(( short ) 0x0); - rowrec.setXFIndex(( short ) 0x0); + rowrec.setRowNumber ((short) row); + rowrec.setHeight ((short) 0xff); + rowrec.setOptimize ((short) 0x0); + rowrec.setOptionFlags ((short) 0x0); + rowrec.setXFIndex ((short) 0x0); return rowrec; } @@ -619,19 +636,19 @@ * @see org.apache.poi.hssf.record.SSTRecord */ - public LabelSSTRecord createLabelSST(short row, short col, int index) + public LabelSSTRecord createLabelSST (short row, short col, int index) { - log.logFormatted(log.DEBUG, "create labelsst row,col,index %,%,%", + log.logFormatted (log.DEBUG, "create labelsst row,col,index %,%,%", new int[] { - row, col, index - }); - LabelSSTRecord rec = new LabelSSTRecord(); - - rec.setRow(row); - rec.setColumn(col); - rec.setSSTIndex(index); - rec.setXFIndex(( short ) 0x0f); + row, col, index} + ); + LabelSSTRecord rec = new LabelSSTRecord (); + + rec.setRow (row); + rec.setColumn (col); + rec.setSSTIndex (index); + rec.setXFIndex ((short) 0x0f); return rec; } @@ -645,19 +662,19 @@ * @return NumberRecord for that row, col containing that value as added to the sheet */ - public NumberRecord createNumber(short row, short col, double value) + public NumberRecord createNumber (short row, short col, double value) { - log.logFormatted(log.DEBUG, "create number row,col,value %,%,%", + log.logFormatted (log.DEBUG, "create number row,col,value %,%,%", new double[] { - row, col, value - }); - NumberRecord rec = new NumberRecord(); - - rec.setRow(( short ) row); - rec.setColumn(col); - rec.setValue(value); - rec.setXFIndex(( short ) 0x0f); + row, col, value} + ); + NumberRecord rec = new NumberRecord (); + + rec.setRow ((short) row); + rec.setColumn (col); + rec.setValue (value); + rec.setXFIndex ((short) 0x0f); return rec; } @@ -668,17 +685,17 @@ * @param col - the column the BlankRecord is a member of */ - public BlankRecord createBlank(short row, short col) + public BlankRecord createBlank (short row, short col) { - log.logFormatted(log.DEBUG, "create blank row,col %,%", new short[] + log.logFormatted (log.DEBUG, "create blank row,col %,%", new short[] { - row, col - }); - BlankRecord rec = new BlankRecord(); + row, col} + ); + BlankRecord rec = new BlankRecord (); - rec.setRow(( short ) row); - rec.setColumn(col); - rec.setXFIndex(( short ) 0x0f); + rec.setRow ((short) row); + rec.setColumn (col); + rec.setXFIndex ((short) 0x0f); return rec; } @@ -692,29 +709,29 @@ * @return bogus/useless formula record */ - public FormulaRecord createFormula(short row, short col, String formula) + public FormulaRecord createFormula (short row, short col, String formula) { - log.logFormatted(log.DEBUG, "create formula row,col,formula %,%,%", + log.logFormatted (log.DEBUG, "create formula row,col,formula %,%,%", new short[] { - row, col - }, formula); - FormulaRecord rec = new FormulaRecord(); - - rec.setRow(row); - rec.setColumn(col); - rec.setOptions(( short ) 2); - rec.setValue(0); - rec.setXFIndex(( short ) 0x0f); - Ptg[] ptg = FormulaUtil.parseFormula(formula); + row, col} + , formula); + FormulaRecord rec = new FormulaRecord (); + + rec.setRow (row); + rec.setColumn (col); + rec.setOptions ((short) 2); + rec.setValue (0); + rec.setXFIndex ((short) 0x0f); + Ptg[]ptg = FormulaUtil.parseFormula (formula); int size = 0; for (int k = 0; k < ptg.length; k++) { - size += ptg[ k ].getSize(); - rec.pushExpressionToken(ptg[ k ]); + size += ptg[k].getSize (); + rec.pushExpressionToken (ptg[k]); } - rec.setExpressionLength(( short ) size); + rec.setExpressionLength ((short) size); return rec; } @@ -731,24 +748,24 @@ * @param col the cell value record itself. */ - public void addValueRecord(short row, CellValueRecordInterface col) + public void addValueRecord (short row, CellValueRecordInterface col) { - checkCells(); - log.logFormatted(log.DEBUG, "add value record row,loc %,%", new int[] + checkCells (); + log.logFormatted (log.DEBUG, "add value record row,loc %,%", new int[] { - row, loc - }); - DimensionsRecord d = ( DimensionsRecord ) records.get(getDimsLoc()); + row, loc} + ); + DimensionsRecord d = (DimensionsRecord) records.get (getDimsLoc ()); - if (col.getColumn() > d.getLastCol()) + if (col.getColumn () > d.getLastCol ()) { - d.setLastCol(( short ) (col.getColumn() + 1)); + d.setLastCol ((short) (col.getColumn () + 1)); } - if (col.getColumn() < d.getFirstCol()) + if (col.getColumn () < d.getFirstCol ()) { - d.setFirstCol(col.getColumn()); + d.setFirstCol (col.getColumn ()); } - cells.insertCell(col); + cells.insertCell (col); /* * for (int k = loc; k < records.size(); k++) @@ -784,16 +801,16 @@ * @see org.apache.poi.hssf.record.CellValueRecordInterface */ - public void removeValueRecord(short row, CellValueRecordInterface col) + public void removeValueRecord (short row, CellValueRecordInterface col) { - checkCells(); - log.logFormatted(log.DEBUG, "remove value record row,dimsloc %,%", + checkCells (); + log.logFormatted (log.DEBUG, "remove value record row,dimsloc %,%", new int[] { - row, dimsloc - }); + row, dimsloc} + ); loc = dimsloc; - cells.removeCell(col); + cells.removeCell (col); /* * for (int k = loc; k < records.size(); k++) @@ -827,12 +844,12 @@ * be added. */ - public void replaceValueRecord(CellValueRecordInterface newval) + public void replaceValueRecord (CellValueRecordInterface newval) { - checkCells(); - setLoc(dimsloc); - log.log(log.DEBUG, "replaceValueRecord "); - cells.insertCell(newval); + checkCells (); + setLoc (dimsloc); + log.log (log.DEBUG, "replaceValueRecord "); + cells.insertCell (newval); /* * CellValueRecordInterface oldval = getNextValueRecord(); @@ -864,23 +881,23 @@ * @see #setLoc(int) */ - public void addRow(RowRecord row) + public void addRow (RowRecord row) { - checkRows(); - log.log(log.DEBUG, "addRow "); - DimensionsRecord d = ( DimensionsRecord ) records.get(getDimsLoc()); + checkRows (); + log.log (log.DEBUG, "addRow "); + DimensionsRecord d = (DimensionsRecord) records.get (getDimsLoc ()); - if (row.getRowNumber() > d.getLastRow()) + if (row.getRowNumber () > d.getLastRow ()) { - d.setLastRow(row.getRowNumber() + 1); + d.setLastRow (row.getRowNumber () + 1); } - if (row.getRowNumber() < d.getFirstRow()) + if (row.getRowNumber () < d.getFirstRow ()) { - d.setFirstRow(row.getRowNumber()); + d.setFirstRow (row.getRowNumber ()); } //IndexRecord index = null; - rows.insertRow(row); + rows.insertRow (row); /* * for (int k = loc; k < records.size(); k++) @@ -917,7 +934,7 @@ * } * } */ - log.log(log.DEBUG, "exit addRow"); + log.log (log.DEBUG, "exit addRow"); } /** @@ -928,13 +945,13 @@ * @param row the row record to remove */ - public void removeRow(RowRecord row) + public void removeRow (RowRecord row) { - checkRows(); + checkRows (); // IndexRecord index = null; - setLoc(getDimsLoc()); - rows.removeRow(row); + setLoc (getDimsLoc ()); + rows.removeRow (row); /* * for (int k = loc; k < records.size(); k++) @@ -975,18 +992,18 @@ * @see #setLoc(int) */ - public CellValueRecordInterface getNextValueRecord() + public CellValueRecordInterface getNextValueRecord () { - log.log(log.DEBUG, "getNextValue loc= " + loc); + log.log (log.DEBUG, "getNextValue loc= " + loc); if (valueRecIterator == null) { - valueRecIterator = cells.getIterator(); + valueRecIterator = cells.getIterator (); } - if (!valueRecIterator.hasNext()) + if (!valueRecIterator.hasNext ()) { return null; } - return ( CellValueRecordInterface ) valueRecIterator.next(); + return (CellValueRecordInterface) valueRecIterator.next (); /* * if (this.getLoc() < records.size()) @@ -1062,18 +1079,18 @@ * */ - public RowRecord getNextRow() + public RowRecord getNextRow () { - log.log(log.DEBUG, "getNextRow loc= " + loc); + log.log (log.DEBUG, "getNextRow loc= " + loc); if (rowRecIterator == null) { - rowRecIterator = rows.getIterator(); + rowRecIterator = rows.getIterator (); } - if (!rowRecIterator.hasNext()) + if (!rowRecIterator.hasNext ()) { return null; } - return ( RowRecord ) rowRecIterator.next(); + return (RowRecord) rowRecIterator.next (); /* if (this.getLoc() < records.size()) { @@ -1104,13 +1121,13 @@ * @param rownum which row to return (careful with LOC) * @return RowRecord representing the next row record or NULL if there are no more * @see #setLoc(int) - * + */ - public RowRecord getRow(short rownum) + public RowRecord getRow (short rownum) { - log.log(log.DEBUG, "getNextRow loc= " + loc); - return rows.getRow(rownum); + log.log (log.DEBUG, "getNextRow loc= " + loc); + return rows.getRow (rownum); /* * if (this.getLoc() < records.size()) @@ -1139,7 +1156,7 @@ * */ - public void addDBCellRecords() + public void addDBCellRecords () { int offset = 0; int recnum = 0; @@ -1149,19 +1166,19 @@ IndexRecord index = null; // ArrayList rowOffsets = new ArrayList(); - IntList rowOffsets = new IntList(); + IntList rowOffsets = new IntList (); - for (recnum = 0; recnum < records.size(); recnum++) + for (recnum = 0; recnum < records.size (); recnum++) { - Record rec = ( Record ) records.get(recnum); + Record rec = (Record) records.get (recnum); - if (rec.getSid() == IndexRecord.sid) + if (rec.getSid () == IndexRecord.sid) { - index = ( IndexRecord ) rec; + index = (IndexRecord) rec; } - if (rec.getSid() != RowRecord.sid) + if (rec.getSid () != RowRecord.sid) { - offset += rec.serialize().length; + offset += rec.serialize ().length; } else { @@ -1170,29 +1187,29 @@ } // First Row Record - for (; recnum < records.size(); recnum++) + for (; recnum < records.size (); recnum++) { - Record rec = ( Record ) records.get(recnum); + Record rec = (Record) records.get (recnum); - if (rec.getSid() == RowRecord.sid) + if (rec.getSid () == RowRecord.sid) { rownum++; - rowOffsets.add(offset); + rowOffsets.add (offset); if ((rownum % 32) == 0) { // if this is the last rec in a dbcell block // find the next row or last value record - for (int rn = recnum; rn < records.size(); rn++) + for (int rn = recnum; rn < records.size (); rn++) { - rec = ( Record ) records.get(rn); - if ((!rec.isInValueSection()) - || (rec.getSid() == RowRecord.sid)) + rec = (Record) records.get (rn); + if ((!rec.isInValueSection ()) + || (rec.getSid () == RowRecord.sid)) { // here is the next row or last value record - records.add(rn, - createDBCell(offset, rowOffsets, + records.add (rn, + createDBCell (offset, rowOffsets, index)); recnum = rn; break; @@ -1203,46 +1220,46 @@ { } } - if (!rec.isInValueSection()) + if (!rec.isInValueSection ()) { - records.add(recnum, createDBCell(offset, rowOffsets, index)); + records.add (recnum, createDBCell (offset, rowOffsets, index)); break; } - offset += rec.serialize().length; + offset += rec.serialize ().length; } } /** not currently used */ - private DBCellRecord createDBCell(int offset, IntList rowoffsets, + private DBCellRecord createDBCell (int offset, IntList rowoffsets, IndexRecord index) { - DBCellRecord rec = new DBCellRecord(); + DBCellRecord rec = new DBCellRecord (); - rec.setRowOffset(offset - rowoffsets.get(0)); + rec.setRowOffset (offset - rowoffsets.get (0)); // test hack - rec.addCellOffset(( short ) 0x0); + rec.addCellOffset ((short) 0x0); // end test hack - addDbCellToIndex(offset, index); + addDbCellToIndex (offset, index); return rec; } /** not currently used */ - private void addDbCellToIndex(int offset, IndexRecord index) + private void addDbCellToIndex (int offset, IndexRecord index) { - int numdbcells = index.getNumDbcells() + 1; + int numdbcells = index.getNumDbcells () + 1; - index.addDbcell(offset + preoffset); + index.addDbcell (offset + preoffset); // stupid but whenever we add an offset that causes everything to be shifted down 4 for (int k = 0; k < numdbcells; k++) { - int dbval = index.getDbcellAt(k); + int dbval = index.getDbcellAt (k); - index.setDbcell(k, dbval + 4); + index.setDbcell (k, dbval + 4); } } @@ -1253,18 +1270,18 @@ * @return record containing a BOFRecord */ - protected Record createBOF() + protected Record createBOF () { - BOFRecord retval = new BOFRecord(); + BOFRecord retval = new BOFRecord (); - retval.setVersion(( short ) 0x600); - retval.setType(( short ) 0x010); + retval.setVersion ((short) 0x600); + retval.setType ((short) 0x010); // retval.setBuild((short)0x10d3); - retval.setBuild(( short ) 0x0dbb); - retval.setBuildYear(( short ) 1996); - retval.setHistoryBitMask(0xc1); - retval.setRequiredVersion(0x6); + retval.setBuild ((short) 0x0dbb); + retval.setBuildYear ((short) 1996); + retval.setHistoryBitMask (0xc1); + retval.setRequiredVersion (0x6); return retval; } @@ -1275,12 +1292,12 @@ * @return record containing a IndexRecord */ - protected Record createIndex() + protected Record createIndex () { - IndexRecord retval = new IndexRecord(); + IndexRecord retval = new IndexRecord (); - retval.setFirstRow(0); // must be set explicitly - retval.setLastRowAdd1(0); + retval.setFirstRow (0); // must be set explicitly + retval.setLastRowAdd1 (0); return retval; } @@ -1291,11 +1308,11 @@ * @return record containing a CalcModeRecord */ - protected Record createCalcMode() + protected Record createCalcMode () { - CalcModeRecord retval = new CalcModeRecord(); + CalcModeRecord retval = new CalcModeRecord (); - retval.setCalcMode(( short ) 1); + retval.setCalcMode ((short) 1); return retval; } @@ -1306,11 +1323,11 @@ * @return record containing a CalcCountRecord */ - protected Record createCalcCount() + protected Record createCalcCount () { - CalcCountRecord retval = new CalcCountRecord(); + CalcCountRecord retval = new CalcCountRecord (); - retval.setIterations(( short ) 0x64); // default 64 iterations + retval.setIterations ((short) 0x64); // default 64 iterations return retval; } @@ -1321,11 +1338,11 @@ * @return record containing a RefModeRecord */ - protected Record createRefMode() + protected Record createRefMode () { - RefModeRecord retval = new RefModeRecord(); + RefModeRecord retval = new RefModeRecord (); - retval.setMode(retval.USE_A1_MODE); + retval.setMode (retval.USE_A1_MODE); return retval; } @@ -1336,11 +1353,11 @@ * @return record containing a IterationRecord */ - protected Record createIteration() + protected Record createIteration () { - IterationRecord retval = new IterationRecord(); + IterationRecord retval = new IterationRecord (); - retval.setIteration(false); + retval.setIteration (false); return retval; } @@ -1351,11 +1368,11 @@ * @return record containing a DeltaRecord */ - protected Record createDelta() + protected Record createDelta () { - DeltaRecord retval = new DeltaRecord(); + DeltaRecord retval = new DeltaRecord (); - retval.setMaxChange((( double ) 0.0010)); + retval.setMaxChange (((double) 0.0010)); return retval; } @@ -1366,11 +1383,11 @@ * @return record containing a SaveRecalcRecord */ - protected Record createSaveRecalc() + protected Record createSaveRecalc () { - SaveRecalcRecord retval = new SaveRecalcRecord(); + SaveRecalcRecord retval = new SaveRecalcRecord (); - retval.setRecalc(true); + retval.setRecalc (true); return retval; } @@ -1381,11 +1398,11 @@ * @return record containing a PrintHeadersRecord */ - protected Record createPrintHeaders() + protected Record createPrintHeaders () { - PrintHeadersRecord retval = new PrintHeadersRecord(); + PrintHeadersRecord retval = new PrintHeadersRecord (); - retval.setPrintHeaders(false); + retval.setPrintHeaders (false); return retval; } @@ -1398,11 +1415,11 @@ * @return record containing a PrintGridlinesRecord */ - protected Record createPrintGridlines() + protected Record createPrintGridlines () { - PrintGridlinesRecord retval = new PrintGridlinesRecord(); + PrintGridlinesRecord retval = new PrintGridlinesRecord (); - retval.setPrintGridlines(false); + retval.setPrintGridlines (false); return retval; } @@ -1413,11 +1430,11 @@ * @return record containing a GridsetRecord */ - protected Record createGridset() + protected Record createGridset () { - GridsetRecord retval = new GridsetRecord(); + GridsetRecord retval = new GridsetRecord (); - retval.setGridset(true); + retval.setGridset (true); return retval; } @@ -1428,14 +1445,14 @@ * @return record containing a GutsRecordRecord */ - protected Record createGuts() + protected Record createGuts () { - GutsRecord retval = new GutsRecord(); + GutsRecord retval = new GutsRecord (); - retval.setLeftRowGutter(( short ) 0); - retval.setTopColGutter(( short ) 0); - retval.setRowLevelMax(( short ) 0); - retval.setColLevelMax(( short ) 0); + retval.setLeftRowGutter ((short) 0); + retval.setTopColGutter ((short) 0); + retval.setRowLevelMax ((short) 0); + retval.setColLevelMax ((short) 0); return retval; } @@ -1446,12 +1463,12 @@ * @return record containing a DefaultRowHeightRecord */ - protected Record createDefaultRowHeight() + protected Record createDefaultRowHeight () { - DefaultRowHeightRecord retval = new DefaultRowHeightRecord(); + DefaultRowHeightRecord retval = new DefaultRowHeightRecord (); - retval.setOptionFlags(( short ) 0); - retval.setRowHeight(( short ) 0xff); + retval.setOptionFlags ((short) 0); + retval.setRowHeight ((short) 0xff); return retval; } @@ -1462,12 +1479,12 @@ * @return record containing a WSBoolRecord */ - protected Record createWSBool() + protected Record createWSBool () { - WSBoolRecord retval = new WSBoolRecord(); + WSBoolRecord retval = new WSBoolRecord (); - retval.setWSBool1(( byte ) 0x4); - retval.setWSBool2(( byte ) 0xffffffc1); + retval.setWSBool1 ((byte) 0x4); + retval.setWSBool2 ((byte) 0xffffffc1); return retval; } @@ -1478,12 +1495,12 @@ * @return record containing a HeaderRecord */ - protected Record createHeader() + protected Record createHeader () { - HeaderRecord retval = new HeaderRecord(); + HeaderRecord retval = new HeaderRecord (); - retval.setHeaderLength(( byte ) 0); - retval.setHeader(null); + retval.setHeaderLength ((byte) 0); + retval.setHeader (null); return retval; } @@ -1494,12 +1511,12 @@ * @return record containing a FooterRecord */ - protected Record createFooter() + protected Record createFooter () { - FooterRecord retval = new FooterRecord(); + FooterRecord retval = new FooterRecord (); - retval.setFooterLength(( byte ) 0); - retval.setFooter(null); + retval.setFooterLength ((byte) 0); + retval.setFooter (null); return retval; } @@ -1510,11 +1527,11 @@ * @return record containing a HCenterRecord */ - protected Record createHCenter() + protected Record createHCenter () { - HCenterRecord retval = new HCenterRecord(); + HCenterRecord retval = new HCenterRecord (); - retval.setHCenter(false); + retval.setHCenter (false); return retval; } @@ -1525,11 +1542,11 @@ * @return record containing a VCenterRecord */ - protected Record createVCenter() + protected Record createVCenter () { - VCenterRecord retval = new VCenterRecord(); + VCenterRecord retval = new VCenterRecord (); - retval.setVCenter(false); + retval.setVCenter (false); return retval; } @@ -1540,21 +1557,21 @@ * @return record containing a PrintSetupRecord */ - protected Record createPrintSetup() + protected Record createPrintSetup () { - PrintSetupRecord retval = new PrintSetupRecord(); + PrintSetupRecord retval = new PrintSetupRecord (); - retval.setPaperSize(( short ) 1); - retval.setScale(( short ) 100); - retval.setPageStart(( short ) 1); - retval.setFitWidth(( short ) 1); - retval.setFitHeight(( short ) 1); - retval.setOptions(( short ) 2); - retval.setHResolution(( short ) 300); - retval.setVResolution(( short ) 300); - retval.setHeaderMargin(( double ) 0.5); - retval.setFooterMargin(( double ) 0.5); - retval.setCopies(( short ) 0); + retval.setPaperSize ((short) 1); + retval.setScale ((short) 100); + retval.setPageStart ((short) 1); + retval.setFitWidth ((short) 1); + retval.setFitHeight ((short) 1); + retval.setOptions ((short) 2); + retval.setHResolution ((short) 300); + retval.setVResolution ((short) 300); + retval.setHeaderMargin ((double) 0.5); + retval.setFooterMargin ((double) 0.5); + retval.setCopies ((short) 0); return retval; } @@ -1565,11 +1582,11 @@ * @return record containing a DefaultColWidthRecord */ - protected Record createDefaultColWidth() + protected Record createDefaultColWidth () { - DefaultColWidthRecord retval = new DefaultColWidthRecord(); + DefaultColWidthRecord retval = new DefaultColWidthRecord (); - retval.setColWidth(( short ) 8); + retval.setColWidth ((short) 8); return retval; } @@ -1579,13 +1596,13 @@ * @return record containing a ColumnInfoRecord */ - protected Record createColInfo() + protected Record createColInfo () { - ColumnInfoRecord retval = new ColumnInfoRecord(); + ColumnInfoRecord retval = new ColumnInfoRecord (); - retval.setColumnWidth(( short ) 0x8); - retval.setOptions(( short ) 6); - retval.setXFIndex(( short ) 0x0f); + retval.setColumnWidth ((short) 0x8); + retval.setOptions ((short) 6); + retval.setXFIndex ((short) 0x0f); return retval; } @@ -1594,9 +1611,9 @@ * @return default column width */ - public short getDefaultColumnWidth() + public short getDefaultColumnWidth () { - return defaultcolwidth.getColWidth(); + return defaultcolwidth.getColWidth (); } /** @@ -1604,9 +1621,9 @@ * @return true if printed */ - public boolean isGridsPrinted() + public boolean isGridsPrinted () { - return !gridset.getGridset(); + return !gridset.getGridset (); } /** @@ -1614,9 +1631,9 @@ * @param value True if gridlines printed. */ - public void setGridsPrinted(boolean value) + public void setGridsPrinted (boolean value) { - gridset.setGridset(!value); + gridset.setGridset (!value); } /** @@ -1624,18 +1641,18 @@ * @param dcw default column width */ - public void setDefaultColumnWidth(short dcw) + public void setDefaultColumnWidth (short dcw) { - defaultcolwidth.setColWidth(dcw); + defaultcolwidth.setColWidth (dcw); } /** * set the default row height for the sheet (if the rows do not define their own height) */ - public void setDefaultRowHeight(short dch) + public void setDefaultRowHeight (short dch) { - defaultrowheight.setRowHeight(dch); + defaultrowheight.setRowHeight (dch); } /** @@ -1643,9 +1660,9 @@ * @return default row height */ - public short getDefaultRowHeight() + public short getDefaultRowHeight () { - return defaultrowheight.getRowHeight(); + return defaultrowheight.getRowHeight (); } /** @@ -1657,7 +1674,7 @@ * @return column width in units of 1/20th of a point (twips?) */ - public short getColumnWidth(short column) + public short getColumnWidth (short column) { short retval = 0; ColumnInfoRecord ci = null; @@ -1665,11 +1682,11 @@ if (columnSizes != null) { - for (k = 0; k < columnSizes.size(); k++) + for (k = 0; k < columnSizes.size (); k++) { - ci = ( ColumnInfoRecord ) columnSizes.get(k); - if ((ci.getFirstColumn() >= column) - && (ci.getLastColumn() <= column)) + ci = (ColumnInfoRecord) columnSizes.get (k); + if ((ci.getFirstColumn () >= column) + && (ci.getLastColumn () <= column)) { break; } @@ -1678,11 +1695,11 @@ } if (ci != null) { - retval = ci.getColumnWidth(); + retval = ci.getColumnWidth (); } else { - retval = defaultcolwidth.getColWidth(); + retval = defaultcolwidth.getColWidth (); } return retval; } @@ -1693,22 +1710,22 @@ * @param width (in units of 1/20th of a character width) */ - public void setColumnWidth(short column, short width) + public void setColumnWidth (short column, short width) { ColumnInfoRecord ci = null; int k = 0; if (columnSizes == null) { - columnSizes = new ArrayList(); + columnSizes = new ArrayList (); } //int cioffset = getDimsLoc() - columnSizes.size(); - for (k = 0; k < columnSizes.size(); k++) + for (k = 0; k < columnSizes.size (); k++) { - ci = ( ColumnInfoRecord ) columnSizes.get(k); - if ((ci.getFirstColumn() >= column) - && (ci.getLastColumn() <= column)) + ci = (ColumnInfoRecord) columnSizes.get (k); + if ((ci.getFirstColumn () >= column) + && (ci.getLastColumn () <= column)) { break; } @@ -1716,39 +1733,39 @@ } if (ci != null) { - if (ci.getColumnWidth() == width) + if (ci.getColumnWidth () == width) { // do nothing...the cell's width is equal to what we're setting it to. } - else if ((ci.getFirstColumn() == column) - && (ci.getLastColumn() == column)) + else if ((ci.getFirstColumn () == column) + && (ci.getLastColumn () == column)) { // if its only for this cell then - ci.setColumnWidth(width); // who cares, just change the width + ci.setColumnWidth (width); // who cares, just change the width } - else if ((ci.getFirstColumn() == column) - || (ci.getLastColumn() == column)) + else if ((ci.getFirstColumn () == column) + || (ci.getLastColumn () == column)) { // okay so the width is different but the first or last column == the column we'return setting // we'll just divide the info and create a new one - if (ci.getFirstColumn() == column) + if (ci.getFirstColumn () == column) { - ci.setFirstColumn(( short ) (column + 1)); + ci.setFirstColumn ((short) (column + 1)); } else { - ci.setLastColumn(( short ) (column - 1)); + ci.setLastColumn ((short) (column - 1)); } - ColumnInfoRecord nci = ( ColumnInfoRecord ) createColInfo(); + ColumnInfoRecord nci = (ColumnInfoRecord) createColInfo (); - nci.setFirstColumn(column); - nci.setLastColumn(column); - nci.setOptions(ci.getOptions()); - nci.setXFIndex(ci.getXFIndex()); - nci.setColumnWidth(width); - columnSizes.add(k, nci); - records.add((1 + getDimsLoc() - columnSizes.size()) + k, nci); + nci.setFirstColumn (column); + nci.setLastColumn (column); + nci.setOptions (ci.getOptions ()); + nci.setXFIndex (ci.getXFIndex ()); + nci.setColumnWidth (width); + columnSizes.add (k, nci); + records.add ((1 + getDimsLoc () - columnSizes.size ()) + k, nci); dimsloc++; } } @@ -1756,13 +1773,13 @@ { // okay so there ISN'T a column info record that cover's this column so lets create one! - ColumnInfoRecord nci = ( ColumnInfoRecord ) createColInfo(); + ColumnInfoRecord nci = (ColumnInfoRecord) createColInfo (); - nci.setFirstColumn(column); - nci.setLastColumn(column); - nci.setColumnWidth(width); - columnSizes.add(k, nci); - records.add((1 + getDimsLoc() - columnSizes.size()) + k, nci); + nci.setFirstColumn (column); + nci.setLastColumn (column); + nci.setColumnWidth (width); + columnSizes.add (k, nci); + records.add ((1 + getDimsLoc () - columnSizes.size ()) + k, nci); dimsloc++; } } @@ -1775,14 +1792,14 @@ * @return record containing a DimensionsRecord */ - protected Record createDimensions() + protected Record createDimensions () { - DimensionsRecord retval = new DimensionsRecord(); + 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 + 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; } @@ -1799,16 +1816,16 @@ * @return record containing a WindowTwoRecord */ - protected Record createWindowTwo() + protected Record createWindowTwo () { - WindowTwoRecord retval = new WindowTwoRecord(); + WindowTwoRecord retval = new WindowTwoRecord (); - retval.setOptions(( short ) 0x6b6); - retval.setTopRow(( short ) 0); - retval.setLeftCol(( short ) 0); - retval.setHeaderColor(0x40); - retval.setPageBreakZoom(( short ) 0); - retval.setNormalZoom(( short ) 0); + retval.setOptions ((short) 0x6b6); + retval.setTopRow ((short) 0); + retval.setLeftCol ((short) 0); + retval.setHeaderColor (0x40); + retval.setPageBreakZoom ((short) 0); + retval.setNormalZoom ((short) 0); return retval; } @@ -1820,22 +1837,22 @@ * @return record containing a SelectionRecord */ - protected Record createSelection() + protected Record createSelection () { - SelectionRecord retval = new SelectionRecord(); + SelectionRecord retval = new SelectionRecord (); - retval.setPane(( byte ) 0x3); - retval.setActiveCellCol(( short ) 0x0); - retval.setActiveCellRow(( short ) 0x0); - retval.setNumRefs(( short ) 0x0); + retval.setPane ((byte) 0x3); + retval.setActiveCellCol ((short) 0x0); + retval.setActiveCellRow ((short) 0x0); + retval.setNumRefs ((short) 0x0); return retval; } - protected Record createMergedCells() + protected Record createMergedCells () { - MergeCellsRecord retval = new MergeCellsRecord(); + MergeCellsRecord retval = new MergeCellsRecord (); - retval.setNumAreas(( short ) 0); + retval.setNumAreas ((short) 0); return retval; } @@ -1846,9 +1863,9 @@ * @return record containing a EOFRecord */ - protected Record createEOF() + protected Record createEOF () { - return new EOFRecord(); + return new EOFRecord (); } /** @@ -1856,9 +1873,9 @@ * @return location in the array of records of the DimensionsRecord */ - public int getDimsLoc() + public int getDimsLoc () { - log.log(log.DEBUG, "getDimsLoc dimsloc= " + dimsloc); + log.log (log.DEBUG, "getDimsLoc dimsloc= " + dimsloc); return dimsloc; } @@ -1866,27 +1883,27 @@ * in the event the record is a dimensions record, resets both the loc index and dimsloc index */ - public void checkDimsLoc(Record rec, int recloc) + public void checkDimsLoc (Record rec, int recloc) { - if (rec.getSid() == DimensionsRecord.sid) + if (rec.getSid () == DimensionsRecord.sid) { loc = recloc; dimsloc = recloc; } } - public int getSize() + public int getSize () { int retval = 0; - for (int k = 0; k < records.size(); k++) + for (int k = 0; k < records.size (); k++) { - retval += (( Record ) records.get(k)).getRecordSize(); + retval += ((Record) records.get (k)).getRecordSize (); } return retval; } - public List getRecords() + public List getRecords () { return records; } @@ -1895,7 +1912,7 @@ * Gets the gridset record for this sheet. */ - public GridsetRecord getGridsetRecord() + public GridsetRecord getGridsetRecord () { return gridset; } @@ -1904,17 +1921,90 @@ * Returns the first occurance of a record matching a particular sid. */ - public Record findFirstRecordBySid(short sid) + public Record findFirstRecordBySid (short sid) { - for (Iterator iterator = records.iterator(); iterator.hasNext(); ) + for (Iterator iterator = records.iterator (); iterator.hasNext ();) { - Record record = ( Record ) iterator.next(); + Record record = (Record) iterator.next (); - if (record.getSid() == sid) + if (record.getSid () == sid) { return record; } } return null; } + + /** + * Returns the HeaderRecord. + * @return HeaderRecord for the sheet. + */ + public HeaderRecord getHeader () + { + return header; + } + + /** + * Sets the HeaderRecord. + * @param newHeader The new HeaderRecord for the sheet. + */ + public void setHeader (HeaderRecord newHeader) + { + header = newHeader; + } + + /** + * Returns the FooterRecord. + * @return FooterRecord for the sheet. + */ + public FooterRecord getFooter () + { + return footer; + } + + /** + * Sets the FooterRecord. + * @param newFooter The new FooterRecord for the sheet. + */ + public void setFooter (FooterRecord newFooter) + { + footer = newFooter; + } + + /** + * Returns the PrintSetupRecord. + * @return PrintSetupRecord for the sheet. + */ + public PrintSetupRecord getPrintSetup () + { + return printSetup; + } + + /** + * Sets the PrintSetupRecord. + * @param newPrintSetup The new PrintSetupRecord for the sheet. + */ + public void setPrintSetup (PrintSetupRecord newPrintSetup) + { + printSetup = newPrintSetup; + } + + /** + * Returns the PrintGridlinesRecord. + * @return PrintGridlinesRecord for the sheet. + */ + public PrintGridlinesRecord getPrintGridlines () + { + return printGridlines; + } + + /** + * Sets the PrintGridlinesRecord. + * @param newPrintGridlines The new PrintGridlinesRecord for the sheet. + */ + public void setPrintGridlines (PrintGridlinesRecord newPrintGridlines) + { + printGridlines = newPrintGridlines; + + } } Index: src/java/org/apache/poi/hssf/usermodel/HSSFSheet.java =================================================================== RCS file: /home/cvspublic/jakarta-poi/src/java/org/apache/poi/hssf/usermodel/HSSFSheet.java,v retrieving revision 1.6 diff -u -b -r1.6 HSSFSheet.java --- src/java/org/apache/poi/hssf/usermodel/HSSFSheet.java 27 Apr 2002 01:48:26 -0000 1.6 +++ src/java/org/apache/poi/hssf/usermodel/HSSFSheet.java 30 Apr 2002 19:59:58 -0000 @@ -1,3 +1,4 @@ + /* ==================================================================== * The Apache Software License, Version 1.1 * @@ -59,15 +60,11 @@ */ package org.apache.poi.hssf.usermodel; +import org.apache.poi.util.POILogFactory; import org.apache.poi.hssf.model.Sheet; import org.apache.poi.hssf.model.Workbook; -import org.apache.poi.hssf.record.CellValueRecordInterface; -import org.apache.poi.hssf.record.Record; -import org.apache.poi.hssf.record.RowRecord; -import org.apache.poi.hssf.record.VCenterRecord; -import org.apache.poi.hssf.record.WSBoolRecord; +import org.apache.poi.hssf.record.*; import org.apache.poi.hssf.util.Region; -import org.apache.poi.util.POILogFactory; import org.apache.poi.util.POILogger; import java.util.Iterator; @@ -77,7 +74,7 @@ * High level representation of a worksheet. * @author Andrew C. Oliver (acoliver at apache dot org) * @author Glen Stampoultzis (glens at apache.org) - * @author Libin Roman (romal at vistaportal.com) + * @version 1.0-pre */ public class HSSFSheet @@ -135,6 +132,11 @@ setPropertiesFromSheet(sheet); } + /** private default constructor prevents bogus initializationless construction */ + + private HSSFSheet() + { + } /** * used internally to set the properties given a Sheet object @@ -169,7 +171,6 @@ hrow = getRow(cval.getRow()); } lastrow = hrow; - log.log(DEBUG, "record id = "+ Integer.toHexString(((Record)cval).getSid())); hrow.createCellFromRecord(cval); cval = sheet.getNextValueRecord(); log.log(DEBUG, "record took ", @@ -235,7 +236,7 @@ while (iter.hasNext()) { - HSSFCell cell = (HSSFCell) iter.next(); + HSSFCell cell = ( HSSFCell ) iter.next(); sheet.removeValueRecord(row.getRowNum(), cell.getCellValueRecord()); @@ -253,7 +254,7 @@ int rownum = lastrow - 1; HSSFRow r = getRow(rownum); - while (r == null && rownum >= 0) + while (r == null) { r = getRow(--rownum); } @@ -269,14 +270,10 @@ int rownum = firstrow + 1; HSSFRow r = getRow(rownum); - while (r == null && rownum <= getLastRowNum()) + while (r == null) { r = getRow(++rownum); } - - if (rownum > getLastRowNum()) - return -1; - return rownum; } @@ -314,8 +311,8 @@ { HSSFRow row = new HSSFRow(); - row.setRowNum((short) rownum); - return (HSSFRow) rows.get(row); + row.setRowNum(( short ) rownum); + return ( HSSFRow ) rows.get(row); } /** @@ -348,6 +345,26 @@ } /** + * Seems to be unused (gjs) + * + * used internally to add cells from a high level row to the low level model + * @param row the row object to represent in low level RowRecord. + */ + private void addCellsFromRow(HSSFRow row) + { + Iterator iter = row.cellIterator(); + + // for (int k = 0; k < row.getPhysicalNumberOfCells(); k++) + while (iter.hasNext()) + { + HSSFCell cell = + ( HSSFCell ) iter.next(); // row.getPhysicalCellAt(k); + + sheet.addValueRecord(row.getRowNum(), cell.getCellValueRecord()); + } + } + + /** * set the width (in units of 1/256th of a character width) * @param column - the column to set (0-based) * @param width - the width in units of 1/256th of a character width @@ -383,7 +400,7 @@ /** * get the default row height for the sheet (if the rows do not define their own height) in * twips (1/20 of a point) - * @return default row height + * @retun default row height */ public short getDefaultRowHeight() @@ -432,7 +449,7 @@ public void setDefaultRowHeightInPoints(float height) { - sheet.setDefaultRowHeight((short) (height * 20)); + sheet.setDefaultRowHeight(( short ) (height * 20)); } /** @@ -463,9 +480,9 @@ public int addMergedRegion(Region region) { - return sheet.addMergedRegion((short) region.getRowFrom(), + return sheet.addMergedRegion(( short ) region.getRowFrom(), region.getColumnFrom(), - (short) region.getRowTo(), + ( short ) region.getRowTo(), region.getColumnTo()); } @@ -477,7 +494,7 @@ public void setVerticallyCenter(boolean value) { VCenterRecord record = - (VCenterRecord) sheet.findFirstRecordBySid(VCenterRecord.sid); + ( VCenterRecord ) sheet.findFirstRecordBySid(VCenterRecord.sid); record.setVCenter(value); } @@ -489,7 +506,7 @@ public boolean getVerticallyCenter(boolean value) { VCenterRecord record = - (VCenterRecord) sheet.findFirstRecordBySid(VCenterRecord.sid); + ( VCenterRecord ) sheet.findFirstRecordBySid(VCenterRecord.sid); return record.getVCenter(); } @@ -526,7 +543,7 @@ } /** - * @return an iterator of the PHYSICAL rows. Meaning the 3rd element may not + * @returns an iterator of the PHYSICAL rows. Meaning the 3rd element may not * be the third row if say for instance the second row is undefined. */ @@ -554,7 +571,7 @@ public void setAlternativeExpression(boolean b) { WSBoolRecord record = - (WSBoolRecord) sheet.findFirstRecordBySid(WSBoolRecord.sid); + ( WSBoolRecord ) sheet.findFirstRecordBySid(WSBoolRecord.sid); record.setAlternateExpression(b); } @@ -567,7 +584,7 @@ public void setAlternativeFormula(boolean b) { WSBoolRecord record = - (WSBoolRecord) sheet.findFirstRecordBySid(WSBoolRecord.sid); + ( WSBoolRecord ) sheet.findFirstRecordBySid(WSBoolRecord.sid); record.setAlternateFormula(b); } @@ -580,7 +597,7 @@ public void setAutobreaks(boolean b) { WSBoolRecord record = - (WSBoolRecord) sheet.findFirstRecordBySid(WSBoolRecord.sid); + ( WSBoolRecord ) sheet.findFirstRecordBySid(WSBoolRecord.sid); record.setAutobreaks(b); } @@ -593,7 +610,7 @@ public void setDialog(boolean b) { WSBoolRecord record = - (WSBoolRecord) sheet.findFirstRecordBySid(WSBoolRecord.sid); + ( WSBoolRecord ) sheet.findFirstRecordBySid(WSBoolRecord.sid); record.setDialog(b); } @@ -607,7 +624,7 @@ public void setDisplayGuts(boolean b) { WSBoolRecord record = - (WSBoolRecord) sheet.findFirstRecordBySid(WSBoolRecord.sid); + ( WSBoolRecord ) sheet.findFirstRecordBySid(WSBoolRecord.sid); record.setDisplayGuts(b); } @@ -620,7 +637,7 @@ public void setFitToPage(boolean b) { WSBoolRecord record = - (WSBoolRecord) sheet.findFirstRecordBySid(WSBoolRecord.sid); + ( WSBoolRecord ) sheet.findFirstRecordBySid(WSBoolRecord.sid); record.setFitToPage(b); } @@ -633,7 +650,7 @@ public void setRowSumsBelow(boolean b) { WSBoolRecord record = - (WSBoolRecord) sheet.findFirstRecordBySid(WSBoolRecord.sid); + ( WSBoolRecord ) sheet.findFirstRecordBySid(WSBoolRecord.sid); record.setRowSumsBelow(b); } @@ -646,7 +663,7 @@ public void setRowSumsRight(boolean b) { WSBoolRecord record = - (WSBoolRecord) sheet.findFirstRecordBySid(WSBoolRecord.sid); + ( WSBoolRecord ) sheet.findFirstRecordBySid(WSBoolRecord.sid); record.setRowSumsRight(b); } @@ -658,7 +675,7 @@ public boolean getAlternateExpression() { - return ((WSBoolRecord) sheet.findFirstRecordBySid(WSBoolRecord.sid)) + return (( WSBoolRecord ) sheet.findFirstRecordBySid(WSBoolRecord.sid)) .getAlternateExpression(); } @@ -669,7 +686,7 @@ public boolean getAlternateFormula() { - return ((WSBoolRecord) sheet.findFirstRecordBySid(WSBoolRecord.sid)) + return (( WSBoolRecord ) sheet.findFirstRecordBySid(WSBoolRecord.sid)) .getAlternateFormula(); } @@ -680,7 +697,7 @@ public boolean getAutobreaks() { - return ((WSBoolRecord) sheet.findFirstRecordBySid(WSBoolRecord.sid)) + return (( WSBoolRecord ) sheet.findFirstRecordBySid(WSBoolRecord.sid)) .getAutobreaks(); } @@ -691,7 +708,7 @@ public boolean getDialog() { - return ((WSBoolRecord) sheet.findFirstRecordBySid(WSBoolRecord.sid)) + return (( WSBoolRecord ) sheet.findFirstRecordBySid(WSBoolRecord.sid)) .getDialog(); } @@ -703,7 +720,7 @@ public boolean getDisplayGuts() { - return ((WSBoolRecord) sheet.findFirstRecordBySid(WSBoolRecord.sid)) + return (( WSBoolRecord ) sheet.findFirstRecordBySid(WSBoolRecord.sid)) .getDisplayGuts(); } @@ -714,7 +731,7 @@ public boolean getFitToPage() { - return ((WSBoolRecord) sheet.findFirstRecordBySid(WSBoolRecord.sid)) + return (( WSBoolRecord ) sheet.findFirstRecordBySid(WSBoolRecord.sid)) .getFitToPage(); } @@ -725,7 +742,7 @@ public boolean getRowSumsBelow() { - return ((WSBoolRecord) sheet.findFirstRecordBySid(WSBoolRecord.sid)) + return (( WSBoolRecord ) sheet.findFirstRecordBySid(WSBoolRecord.sid)) .getRowSumsBelow(); } @@ -736,7 +753,48 @@ public boolean getRowSumsRight() { - return ((WSBoolRecord) sheet.findFirstRecordBySid(WSBoolRecord.sid)) + return (( WSBoolRecord ) sheet.findFirstRecordBySid(WSBoolRecord.sid)) .getRowSumsRight(); + } + + /** + * Returns whether gridlines are printed. + * @return Gridlines are printed + */ + public boolean isPrintGridlines() { + return getSheet().getPrintGridlines().getPrintGridlines(); + } + + /** + * Turns on or off the printing of gridlines. + * @param newPrintGridlines boolean to turn on or off the printing of + * gridlines + */ + public void setPrintGridlines(boolean newPrintGridlines) { + getSheet().getPrintGridlines().setPrintGridlines(newPrintGridlines); + } + + /** + * Gets the print setup object. + * @return The user model for the print setup object. + */ + public HSSFPrintSetup getPrintSetup() { + return new HSSFPrintSetup(getSheet().getPrintSetup()); + } + + /** + * Gets the user model for the document header. + * @return The Document header. + */ + public HSSFHeader getHeader() { + return new HSSFHeader(getSheet().getHeader()); + } + + /** + * Gets the user model for the document footer. + * @return The Document footer. + */ + public HSSFFooter getFooter() { + return new HSSFFooter(getSheet().getFooter()); } }