Hi
RiskDegFormuRapSablonu(18.6).zip (4.4 KB)
RiskDegFormuRapSablonu (18.4.5).zip (4.4 KB)
Untitled.png (54.2 KB)
Works in version 18.4.5 but does not work in 18.6. What we need to do.
Thanks
Code
private void Listeleme(Worksheet worksheet, Aspose.Cells.Workbook workbook, int cellNo, ArrayList baslikCell, Aspose.Cells.Cell cell,
Aspose.Cells.Cell cell1, Aspose.Cells.Worksheet sheet, Cells cells, DataTable dt, string DataRowEleman, string DataRowEleman2, int alanNo, int sabitler)
{
ValidationCollection validations = null;
Validation validation = null;
CellArea area;
Range range = null;
int k = 0;
int no = 0;
string deger = "";
string alanno = alanNo.ToString();
foreach (DataRow dr in dt.Rows)
{
if (DataRowEleman == "TANIM")//puanlı liste ve liste tipleri için
{
alanno = dr["ALAN_NO"].ToString();
}
if (alanno == deger)
{
worksheet = workbook.Worksheets[k];
Cells cells1 = workbook.Worksheets[k].Cells;
}
if (alanno != deger)
{
k = workbook.Worksheets.Add();
worksheet = workbook.Worksheets[k];
Cells cells1 = workbook.Worksheets[k].Cells;
no = 0;
if (DataRowEleman == "STATU_ADI")
{
worksheet.Name = "STATU_ADI";
if (sabitler == 4)
{
cellNo = 3;
}
else if (sabitler == 6)
{
cellNo = 5;
}
range = worksheet.Cells.CreateRange("E1", "E20000");
range.Name = "MyRange1000";
}
else
{
worksheet.Name = "ALAN" + alanno;
for (int w = 0; w < baslikCell.Count - sabitler; w++)
{
if (cells.Rows[1][w + sabitler].Value != null)
{
foreach (XmlNode node in (xmlRead(cells.Rows[1][w + sabitler].Value.ToString(), "field")))
{
string hucre = node.InnerText;
if (hucre == worksheet.Name)
{
cellNo = w + sabitler;
break;
}
}
}
}
range = worksheet.Cells.CreateRange("E1", "E20000");
range.Name = "MyRange" + alanno;
}
}
if (DataRowEleman2 != "" && (dr["ALAN_TIPI"].ToString() == "08" || dr["ALAN_TIPI"].ToString() == "10"))
{
range[no, 0].PutValue(dr[DataRowEleman] + "$" + dr[DataRowEleman2]);
}
else
range[no, 0].PutValue(dr[DataRowEleman]);
no++;
if (alanno != deger)
{
validations = sheet.Validations;
validation = validations[validations.Add()];
validation.Type = Aspose.Cells.ValidationType.List;
validation.Operator = OperatorType.None;
validation.InCellDropDown = true;
if (DataRowEleman == "STATU_ADI")
{
validation.Formula1 = "=MyRange1000";
}
else
validation.Formula1 = "=MyRange" + alanno;
validation.ShowError = true;
validation.AlertStyle = ValidationAlertType.Stop;
validation.ErrorTitle = "Error";
validation.ErrorMessage = "Please select from the list";
if (cellNo != 0)
{
area.StartRow = 2;
area.EndRow = 20000;
area.StartColumn = cellNo;
area.EndColumn = cellNo;
validation.AreaList.Add(area);
}
}
worksheet.IsVisible = false;
deger = alanno;
cellNo = 0;
}
}