public int resolveNameXIx(int refIndex, int definedNameIndex) { int extBookIndex = _externSheetRecord.getExtbookIndexFromRefIndex(refIndex); return _externalBookBlocks[extBookIndex].getNameIx(definedNameIndex); }
public String resolveNameXText(int refIndex, int definedNameIndex, InternalWorkbook workbook) { int extBookIndex = _externSheetRecord.getExtbookIndexFromRefIndex(refIndex); int firstTabIndex = _externSheetRecord.getFirstSheetIndexFromRefIndex(refIndex); if (firstTabIndex == -1) { // The referenced sheet could not be found throw new RuntimeException("Referenced sheet could not be found"); } // Does it exist via the external book block? ExternalBookBlock externalBook = _externalBookBlocks[extBookIndex]; if (externalBook._externalNameRecords.length > definedNameIndex) { return _externalBookBlocks[extBookIndex].getNameText(definedNameIndex); } else if (firstTabIndex == -2) { // Workbook scoped name, not actually external after all NameRecord nr = getNameRecord(definedNameIndex); int sheetNumber = nr.getSheetNumber(); StringBuilder text = new StringBuilder(64); if (sheetNumber > 0) { String sheetName = workbook.getSheetName(sheetNumber - 1); SheetNameFormatter.appendFormat(text, sheetName); text.append("!"); } text.append(nr.getNameText()); return text.toString(); } else { throw new ArrayIndexOutOfBoundsException( "Ext Book Index relative but beyond the supported length, was " + extBookIndex + " but maximum is " + _externalBookBlocks.length ); } }
public String[] getExternalBookAndSheetName(int extRefIndex) { int ebIx = _externSheetRecord.getExtbookIndexFromRefIndex(extRefIndex); SupBookRecord ebr = _externalBookBlocks[ebIx].getExternalBookRecord(); if (!ebr.isExternalReferences()) { return null; } // Sheet name only applies if not a global reference int shIx1 = _externSheetRecord.getFirstSheetIndexFromRefIndex(extRefIndex); int shIx2 = _externSheetRecord.getLastSheetIndexFromRefIndex(extRefIndex); String firstSheetName = null; String lastSheetName = null; if (shIx1 >= 0) { firstSheetName = ebr.getSheetNames()[shIx1]; } if (shIx2 >= 0) { lastSheetName = ebr.getSheetNames()[shIx2]; } if (shIx1 == shIx2) { return new String[]{ ebr.getURL(), firstSheetName }; } else { return new String[]{ ebr.getURL(), firstSheetName, lastSheetName }; } }
public String resolveNameXText(int refIndex, int definedNameIndex) { int extBookIndex = _externSheetRecord.getExtbookIndexFromRefIndex(refIndex); return _externalBookBlocks[extBookIndex].getNameText(definedNameIndex); } public int resolveNameXIx(int refIndex, int definedNameIndex) {
public String resolveNameXText(int refIndex, int definedNameIndex) { int extBookIndex = _externSheetRecord.getExtbookIndexFromRefIndex(refIndex); return _externalBookBlocks[extBookIndex].getNameText(definedNameIndex); } public int resolveNameXIx(int refIndex, int definedNameIndex) {
public int resolveNameXIx(int refIndex, int definedNameIndex) { int extBookIndex = _externSheetRecord.getExtbookIndexFromRefIndex(refIndex); return _externalBookBlocks[extBookIndex].getNameIx(definedNameIndex); }
public int resolveNameXIx(int refIndex, int definedNameIndex) { int extBookIndex = _externSheetRecord.getExtbookIndexFromRefIndex(refIndex); return _externalBookBlocks[extBookIndex].getNameIx(definedNameIndex); }
public int resolveNameXIx(int refIndex, int definedNameIndex) { int extBookIndex = _externSheetRecord.getExtbookIndexFromRefIndex(refIndex); return _externalBookBlocks[extBookIndex].getNameIx(definedNameIndex); }
public String resolveNameXText(int refIndex, int definedNameIndex, InternalWorkbook workbook) { int extBookIndex = _externSheetRecord.getExtbookIndexFromRefIndex(refIndex); int firstTabIndex = _externSheetRecord.getFirstSheetIndexFromRefIndex(refIndex); if (firstTabIndex == -1) { // The referenced sheet could not be found throw new RuntimeException("Referenced sheet could not be found"); } // Does it exist via the external book block? ExternalBookBlock externalBook = _externalBookBlocks[extBookIndex]; if (externalBook._externalNameRecords.length > definedNameIndex) { return _externalBookBlocks[extBookIndex].getNameText(definedNameIndex); } else if (firstTabIndex == -2) { // Workbook scoped name, not actually external after all NameRecord nr = getNameRecord(definedNameIndex); int sheetNumber = nr.getSheetNumber(); StringBuilder text = new StringBuilder(64); if (sheetNumber > 0) { String sheetName = workbook.getSheetName(sheetNumber - 1); SheetNameFormatter.appendFormat(text, sheetName); text.append("!"); } text.append(nr.getNameText()); return text.toString(); } else { throw new ArrayIndexOutOfBoundsException( "Ext Book Index relative but beyond the supported length, was " + extBookIndex + " but maximum is " + _externalBookBlocks.length ); } }
public String[] getExternalBookAndSheetName(int extRefIndex) { int ebIx = _externSheetRecord.getExtbookIndexFromRefIndex(extRefIndex); SupBookRecord ebr = _externalBookBlocks[ebIx].getExternalBookRecord(); if (!ebr.isExternalReferences()) { return null; } // Sheet name only applies if not a global reference int shIx = _externSheetRecord.getFirstSheetIndexFromRefIndex(extRefIndex); String usSheetName = null; if(shIx >= 0) { usSheetName = ebr.getSheetNames()[shIx]; } return new String[] { ebr.getURL(), usSheetName, }; }
public String[] getExternalBookAndSheetName(int extRefIndex) { int ebIx = _externSheetRecord.getExtbookIndexFromRefIndex(extRefIndex); SupBookRecord ebr = _externalBookBlocks[ebIx].getExternalBookRecord(); if (!ebr.isExternalReferences()) { return null; } // Sheet name only applies if not a global reference int shIx = _externSheetRecord.getFirstSheetIndexFromRefIndex(extRefIndex); String usSheetName = null; if(shIx >= 0) { usSheetName = ebr.getSheetNames()[shIx]; } return new String[] { ebr.getURL(), usSheetName, }; }
public String[] getExternalBookAndSheetName(int extRefIndex) { int ebIx = _externSheetRecord.getExtbookIndexFromRefIndex(extRefIndex); SupBookRecord ebr = _externalBookBlocks[ebIx].getExternalBookRecord(); if (!ebr.isExternalReferences()) { return null; } // Sheet name only applies if not a global reference int shIx1 = _externSheetRecord.getFirstSheetIndexFromRefIndex(extRefIndex); int shIx2 = _externSheetRecord.getLastSheetIndexFromRefIndex(extRefIndex); String firstSheetName = null; String lastSheetName = null; if (shIx1 >= 0) { firstSheetName = ebr.getSheetNames()[shIx1]; } if (shIx2 >= 0) { lastSheetName = ebr.getSheetNames()[shIx2]; } if (shIx1 == shIx2) { return new String[]{ ebr.getURL(), firstSheetName }; } else { return new String[]{ ebr.getURL(), firstSheetName, lastSheetName }; } }