Number rounding wrong

Aspose.Cells Product Family
1

In cell F6, it display $808, But data labels in chart display $807


Workbook wb = new Workbook(“C:/a.xlsx”);
wb.save(“C:/a.html”);

2

Hi,

Thanks for your posting and using Aspose.Cells.

We were able to observe this issue after converting your source excel file into html using the following code with the latest version: Aspose.Cells for Java 8.5.1. F6 value is 808 but chart data label shows 807.

We have logged this issue in our database for investigation. We will look into it and fix this issue. Once the issue is resolved or we have some other update for you, we will let you know asap.

This issue has been logged as

  • CELLSJAVA-41420 - F6 value is 808 but chart data label shows 807

I have also attached the screenshot highlighting this issue for a reference.

Java

String filePath = “F:\Shak-Data-RW\Downloads\s.xlsx”;


Workbook workbook = new Workbook(filePath);

workbook.save(filePath + “.out.htm”);

3

@xhaixia

Thanks for using Aspose APIs.

Please provide us your Excel file (i.e. a.xlsx) once again because it is unavailable to us probably due to migration to new forums. Thanks for your cooperation in this regard and have a good day.