.Net - Date format lost when saving file as csv

Aspose.Cells Product Family
1

Hello,

I have the attached .ods file that I’m saving as .csv as follows:

Workbook workbook = new Workbook(fileInfo.FullName);
workbook.Save(importFilePath, SaveFormat.Csv);

But it’s converting all the dates into numbers (6/30/2025 → 46203)

Is there anything I’m missing to do? like LoadOptions (I already tried with ConvertNumericData false and ConvertDateTimeDate false but didn’t work)

or is this a bug in the Aspose.Cells library?

Thanks you!

Search Results 202409250839.zip (40.0 KB)

2

@erossi,

Thanks for the sample ODS document.

After initial testing, I was able to reproduce the issue as you mentioned by converting your sample ODS file to CSV. I found date format was lost when saving the ODS file as CSV.

We require thorough evaluation of the issue. We have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.

Issue ID(s): CELLSNET-56850

You can obtain Paid Support Services if you need support on a priority basis, along with the direct access to our Paid Support management team.

3

@erossi,

We are pleased to inform you that your issue has been resolved. The fix will be included in our upcoming release (Aspose.Cells v24.10) that we plan to release in the first half of October 2024. You will be notified when the next version is released.

1 Like
4

The issues you have found earlier (filed as CELLSNET-56850) have been fixed in this update. This message was posted using Bugs notification tool by johnson.shi