Problem with setGapWidth on 1.7.0.0 Java Cells

Aspose.Cells Product Family
1

I am setting the GapWidth when creating a LINE_3D graph to 0 and when I open the sheet in Excel it is set to 150.

The code is basically:

int index = charts.add(ChartType.LINE_3D,0,0,42,20);
Chart chart = charts.getChart(index);

/* Add data series */

chart.setDepthPercent(500);
chart.setGapWidth(0);
chart.getSeriesAxis().setVisible(false);
chart.getFloor().getArea().setForegroundColor(lightGray);

Thanks, Steve

2

Hi Steve,

Please try this fix.

Note: In this verison , we removed the const CellValueType.FORMULA and add method Cell.isFormula() to decide whether the cell contains formula.

3

Thanks Warren,

That worked great. Will there be an official release of Java Cells soon with this fix in?

Thanks,

Steve

4

Hi,

Yes.We will release it today.