Free Support Forum - aspose.com

CrossAt doesn't work

Hi:
I'm using version 4.8.2 to build a bubble chart with there axis on different positions, but the result is not what I'm expecting. Both axis are not crossing where I'm indicating.
I hope you can help me.
Sincerely
Alejandro
var AsposeBook = new Workbook();
int SheetIndex = AsposeBook.Worksheets.Add();
var ActualChartSheet = AsposeBook.Worksheets[SheetIndex];
SheetIndex = AsposeBook.Worksheets.Add();
var DataSheet = AsposeBook.Worksheets[SheetIndex];
DataSheet.IsVisible = false;
DataSheet.Name = "DataSheet";

int ChartIndex = ActualChartSheet.Charts.Add(ChartType.Line, 0, 0, 30, 10);
var ActualChart = ActualChartSheet.Charts[ChartIndex];

double [] XValues = {2.4, 0.3, 0.2, 1.1, 2.3, 2.1, 0.3, 0.2, 0.128, 0.4, 0.2, 1.2, 0.7, 0.13, 0.13};
double [] Yvalues = {0.867, -0.00141, 0.113 , 0.028, 0.399, -0.18, 0.072, -0.237, 0.420, -0.132, -0.0125, 0.0405, -0.0479, -0.112, -0.1441};
double [] ZValues = {1991446, 1416791, 1266904, 942250, 803036, 731421, 344330, 333208, 261988, 260854, 252742, 193094, 180512, 158543, 145193};

ActualChart.Title.Text = "Example Bubble Chart";
NSeries AspSeries = ActualChart.NSeries;
int SerieCount = AspSeries.Add("DataSheet!A1:A15", true);
ASeries MySerie = AspSeries[SerieCount];
MySerie.Type = ChartType.Bubble3D;
MySerie.PlotOnSecondAxis = false;
MySerie.Name = "Example Bubble Chart";

DataSheet.Cells.ImportArray(XValues, 0, 0, true);
MySerie.XValues = "DataSheet!$A$1:$A$15";
DataSheet.Cells.ImportArray(Yvalues, 0, 1, true);
MySerie.Values = "DataSheet!$B$1:$B$15" ;
DataSheet.Cells.ImportArray(ZValues, 0, 2, true);
MySerie.BubbleSizes = "DataSheet!$C$1:$C$15";

ActualChart.ValueAxis.MinorGridLines.IsVisible = false;
ActualChart.ValueAxis.MajorGridLines.IsVisible = false;
ActualChart.ValueAxis.MaxValue = 1.2;
ActualChart.ValueAxis.MinValue = -0.6;
ActualChart.ValueAxis.CrossAt = 0.31;
ActualChart.ValueAxis.TickLabelPosition = TickLabelPositionType.High;

ActualChart.CategoryAxis.MajorGridLines.IsVisible = false;
ActualChart.CategoryAxis.MajorGridLines.IsVisible = false;
ActualChart.CategoryAxis.IsLogarithmic = true;
ActualChart.CategoryAxis.IsPlotOrderReversed = true;
ActualChart.CategoryAxis.LogBase = 2;
ActualChart.CategoryAxis.MaxValue = 8;
ActualChart.CategoryAxis.MinValue = 0.125;
ActualChart.CategoryAxis.CrossAt = 1.5;
ActualChart.CategoryAxis.TickLabelPosition = TickLabelPositionType.Low;

ActualChart.IsLegendShown = false;
AsposeBook.Save("ejemplo.xlsx", FileFormatType.Excel2007Xlsx);


This message was posted using Aspose.Live 2 Forum

Hi,

<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

Thank you for considering Aspose.

We have found your mentioned issue after an initial test. We will look into it and get back to you soon. Your issue has been registered in our internal issue tracking system with issue id: <?xml:namespace prefix = st1 ns = "urn:schemas-microsoft-com:office:smarttags" />CELLSNET- 14615.

Thank You & Best Regards,

Hi,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

Please try the attached latest version of Aspose.Cells. We have fixed your mentioned issue regarding CrossAt API.

Thank You & Best Regards,

Cool, thank you very much.

Alejandro

The issues you have found earlier (filed as 14615) have been fixed in this update.


This message was posted using Notification2Forum from Downloads module by aspose.notifier.