public String toString() { StringBuffer buffer = new StringBuffer(); buffer.append("[TABLE]\n"); buffer.append(" .range = ").append(getRange().toString()).append("\n"); buffer.append(" .flags = ") .append(HexDump.byteToHex(field_5_flags)).append("\n"); buffer.append(" .alwaysClc= ").append(isAlwaysCalc()).append("\n"); buffer.append(" .reserved = ").append(HexDump.intToHex(field_6_res)).append("\n"); CellReference crRowInput = cr(field_7_rowInputRow, field_8_colInputRow); CellReference crColInput = cr(field_9_rowInputCol, field_10_colInputCol); buffer.append(" .rowInput = ").append(crRowInput.formatAsString()).append("\n"); buffer.append(" .colInput = ").append(crColInput.formatAsString()).append("\n"); buffer.append("[/TABLE]\n"); return buffer.toString(); }
public String toString() { StringBuffer buffer = new StringBuffer(); buffer.append("[TABLE]\n"); buffer.append(" .range = ").append(getRange().toString()).append("\n"); buffer.append(" .flags = ") .append(HexDump.byteToHex(field_5_flags)).append("\n"); buffer.append(" .alwaysClc= ").append(isAlwaysCalc()).append("\n"); buffer.append(" .reserved = ").append(HexDump.intToHex(field_6_res)).append("\n"); CellReference crRowInput = cr(field_7_rowInputRow, field_8_colInputRow); CellReference crColInput = cr(field_9_rowInputCol, field_10_colInputCol); buffer.append(" .rowInput = ").append(crRowInput.formatAsString()).append("\n"); buffer.append(" .colInput = ").append(crColInput.formatAsString()).append("\n"); buffer.append("[/TABLE]\n"); return buffer.toString(); }
/** * For the Convenience of Java Programmers maintaining pointers. * @see #setPrintArea(int, String) * @param sheetIndex Zero-based sheet index (0 = First Sheet) * @param startColumn Column to begin printarea * @param endColumn Column to end the printarea * @param startRow Row to begin the printarea * @param endRow Row to end the printarea */ public void setPrintArea(int sheetIndex, int startColumn, int endColumn, int startRow, int endRow) { //using absolute references because they don't get copied and pasted anyway CellReference cell = new CellReference(startRow, startColumn, true, true); String reference = cell.formatAsString(); cell = new CellReference(endRow, endColumn, true, true); reference = reference+":"+cell.formatAsString(); setPrintArea(sheetIndex, reference); }
/** * For the Convenience of Java Programmers maintaining pointers. * @see #setPrintArea(int, String) * @param sheetIndex Zero-based sheet index (0 = First Sheet) * @param startColumn Column to begin printarea * @param endColumn Column to end the printarea * @param startRow Row to begin the printarea * @param endRow Row to end the printarea */ public void setPrintArea(int sheetIndex, int startColumn, int endColumn, int startRow, int endRow) { //using absolute references because they don't get copied and pasted anyway CellReference cell = new CellReference(startRow, startColumn, true, true); String reference = cell.formatAsString(); cell = new CellReference(endRow, endColumn, true, true); reference = reference+":"+cell.formatAsString(); setPrintArea(sheetIndex, reference); }
/** * check if any shapes contain wrong data * At now(13.08.2010) check if patriarch contains 2 or more comments with same coordinates */ protected void preSerialize(){ Map<Integer, NoteRecord> tailRecords = _boundAggregate.getTailRecords(); /** * contains coordinates of comments we iterate over */ Set<String> coordinates = new HashSet<String>(tailRecords.size()); for(NoteRecord rec : tailRecords.values()){ String noteRef = new CellReference(rec.getRow(), rec.getColumn()).formatAsString(); // A1-style notation if(coordinates.contains(noteRef )){ throw new IllegalStateException("found multiple cell comments for cell " + noteRef ); } else { coordinates.add(noteRef); } } }
if ( cellValue == null || StringUtils.isEmpty(cellValue.toString())){ if ( dataExpectation.errorMessage != null && !StringUtils.isEmpty(dataExpectation.errorMessage)) { parseErrors.add(new ScorecardError(cellRef.formatAsString(), dataExpectation.errorMessage)); return; if ( method == null ) { if (cellValue != null && !StringUtils.isEmpty(cellValue.toString())) { parseErrors.add(new ScorecardError(cellRef.formatAsString(), "Unexpected Value! Wrong Datatype?")); ((Extension) dataExpectation.object).setValue(cellRef.formatAsString());