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");
if (field_4_cell_ranges.CountRanges() > 0)
{
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 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("[").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());
}