Problem with precision in the Cells

Aspose.Cells Product Family
1

I am building a chart using Aspose.Cells.
Everything is as expected, other than on the chart the data is showing integer when it comes from database as 7.0, 6.0, 5.0. But, when it comes as 6.2, 7.2, 5.6 then it is showing correct.
the code I have used to put value in cell is,
cells[“A1”].PutValue(categoryMean);

I have also tried,
cells[“A1”].PutValue(new Decimal(categoryMean));

Nothing works, please tell me what could be the issue?

2

Hi,

Well, I think you my try to use/set NumberFormat attribute for TickLabels or DataLabels etc.

e.g

chart.ValueAxis.TickLabels.NumberFormat = “0.0”;

chart.NSeries[0].DataLabels.NumberFormat = “0.0”;


Thank you.