_list.add(new RefSubRecord(extBookIndex, firstSheetIndex, lastSheetIndex)); return _list.size() - 1;
/** * @param extBookIndex external sheet reference index * * @return -1 if not found */ public int findRefIndexFromExtBookIndex(int extBookIndex) { int nItems = _list.size(); for (int i = 0; i < nItems; i++) { if (getRef(i).getExtBookIndex() == extBookIndex) { return i; } } return -1; }
public int getRefIxForSheet(int externalBookIndex, int firstSheetIndex, int lastSheetIndex) { int nItems = _list.size(); for (int i = 0; i < nItems; i++) { RefSubRecord ref = getRef(i); if (ref.getExtBookIndex() != externalBookIndex) { continue; } if (ref.getFirstSheetIndex() == firstSheetIndex && ref.getLastSheetIndex() == lastSheetIndex) { return i; } } return -1; }
_list.add(new RefSubRecord(extBookIndex, firstSheetIndex, lastSheetIndex)); return _list.size() - 1;
_list.add(new RefSubRecord(extBookIndex, firstSheetIndex, lastSheetIndex)); return _list.size() - 1;
_list.add(new RefSubRecord(extBookIndex, firstSheetIndex, lastSheetIndex)); return _list.size() - 1;
/** * Returns the last sheet that the reference applies to, or * -1 if the referenced sheet can't be found, or -2 if the * reference is workbook scoped. * For a single sheet reference, the first and last should be * the same. * * @param extRefIndex external sheet reference index * * @return the last sheet that the reference applies to, or * -1 if the referenced sheet can't be found, or -2 if the * reference is workbook scoped. */ public int getLastSheetIndexFromRefIndex(int extRefIndex) { return getRef(extRefIndex).getLastSheetIndex(); }
/** * @param extBookIndex external sheet reference index * * @return -1 if not found */ public int findRefIndexFromExtBookIndex(int extBookIndex) { int nItems = _list.size(); for (int i = 0; i < nItems; i++) { if (getRef(i).getExtBookIndex() == extBookIndex) { return i; } } return -1; }
public int getFirstSheetIndexFromRefIndex(int extRefIndex) { return getRef(extRefIndex).getFirstSheetIndex(); }
public int getExtbookIndexFromRefIndex(int refIndex) { return getRef(refIndex).getExtBookIndex(); }
/** * Returns the first sheet that the reference applies to, or * -1 if the referenced sheet can't be found, or -2 if the * reference is workbook scoped. * * @param extRefIndex external sheet reference index * * @return the first sheet that the reference applies to, or * -1 if the referenced sheet can't be found, or -2 if the * reference is workbook scoped */ public int getFirstSheetIndexFromRefIndex(int extRefIndex) { return getRef(extRefIndex).getFirstSheetIndex(); }
public int getExtbookIndexFromRefIndex(int refIndex) { return getRef(refIndex).getExtBookIndex(); }
public int getFirstSheetIndexFromRefIndex(int extRefIndex) { return getRef(extRefIndex).getFirstSheetIndex(); }
public void removeSheet(int sheetIdx) { int nItems = _list.size(); for (int i = 0; i < nItems; i++) { RefSubRecord refSubRecord = _list.get(i); if(refSubRecord.getFirstSheetIndex() == sheetIdx && refSubRecord.getLastSheetIndex() == sheetIdx) { // removing the entry would mess up the sheet index in Formula of NameRecord _list.set(i, new RefSubRecord(refSubRecord.getExtBookIndex(), -1, -1)); } else if (refSubRecord.getFirstSheetIndex() > sheetIdx && refSubRecord.getLastSheetIndex() > sheetIdx) { _list.set(i, new RefSubRecord(refSubRecord.getExtBookIndex(), refSubRecord.getFirstSheetIndex()-1, refSubRecord.getLastSheetIndex()-1)); } } }
public String toString() { StringBuffer sb = new StringBuffer(); int nItems = _list.size(); sb.append("[EXTERNSHEET]\n"); sb.append(" numOfRefs = ").append(nItems).append("\n"); for (int i=0; i < nItems; i++) { sb.append("refrec #").append(i).append(": "); sb.append(getRef(i).toString()); sb.append('\n'); } sb.append("[/EXTERNSHEET]\n"); return sb.toString(); }
public String toString() { StringBuffer sb = new StringBuffer(); int nItems = _list.size(); sb.append("[EXTERNSHEET]\n"); sb.append(" numOfRefs = ").append(nItems).append("\n"); for (int i=0; i < nItems; i++) { sb.append("refrec #").append(i).append(": "); sb.append(getRef(i).toString()); sb.append('\n'); } sb.append("[/EXTERNSHEET]\n"); return sb.toString(); }
public int getRefIxForSheet(int externalBookIndex, int firstSheetIndex, int lastSheetIndex) { int nItems = _list.size(); for (int i = 0; i < nItems; i++) { RefSubRecord ref = getRef(i); if (ref.getExtBookIndex() != externalBookIndex) { continue; } if (ref.getFirstSheetIndex() == firstSheetIndex && ref.getLastSheetIndex() == lastSheetIndex) { return i; } } return -1; }
public ExternSheetRecord(RecordInputStream in) { _list = new ArrayList<RefSubRecord>(); int nItems = in.readShort(); for (int i = 0 ; i < nItems ; ++i) { RefSubRecord rec = new RefSubRecord(in); _list.add(rec); } }
public void serialize(LittleEndianOutput out) { int nItems = _list.size(); out.writeShort(nItems); for (int i = 0; i < nItems; i++) { getRef(i).serialize(out); } }
public void serialize(LittleEndianOutput out) { int nItems = _list.size(); out.writeShort(nItems); for (int i = 0; i < nItems; i++) { getRef(i).serialize(out); } }