/// <summary> /// Verifies that workbook-scoped named ranges exist, and that they have /// valid range references. /// </summary> /// <exception cref="iClickerQuizPts.AppExceptions.MissingInvalidNmdRngException"> /// Caught and rethrown when there are problems with the validity of a /// workbook-scoped named range.</exception> public virtual void VerifyWbkScopedNames(params string[] nms) { for (int i = 0; i < nms.Length; i++) { string iClkrNm = nms[i]; if (!_nrWrppr.WorkbookScopedRangeExists(iClkrNm)) { MissingInvalidNmdRngException ex = new MissingInvalidNmdRngException(RangeScope.Wkbk, iClkrNm); throw ex; } } }
/// <summary> /// Verifies that worksheet-scoped named ranges exist, and that they have /// valid range references. /// </summary> /// <exception cref="iClickerQuizPts.AppExceptions.MissingInvalidNmdRngException"> /// Caught and rethrown when there are problems with the validity of a /// worksheet-scoped named range.</exception> public virtual void VerifyWshScopedNames(params string[] nms) { for (int i = 0; i < nms.Length; i++) { // Since this is the only sheet holding named ranges... string qzDataWshNm = Globals.Sheet1.Name; string iClikerNm = nms[i]; if (!_nrWrppr.WorksheetScopedRangeExists(qzDataWshNm, iClikerNm)) { MissingInvalidNmdRngException ex = new MissingInvalidNmdRngException(RangeScope.Wksheet, iClikerNm, qzDataWshNm); throw ex; } } }