public String toString() { StringBuilder buffer = new StringBuilder(); buffer.append("[").append(getRecordName()).append("]\n"); buffer.append("\t.numCF = ").append(getNumberOfConditionalFormats()).append("\n"); buffer.append("\t.needRecalc = ").append(getNeedRecalculation()).append("\n"); buffer.append("\t.id = ").append(getID()).append("\n"); buffer.append("\t.enclosingCellRange= ").append(getEnclosingCellRange()).append("\n"); buffer.append("\t.cfranges=["); for( int i=0; i<field_4_cell_ranges.countRanges(); i++) { buffer.append(i==0?"":",").append(field_4_cell_ranges.getCellRangeAddress(i)); } buffer.append("]\n"); buffer.append("[/").append(getRecordName()).append("]\n"); return buffer.toString(); }
public String toString() { StringBuffer sb = new StringBuffer(); sb.append("[DV]\n"); sb.append(" options=").append(Integer.toHexString(_option_flags)); sb.append(" title-prompt=").append(formatTextTitle(_promptTitle)); sb.append(" title-error=").append(formatTextTitle(_errorTitle)); sb.append(" text-prompt=").append(formatTextTitle(_promptText)); sb.append(" text-error=").append(formatTextTitle(_errorText)); sb.append("\n"); appendFormula(sb, "Formula 1:", _formula1); appendFormula(sb, "Formula 2:", _formula2); sb.append("Regions: "); int nRegions = _regions.countRanges(); for(int i=0; i<nRegions; i++) { if (i>0) { sb.append(", "); } CellRangeAddress addr = _regions.getCellRangeAddress(i); sb.append('(').append(addr.getFirstRow()).append(',').append(addr.getLastRow()); sb.append(',').append(addr.getFirstColumn()).append(',').append(addr.getLastColumn()).append(')'); } sb.append("\n"); sb.append("[/DV]"); return sb.toString(); }
public String toString() { StringBuffer buffer = new StringBuffer(); buffer.append("[CFHEADER]\n"); buffer.append(" .id = ").append(Integer.toHexString(sid)).append("\n"); buffer.append(" .numCF = ").append(getNumberOfConditionalFormats()).append("\n"); buffer.append(" .needRecalc = ").append(getNeedRecalculation()).append("\n"); buffer.append(" .enclosingCellRange= ").append(getEnclosingCellRange()).append("\n"); buffer.append(" .cfranges=["); for( int i=0; i<field_4_cell_ranges.countRanges(); i++) { buffer.append(i==0?"":",").append(field_4_cell_ranges.getCellRangeAddress(i).toString()); } buffer.append("]\n"); buffer.append("[/CFHEADER]\n"); return buffer.toString(); }
public String toString() { StringBuilder buffer = new StringBuilder(); buffer.append("[").append(getRecordName()).append("]\n"); buffer.append("\t.numCF = ").append(getNumberOfConditionalFormats()).append("\n"); buffer.append("\t.needRecalc = ").append(getNeedRecalculation()).append("\n"); buffer.append("\t.id = ").append(getID()).append("\n"); buffer.append("\t.enclosingCellRange= ").append(getEnclosingCellRange()).append("\n"); buffer.append("\t.cfranges=["); for( int i=0; i<field_4_cell_ranges.countRanges(); i++) { buffer.append(i==0?"":",").append(field_4_cell_ranges.getCellRangeAddress(i)); } buffer.append("]\n"); buffer.append("[/").append(getRecordName()).append("]\n"); return buffer.toString(); }
public String toString() { StringBuffer buffer = new StringBuffer(); buffer.append("[CFHEADER]\n"); buffer.append(" .id = ").append(Integer.toHexString(sid)).append("\n"); buffer.append(" .numCF = ").append(getNumberOfConditionalFormats()).append("\n"); buffer.append(" .needRecalc = ").append(getNeedRecalculation()).append("\n"); buffer.append(" .enclosingCellRange= ").append(getEnclosingCellRange()).append("\n"); buffer.append(" .cfranges=["); for( int i=0; i<field_4_cell_ranges.countRanges(); i++) { buffer.append(i==0?"":",").append(field_4_cell_ranges.getCellRangeAddress(i).toString()); } buffer.append("]\n"); buffer.append("[/CFHEADER]\n"); return buffer.toString(); }
public String toString() { StringBuffer sb = new StringBuffer(); sb.append("[DV]\n"); sb.append(" options=").append(Integer.toHexString(_option_flags)); sb.append(" title-prompt=").append(formatTextTitle(_promptTitle)); sb.append(" title-error=").append(formatTextTitle(_errorTitle)); sb.append(" text-prompt=").append(formatTextTitle(_promptText)); sb.append(" text-error=").append(formatTextTitle(_errorText)); sb.append("\n"); appendFormula(sb, "Formula 1:", _formula1); appendFormula(sb, "Formula 2:", _formula2); sb.append("Regions: "); int nRegions = _regions.countRanges(); for(int i=0; i<nRegions; i++) { if (i>0) { sb.append(", "); } CellRangeAddress addr = _regions.getCellRangeAddress(i); sb.append('(').append(addr.getFirstRow()).append(',').append(addr.getLastRow()); sb.append(',').append(addr.getFirstColumn()).append(',').append(addr.getLastColumn()).append(')'); } sb.append("\n"); sb.append("[/DV]"); return sb.toString(); }
public String toString() { StringBuffer sb = new StringBuffer(); sb.append("[DV]\n"); sb.append(" options=").append(Integer.toHexString(_option_flags)); sb.append(" title-prompt=").append(formatTextTitle(_promptTitle)); sb.append(" title-error=").append(formatTextTitle(_errorTitle)); sb.append(" text-prompt=").append(formatTextTitle(_promptText)); sb.append(" text-error=").append(formatTextTitle(_errorText)); sb.append("\n"); appendFormula(sb, "Formula 1:", _formula1); appendFormula(sb, "Formula 2:", _formula2); sb.append("Regions: "); int nRegions = _regions.countRanges(); for(int i=0; i<nRegions; i++) { if (i>0) { sb.append(", "); } CellRangeAddress addr = _regions.getCellRangeAddress(i); sb.append('(').append(addr.getFirstRow()).append(',').append(addr.getLastRow()); sb.append(',').append(addr.getFirstColumn()).append(',').append(addr.getLastColumn()).append(')'); } sb.append("\n"); sb.append("[/DV]"); return sb.toString(); }
public String toString() { StringBuffer sb = new StringBuffer(); sb.append("[DV]\n"); sb.append(" options=").append(Integer.toHexString(_option_flags)); sb.append(" title-prompt=").append(formatTextTitle(_promptTitle)); sb.append(" title-error=").append(formatTextTitle(_errorTitle)); sb.append(" text-prompt=").append(formatTextTitle(_promptText)); sb.append(" text-error=").append(formatTextTitle(_errorText)); sb.append("\n"); appendFormula(sb, "Formula 1:", _formula1); appendFormula(sb, "Formula 2:", _formula2); sb.append("Regions: "); int nRegions = _regions.countRanges(); for(int i=0; i<nRegions; i++) { if (i>0) { sb.append(", "); } CellRangeAddress addr = _regions.getCellRangeAddress(i); sb.append('(').append(addr.getFirstRow()).append(',').append(addr.getLastRow()); sb.append(',').append(addr.getFirstColumn()).append(',').append(addr.getLastColumn()).append(')'); } sb.append("\n"); sb.append("[/DV]"); return sb.toString(); }
String reference = addressListStatus.getCellRangeAddress(0).formatAsString(sheetName, true); name.setRefersToFormula(reference);