public void TestGetDataValidationsAny() { HSSFWorkbook wb = new HSSFWorkbook(); HSSFSheet sheet = wb.CreateSheet() as HSSFSheet; List <IDataValidation> list = sheet.GetDataValidations(); Assert.AreEqual(0, list.Count); IDataValidationHelper dataValidationHelper = sheet.GetDataValidationHelper(); IDataValidationConstraint constraint = dataValidationHelper.CreateNumericConstraint(ValidationType.ANY, OperatorType.IGNORED, null, null); CellRangeAddressList AddressList = new CellRangeAddressList(1, 2, 3, 4); IDataValidation validation = dataValidationHelper.CreateValidation(constraint, AddressList); validation.EmptyCellAllowed = (/*setter*/ true); validation.CreateErrorBox("error-title", "error-text"); validation.CreatePromptBox("prompt-title", "prompt-text"); sheet.AddValidationData(validation); list = sheet.GetDataValidations(); // <-- works Assert.AreEqual(1, list.Count); HSSFDataValidation dv = list[(0)] as HSSFDataValidation; { CellRangeAddressList regions = dv.Regions; Assert.AreEqual(1, regions.CountRanges()); CellRangeAddress Address = regions.GetCellRangeAddress(0); Assert.AreEqual(1, Address.FirstRow); Assert.AreEqual(2, Address.LastRow); Assert.AreEqual(3, Address.FirstColumn); Assert.AreEqual(4, Address.LastColumn); } Assert.AreEqual(true, dv.EmptyCellAllowed); Assert.AreEqual(false, dv.SuppressDropDownArrow); Assert.AreEqual(true, dv.ShowErrorBox); Assert.AreEqual("error-title", dv.ErrorBoxTitle); Assert.AreEqual("error-text", dv.ErrorBoxText); Assert.AreEqual(true, dv.ShowPromptBox); Assert.AreEqual("prompt-title", dv.PromptBoxTitle); Assert.AreEqual("prompt-text", dv.PromptBoxText); IDataValidationConstraint c = dv.ValidationConstraint; Assert.AreEqual(ValidationType.ANY, c.GetValidationType()); Assert.AreEqual(OperatorType.IGNORED, c.Operator); }
public override String ToString() { StringBuilder buffer = new StringBuilder(); buffer.Append("[CFHEADER]\n"); buffer.Append(" .id = ").Append(StringUtil.ToHexString(sid)).Append("\n"); buffer.Append(" .numCF = ").Append(NumberOfConditionalFormats).Append("\n"); buffer.Append(" .needRecalc = ").Append(NeedRecalculation).Append("\n"); buffer.Append(" .enclosingCellRange= ").Append(EnclosingCellRange).Append("\n"); buffer.Append(" .cfranges=["); for (int i = 0; i < field_4_cell_ranges.CountRanges(); i++) { buffer.Append(i == 0 ? "" : ",").Append(field_4_cell_ranges.GetCellRangeAddress(i).ToString()); } buffer.Append("]\n"); buffer.Append("[/CFHEADER]\n"); return(buffer.ToString()); }
public override String ToString() { StringBuilder buffer = new StringBuilder(); buffer.Append("[").Append(RecordName).Append("]\n"); buffer.Append("\t.numCF = ").Append(NumberOfConditionalFormats).Append("\n"); buffer.Append("\t.needRecalc = ").Append(NeedRecalculation).Append("\n"); buffer.Append("\t.id = ").Append(ID).Append("\n"); buffer.Append("\t.enclosingCellRange= ").Append(EnclosingCellRange).Append("\n"); buffer.Append("\t.CFranges=["); for (int i = 0; i < field_4_cell_ranges.CountRanges(); i++) { buffer.Append(i == 0 ? "" : ",").Append(field_4_cell_ranges.GetCellRangeAddress(i).ToString()); } buffer.Append("]\n"); buffer.Append("[/").Append(RecordName).Append("]\n"); return(buffer.ToString()); }