Attachment #35755 for bug #62162

View | Details | Raw Unified | Return to bug 62162
Collapse All | Expand All




        
        // ugly typecast - TODO - make spreadsheet version more easily accessible
        SpreadsheetVersion ssVersion = ((FormulaParsingWorkbook)_workbook).getSpreadsheetVersion();

        NameType part1refType = classifyCellReference(refStrPart1, ssVersion);
        switch (part1refType) {
            case BAD_CELL_OR_NAMED_RANGE:
                return ErrorEval.REF_INVALID;
            case NAMED_RANGE:
            	int sheetIndex = _bookEvaluator.getWorkbook().getSheetIndex(sheetName);
                EvaluationName nm = ((FormulaParsingWorkbook)_workbook).getName(refStrPart1, sheetIndex);
                if(!nm.isRange()){
                    throw new RuntimeException("Specified name '" + refStrPart1 + "' is not a range as expected.");
                }

Return to bug 62162

Lines 199-211 Link Here

(-)OperationEvaluationContext.java (-2 / +2 lines)
199		199
200	// ugly typecast - TODO - make spreadsheet version more easily accessible	200	// ugly typecast - TODO - make spreadsheet version more easily accessible
201	SpreadsheetVersion ssVersion = ((FormulaParsingWorkbook)_workbook).getSpreadsheetVersion();	201	SpreadsheetVersion ssVersion = ((FormulaParsingWorkbook)_workbook).getSpreadsheetVersion();
202
203	NameType part1refType = classifyCellReference(refStrPart1, ssVersion);	202	NameType part1refType = classifyCellReference(refStrPart1, ssVersion);
204	switch (part1refType) {	203	switch (part1refType) {
205	case BAD_CELL_OR_NAMED_RANGE:	204	case BAD_CELL_OR_NAMED_RANGE:
206	return ErrorEval.REF_INVALID;	205	return ErrorEval.REF_INVALID;
207	case NAMED_RANGE:	206	case NAMED_RANGE:
208	EvaluationName nm = ((FormulaParsingWorkbook)_workbook).getName(refStrPart1, _sheetIndex);	207	int sheetIndex = _bookEvaluator.getWorkbook().getSheetIndex(sheetName);
		208	EvaluationName nm = ((FormulaParsingWorkbook)_workbook).getName(refStrPart1, sheetIndex);
209	if(!nm.isRange()){	209	if(!nm.isRange()){
210	throw new RuntimeException("Specified name '" + refStrPart1 + "' is not a range as expected.");	210	throw new RuntimeException("Specified name '" + refStrPart1 + "' is not a range as expected.");
211	}	211	}