Free Support Forum - aspose.com

Problem with setGapWidth on 1.7.0.0 Java Cells

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

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.

Thanks Warren,

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

Thanks,

Steve

Hi,

Yes.We will release it today.