/** * @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 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 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; }
/** * @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 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 int getExtbookIndexFromRefIndex(int refIndex) { return getRef(refIndex).getExtBookIndex(); }
public int getRefIxForSheet(int externalBookIndex, int sheetIndex) { int nItems = _list.size(); for (int i = 0; i < nItems; i++) { RefSubRecord ref = getRef(i); if (ref.getExtBookIndex() != externalBookIndex) { continue; } if (ref.getFirstSheetIndex() == sheetIndex && ref.getLastSheetIndex() == sheetIndex) { return i; } } return -1; }
public int getExtbookIndexFromRefIndex(int refIndex) { return getRef(refIndex).getExtBookIndex(); }
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; }
/** * @param refIndex specifies the n-th refIndex * * @return the index of the SupBookRecord for this index */ public int getExtbookIndexFromRefIndex(int refIndex) { RefSubRecord refRec = getRef(refIndex); return refRec.getExtBookIndex(); }
/** * @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; }
/** * @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 sheetIndex) { int nItems = _list.size(); for (int i = 0; i < nItems; i++) { RefSubRecord ref = getRef(i); if (ref.getExtBookIndex() != externalBookIndex) { continue; } if (ref.getFirstSheetIndex() == sheetIndex && ref.getLastSheetIndex() == sheetIndex) { return i; } } return -1; }
/** * @param refIndex specifies the n-th refIndex * * @return the index of the SupBookRecord for this index */ public int getExtbookIndexFromRefIndex(int refIndex) { RefSubRecord refRec = getRef(refIndex); return refRec.getExtBookIndex(); }