Bubble chart image not correct

Aspose.Cells Product Family
21

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

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.

While trying to keep the API as straightforward and clear as possible, we have decided to recognize and honor the common development practices of the platform; we have re-arranged API Structure/ Namespaces.

With this release, we have reorganized the API classes for Aspose.Cells component. This change has some major aspects that we follow. We have added new namespaces. The entire API (classes, interfaces, enumerations, structures etc.) were previously located in the Aspose.Cells namespace. Now, certain sets of API have been moved to their relative namespaces, which make the relationship of classes (with their members) and namespaces clear and simplified. It is to be noted here, we have not renamed existing API (classes, enumerations etc.) but, I am afraid you still need to make certain adjustments in your existing projects accordingly.

For complete reference, please see the product's API Reference.

22

Hi,

i am creating charts and embedding them to powerpoint. I am using Aspose.Cells - 4.8.1.2 version. the scaling of x axis on bubble chart is not working properly . there is auto rounding off of float value in the x axis . i used the solutions posted on this forum .but still i am facing the same scaling problem. please find the screen shot in attachment.

Can you please look into the issue and suggest.

23

Hi,

As you are using v4.8.1.2, so we recommend you to use our latest version e.g 5.1.4 (latest).

If you still find the issue, kindly do post your template Excel file, so that we may take the image of the chart and check your issue.

Thank you.

24

Hi ,

i tried out using the latest version of Aspose.cells 5.1.4.0 . but still i am facing the same Scaling of x axis problem in bubble chart image . so i have attached my template excel file along with this post . please kindly suggest me the solution.

25

Hi,

Please try the attached latest fix/version v5.1.4.7. I have tested using your template with sample code, it works fine. I have also attached the output file. Please give us details where is the problem, I can see the x-axis and y-axis values are rendered fine same as MS Excel.
//Instantiate and open an Excel file
Workbook book = new Workbook(“e:\test\test±+Dash±+Bubble+Chart_B8_22111135040.xls”);
//Define ImageOrPrintOptions
ImageOrPrintOptions imgOptions = new ImageOrPrintOptions();
//Specify the image format
imgOptions.ImageFormat = System.Drawing.Imaging.ImageFormat.Jpeg;
//Set the vertical and horizontal resolution
imgOptions.VerticalResolution = 200;
imgOptions.HorizontalResolution = 200;
//One page per sheet is enabled
imgOptions.OnePagePerSheet = true;
//Get the first worksheet
Worksheet sheet = book.Worksheets[0];
//Render the sheet with respect to specified image/print options
SheetRender sr = new SheetRender(sheet, imgOptions);
//Render the image for the sheet
sr.ToImage(0,“e:\test\mybubble_output.jpg”);

Thank you.

26

Hi,
The actual problem is with x axis values in bubble chart where float point is not getting displayed and the values are getting rounded off to the nearest integer value. Due to this am getting inappropriate values in x-axis.
therefore i am attaching my template file along with this post and also screen shot showing the problem.
please suggest the solution

27

Hi,

If you could open your Excel file in MS Excel’s print preview, you will see the chart would same as the output image by Aspose.Cells for .NET. I think for your need, you should format the tick labels of x-axis before taking image of the sheet/chart. See the updated code.

//Instantiate and open an Excel file
Workbook book = new Workbook(“e:\test\test±+Dash±+Bubble+Chart_B8_22111135040.xls”);
//Define ImageOrPrintOptions
ImageOrPrintOptions imgOptions = new ImageOrPrintOptions();
//Specify the image format
imgOptions.ImageFormat = System.Drawing.Imaging.ImageFormat.Jpeg;
//Set the vertical and horizontal resolution
imgOptions.VerticalResolution = 200;
imgOptions.HorizontalResolution = 200;
//One page per sheet is enabled
imgOptions.OnePagePerSheet = true;

//Get the first worksheet
Worksheet sheet = book.Worksheets[0];

Chart chart = sheet.Charts[0];
chart.CategoryAxis.TickLabels.NumberFormat = “0.0”;

//Render the sheet with respect to specified image/print options
SheetRender sr = new SheetRender(sheet, imgOptions);
//Render the image for the sheet
sr.ToImage(0,“e:\test\mybubble_output.jpg”);

Thank you.

28

hi,
My scaling issue was resolved i would like thanks you for providing me the solution.


Thank you