Convert ods file missing cell data

Aspose.Cells Product Family
1

Hello

I create an ods file with data duplicate in connecting cells, cell content A1 same as B1, C1,…

I’m using Aspose to load ods file and save to another ods file => new ods file missing duplicated da (6.1 KB)
ta (cell B1, C1 are empty). But when save ods => xls this issue does not happen.

I’m using C# and Apose 17.5.0.0, here is my code:
Aspose.Cells.LoadOptions opt = new Aspose.Cells.LoadOptions(LoadFormat.ODS);
Workbook workbook = new Workbook(@“F:\Untitled1.ods”, opt);
workbook.Save(@“F:\Untitled2.ods”, SaveFormat.ODS);

And my file:
duplicated_cell.zip

Thanks

2

@vohungvi

Thanks for using Aspose APIs.

We were able to observe the issue and logged it in our database for an investigation and for a fix. Once, the issue is resolved or we have some other news for you, we will let you know asap.

This issue has been logged as

  • CELLSNET-45546 - Missing cell data while opening and saving ODS file
3

@vohungvi

Thanks for using Aspose APIs.

This is to inform you that we have fixed your issue CELLSNET-45546 now. We will soon provide the fix after performing QA and including other enhancements and fixes.

4

@vohungvi,

Please try our latest version/fix: Aspose.Cells for .NET v17.7.5:

Your issue should be fixed in it.

Let us know your feedback.

Thank you.

5

This issue not happen anymore. Thank you so much

6

@vohungvi,

Good to know that your issue is sorted out by the new fix/version. Feel free to contact us any time if you need further help or have some other issue or queries, we will be happy to assist you soon.

Thank you.

8

The issues you have found earlier (filed as CELLSNET-45546) have been fixed in latest version of Aspose.Cells for .NET (Download | NuGet).

9

Thank you for tell me know. Regards