ODS PutValue and Decimal values

Aspose.Cells Product Family
1

When creating a new workbook, adding a worksheet and inserting a decimal value.
The result in OpenOffice, is wrong.

Workbook book = new Workbook();
book.Worksheets.Clear();
sheet = book.Worksheets.Add(“NamedWorksheet”);

decimal d = new decimal(100.50);
sheet.cells[1,1].PutValue(d);

sheet.AutoFitColumns();
sheet.AutoFitRows();

book.Save(@“C:\test.ods”, FileFormatType.ODS);

Opening c:\test.ods reveals a cell value of 1005,00, not 100,50
Saving to Excel, HTML, PDF, ect… works as expected.

Regards.

2

Hi,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

Thank you for considering Aspose.

We have found your mentioned issue after an initial test. We will look into it and get back to you soon. Your issue has been registered in our internal issue tracking system with issue id CELLSNET-13648.

Thank you & Best Regards,

3

Hi,

<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

Thank you for considering Aspose.

Please try the attached latest version of Aspose.Cells for .NET V4.8.2.2. We have fixed your mentioned issue.

Thank You & Best Regards,

4

Confirmed, the issue is resolved.

Thank you and sorry for the rather late answer.
Jens Churchill
5

The issues you have found earlier (filed as 13648) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by aspose.notifier.