Hi,
we are migrating from xls to xlsx,so we have updated the aspose version from 1.9.8 to 2.5.4.1.Currently we are using trial version.On generating excel,The Text box ,plot area is getting altered in the graph... Can u provide us with some work around.
Before saving the text box width is extremly large compared to the saved file.
Following is the code we have used for text box.
int
y = ws.getCharts().getChart(0).getPlotArea().getHeight();
int x = ws.getCharts().getChart(0).getPlotArea().getWidth();
int
width = (new Double(((5*x)/(info.getMaxSERangeRow()*2)))).intValue();
TextBox yGreenBox = ws.getCharts()
.getChart(0)
.getShapes()
.addTextBoxInChart((x / 2) - width + 310, 250, width, (y / 2);
I have attached the graph genetated in Previous version and current version.
Kindly provide us with the solution as soon as possible.
Thanks & Regards,
Geetha
