Test to Columns feature in MS Excel causes Microsoft Excel stopped working

Aspose.Cells Product Family
1

Hi,

I am using aspose.cells for generating reports in excel.
In a column i am having some values separated by commas.
If I apply Test to Columns property for that particular cell\column,I get message ‘Mircrosoft Excel has stopped working’.

MSEXCEL–>Data Tab–> select column–>Apply text to columns–>Select Delimiter as comma.

If I add some comma limited data to the same sheet manally I am able to get results through the wizard without stopping excel.

This happens with data rendered only through aspose.

Please help as soon as possible.

-Chaits
2

Hi,


Please try our latest version/fix: Aspose.Cells for .NET v8.6.0.4 if it works fine.

If you still find the issue (with the output file (as per your mentioned details) generated by Aspose.Cells for .NET v8.6.0.x), kindly create a simple console application (runnable), zip it and post us there to show the issue on our end, we will check it soon. Also attach your input and output Excel file(s), this will help us to evaluate your issue precisely to figure it out soon.

Thank you.