WorkBook looses dropdowns

Aspose.Cells Product Family
1

Hi,

Following is a code snippet:
Workbook excelFile = new Workbook(filePathFromDb);
Worksheet lookupDataSheet = excelFile.Worksheets[1];

I hide few columns on lookupDataSheet which do not have dopdowns and then

excelFile.Save(HttpContext.Current.Response, string.Format(“Template{0}.xls”, “”), ContentDisposition.Attachment, new XlsSaveOptions(SaveFormat.Excel97To2003));

When i folllow the above code, i am loosing the dropdowns which were present in the Original.
Can you please let me know if there is any solution.
Thank you.
2

Hi,

Thanks for your posting and using Aspose.Cells for .NET.

Please download and use the latest version:
Aspose.Cells
for .NET v7.2.0.1
and see if it resolves your problem.

If the problem still occurs then we will need your sample source file to look into this issue.

3
Hi,

Please download and try our latest version/fix: Aspose.Cells for .NET v7.2.0.1 and let me know your feedback.

If you still find the issue, give us your template file and missing code(if you have). Also provide the output file here. We will check your issue soon.

Thank you.
4

Thank you for the swift repsonse. I got the latest dll just now… Will try it and let you know.