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