Free Support Forum - aspose.com

Excel combobox error

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;

            }
        }

@srmbimser

Thanks for using Aspose APIs.

We were able to observe the issue but we need to look into it more. If we need your help, we may ask you to provide us console application project or other information.

We have logged the issue in our database for investigation and for a fix. Once, we will have some news for you, we will update you in this topic.

This issue has been logged as

  • CELLSNET-46193 - Validation is not working in XLS format but it works fine in XLSX format

@srmbimser,

This is to inform you that we have fixed your issue now. We will soon provide you the fixed version after performing QA and incorporating other enhancements and fixes.

@srmbimser,

Please try our latest version/fix: Aspose.Cells for .NET v18.6.4:
Aspose.Cells for .NET v18.6.4 (.NET 2.0)
Aspose.Cells for .NET v18.6.4 (.NET 4.0)

Your issue should be fixed in it.

Let us know your feedback.

The issues you have found earlier (filed as CELLSNET-46193) have been fixed in Aspose.Cells for .NET v18.7. Please also check the document/article for your reference: https://docs.aspose.com/display/cellsnet/Installation