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;
}