Xlsx to ODS breakline problem

Aspose.Cells Product Family
1

Hello I have a question about I wanna transfer a file from xslx to ods use aspose.cells(for .net), my code as below

Workbook wb = new Workbook(“XlsxFile”);
OdsSaveOptions Options = new OdsSaveOptions(Aspose.Cells.SaveFormat.ODS);
Wb.Save(“OutputOdsFile”, Options);

but not work when the ods file include linebreak(\n)

Can yous tell me how to handle this problem, tnks

2

@Tengen,

Thanks for providing us sample code and details.

Please provide us template XLSX file, we will check it soon.

3

Hi,

OriFile.zip (12.7 KB)

thks

4

@Tengen,

Thank you for providing the sample file.

We have tested this issue using latest version Aspose.Cells for .NET 18.10, but could not observe this issue. It seems that you are using some older version in your testing. Please give it a try using latest version and provide your feedback.
Capture.PNG (15.6 KB)
OutputOdsFile.zip (6.0 KB)

5

Thank for yous help,
I found a problem with Microsoft Office Excel…

this MsOffice 2013 Result
MsOffice.jpg (121.9 KB)

this OpenOffice Result
OpenOffice.jpg (86.4 KB)

6

@Tengen,

You may please try this scenario by converting the template XLSX file into ODS file using Excel 2013 and test if it opens fine in Excel 2013 or not. Send this ODS file (converted by Excel 2013) to us. Similarly an ODS file which is converted using Excel 2016 is attached here. Please test it using Excel 2013 in your environment and share the feedback (provide the snapshot as well). We will analyze the whole scenario and provide our feedback.
OriFileByExcel2016.zip (4.7 KB)