Issue with Format Conversion

Aspose.Cells Product Family
1

When converting an xls file to a csv file, unlike standard Excel behaviour, Aspose.Cells does not pad rows with commas to ensure consistant row lengths.

For example an Excel sheet with 3 columns (A,B,C) containing 3 rows of data and a header row as described below:

A B C

1 2 3

1

1 2

Will be saved as:

A,B,C

1,2,3

1,,

1,2,

from Excel, but will be saved as:

A,B,C

1,2,3

1

1,2

in Aspose.Cells.

I believe this to be a bug and would like to know when a fix can be expected.

Thank you.

2

Hi,

Which version you are using. Please try our latest version v5.1.4:
http://www.aspose.com/community/files/51/.net-components/aspose.cells-for-.net/entry265124.aspx

I have tested your scenario and it works as MS Excel.

Thank you.

3

I had been using 5.0.0. As you said, 5.1.4 seems to perform as expected. Thank you.