public String PrettyPrint()
{
StringBuilder builder = new StringBuilder();
ST_DataValidationType vt = XSSFDataValidation.validationTypeMappings[validationType];
Enum ot = XSSFDataValidation.operatorTypeMappings[operator1];
builder.Append(vt);
builder.Append(' ');
if (validationType != ValidationType.ANY)
{
if (validationType != ValidationType.LIST && validationType != ValidationType.ANY && validationType != ValidationType.FORMULA)
{
builder.Append(",").Append(ot).Append(", ");
}
String QUOTE = "";
if (validationType == ValidationType.LIST && explicitListOfValues != null)
{
builder.Append(QUOTE).Append(Arrays.AsList(explicitListOfValues)).Append(QUOTE).Append(' ');
}
else
{
builder.Append(QUOTE).Append(formula1).Append(QUOTE).Append(' ');
}
if (formula2 != null)
{
builder.Append(QUOTE).Append(formula2).Append(QUOTE).Append(' ');
}
}
return(builder.ToString());
}
public string PrettyPrint()
{
StringBuilder stringBuilder = new StringBuilder();
ST_DataValidationType validationTypeMapping = XSSFDataValidation.validationTypeMappings[this.validationType];
Enum operatorTypeMapping = (Enum)XSSFDataValidation.operatorTypeMappings[this.operator1];
stringBuilder.Append((object)validationTypeMapping);
stringBuilder.Append(' ');
if (this.validationType != 0)
{
if (this.validationType != 3 && this.validationType != 0 && this.validationType != 7)
{
stringBuilder.Append(",").Append((object)operatorTypeMapping).Append(", ");
}
string str = "";
if (this.validationType == 3 && this.explicitListOfValues != null)
{
stringBuilder.Append(str).Append((object)Arrays.AsList((Array)this.explicitListOfValues)).Append(str).Append(' ');
}
else
{
stringBuilder.Append(str).Append(this.formula1).Append(str).Append(' ');
}
if (this.formula2 != null)
{
stringBuilder.Append(str).Append(this.formula2).Append(str).Append(' ');
}
}
return(stringBuilder.ToString());
}
private XSSFDataValidationConstraint GetConstraint(CT_DataValidation ctDataValidation)
{
string formula1 = ctDataValidation.formula1;
string formula2 = ctDataValidation.formula2;
ST_DataValidationOperator index = ctDataValidation.@operator;
ST_DataValidationType type = ctDataValidation.type;
return(new XSSFDataValidationConstraint(XSSFDataValidation.validationTypeReverseMappings[type], XSSFDataValidation.operatorTypeReverseMappings[index], formula1, formula2));
}
private static XSSFDataValidationConstraint GetConstraint(CT_DataValidation ctDataValidation)
{
XSSFDataValidationConstraint constraint = null;
String formula1 = ctDataValidation.formula1;
String formula2 = ctDataValidation.formula2;
ST_DataValidationOperator operator1 = ctDataValidation.@operator;
ST_DataValidationType type = ctDataValidation.type;
int validationType = XSSFDataValidation.validationTypeReverseMappings[type];
int operatorType = XSSFDataValidation.operatorTypeReverseMappings[operator1];
constraint = new XSSFDataValidationConstraint(validationType, operatorType, formula1, formula2);
return(constraint);
}
public void Set(CT_DataValidation obj)
{
formula1Field = obj.formula1Field;
formula2Field = obj.formula2Field;
typeField = obj.typeField;
errorStyleField = obj.errorStyleField;
imeModeField = obj.imeModeField;
operatorField = obj.operatorField;
allowBlankField = obj.allowBlankField;
showDropDownField = obj.showDropDownField;
showInputMessageField = obj.showInputMessageField;
showErrorMessageField = obj.showErrorMessageField;
errorTitleField = obj.errorTitleField;
errorField = obj.errorField;
promptTitleField = obj.promptTitleField;
promptField = obj.promptField;
sqrefField = obj.sqrefField;
}
public CT_DataValidation()
{
//this.sqrefField = new List<string>();
this.typeField = ST_DataValidationType.none;
this.errorStyleField = ST_DataValidationErrorStyle.stop;
this.imeModeField = ST_DataValidationImeMode.noControl;
this.operatorField = ST_DataValidationOperator.between;
this.allowBlankField = false;
this.showDropDownField = false;
this.showInputMessageField = false;
this.showErrorMessageField = false;
}
