public static bool IsSet(IgnoredErrorType errorType, CT_IgnoredError error)
{
switch (errorType)
{
case IgnoredErrorType.CalculatedColumn:
return(error.calculatedColumn);
case IgnoredErrorType.EmptyCellReference:
return(error.emptyCellReference);
case IgnoredErrorType.EvaluationError:
return(error.evalError);
case IgnoredErrorType.Formula:
return(error.formula);
case IgnoredErrorType.FormulaRange:
return(error.formulaRange);
case IgnoredErrorType.ListDataValidation:
return(error.listDataValidation);
case IgnoredErrorType.NumberStoredAsText:
return(error.numberStoredAsText);
case IgnoredErrorType.TwoDigitTextYear:
return(error.twoDigitTextYear);
case IgnoredErrorType.UnlockedFormula:
return(error.unlockedFormula);
default:
throw new InvalidOperationException();
}
}
public static void AddIgnoredErrors(CT_IgnoredError err, String ref1, params IgnoredErrorType[] ignoredErrorTypes)
{
err.sqref = ref1;
foreach (IgnoredErrorType errType in ignoredErrorTypes)
{
XSSFIgnoredErrorHelper.Set(errType, err);
}
}
public static ISet <IgnoredErrorType> GetErrorTypes(CT_IgnoredError err)
{
ISet <IgnoredErrorType> result = new HashSet <IgnoredErrorType>();
foreach (IgnoredErrorType errType in IgnoredErrorTypeValues.Values)
{
if (XSSFIgnoredErrorHelper.IsSet(errType, err))
{
result.Add(errType);
}
}
return(result);
}
public static void Set(IgnoredErrorType errorType, CT_IgnoredError error)
{
switch (errorType)
{
case IgnoredErrorType.CalculatedColumn:
error.calculatedColumn = true;
break;
case IgnoredErrorType.EmptyCellReference:
error.emptyCellReference = true;
break;
case IgnoredErrorType.EvaluationError:
error.evalError = true;
break;
case IgnoredErrorType.Formula:
error.formula = true;
break;
case IgnoredErrorType.FormulaRange:
error.formulaRange = true;
break;
case IgnoredErrorType.ListDataValidation:
error.listDataValidation = true;
break;
case IgnoredErrorType.NumberStoredAsText:
error.numberStoredAsText = true;
break;
case IgnoredErrorType.TwoDigitTextYear:
error.twoDigitTextYear = true;
break;
case IgnoredErrorType.UnlockedFormula:
error.unlockedFormula = true;
break;
default:
throw new InvalidOperationException();
}
}