Spire.XLS is a professional Excel API that enables developers to create, manage, manipulate, convert and print Excel worksheets. Get free and professional technical support for Spire.XLS for .NET, Java, Android, C++, Python.

Tue Oct 22, 2019 2:47 pm

Hi, I'm converting a file that has a field with data validation list and a number of semicolon separated values in the Source. While the rest of the excel document looks good, this field is missing its data validation in the resulting file.

Does Spire.XLS support this use case?

Danpantani
 
Posts: 5
Joined: Wed Sep 04, 2019 8:42 am

Wed Oct 23, 2019 3:10 am

Hi,

Thanks for your inquiry.
Which kind of file format did you try to convert to?

To help us investigate your issue accurately, please offer us the following information.
1. Your input Excel file.
2. The complete code you were using which could reproduce your issue directly.
3. The result file.
4. Your desired result file.

You could upload them here or send us(support@e-iceblue.com) via email.

Best wishes,
Amber
E-iceblue support team
User avatar

Amber.Gu
 
Posts: 525
Joined: Tue Jun 04, 2019 3:16 am

Wed Oct 23, 2019 9:11 am

This is the code:

Code: Select all
public static void Run()
{
    var workBook = new Spire.Xls.Workbook();
    workBook.LoadFromFile("Data/withdatavalidation.xls");
    using (var ws = File.OpenWrite("Data/result_with_missing_validation.xlsx"))
    {
        workBook.SaveToStream(ws, FileFormat.Version2013);
    }
}
Attachments
withdatavalidation.zip
(6.45 KiB) Downloaded 179 times

Danpantani
 
Posts: 5
Joined: Wed Sep 04, 2019 8:42 am

Wed Oct 23, 2019 11:14 am

Hi,

Thanks for your information.
I tested your file and did notice the issue you mentioned. I have logged it into our bug tacking system, once there is any progress, we will inform you.
Sorry for the inconvenience caused.

Best wishes,
Amber
E-iceblue support team
User avatar

Amber.Gu
 
Posts: 525
Joined: Tue Jun 04, 2019 3:16 am

Wed Oct 23, 2019 1:28 pm

Thank you for the response. How long does it usually take for issues like these to be fixed?

Danpantani
 
Posts: 5
Joined: Wed Sep 04, 2019 8:42 am

Thu Oct 24, 2019 1:25 am

Hi,

Thanks for your reply.
I'm afraid we can't provide an ETA at present. Our Dev team is still looking for the solution. Once there is any progress, we will inform you ASAP.
Sorry for the inconvenience caused.

Best wishes,
Amber
E-iceblue support team
User avatar

Amber.Gu
 
Posts: 525
Joined: Tue Jun 04, 2019 3:16 am

Return to Spire.XLS