Convert a 3D chart into a 3D effect image using cells?

Aspose.Cells Product Family
1

I developed a pie chart with a 3D effect, but when I converted the chart to an image, the expected effect was not visible. For your reference I added code along with output.

PieChart.zip (57.1 KB)

2

@sanjeevkumar.v

To convert a 3D chart into a 3D image using Aspose.Cells, it’s important to ensure that the chart is rendered correctly, especially when dealing with 3D effects. Here are some key points to consider based on similar issues encountered by other users:

  1. Color Depth: The color depth setting can significantly affect how the 3D chart is rendered. It has been observed that using a color depth of Format8bpp can lead to issues where the 3D effects are not displayed properly. Instead, it is recommended to use ColorDepth.Format24bpp or ColorDepth.Default to achieve better results, as these settings allow for a more accurate representation of the 3D effects.

  2. Chart Depth: The depth of the chart itself can also impact the visibility of the 3D effect. If the depth is too small, the 3D representation may not be very pronounced. Adjusting the chart’s depth can help enhance the 3D effect.

  3. Rendering Limitations: It’s important to note that Aspose.Cells does not support real 3D engine effects. The 3D effects are simulated on 2D images, which means that certain parameters like rotation angles are fixed. This limitation can affect how 3D charts are displayed when converted to images.

  4. Example Code: Here’s a basic example of how to set the color depth when converting a chart to an image:

    // Load the workbook
Workbook workbook = new Workbook("path/to/your/file.xlsx");
// Access the first worksheet
Worksheet worksheet = workbook.Worksheets[0];
// Access the chart
Chart chart = worksheet.Charts[0];
// Set the image options
ImageOrPrintOptions options = new ImageOrPrintOptions();
options.ImageFormat = ImageFormat.Png;
options.HorizontalResolution = 300;
options.VerticalResolution = 300;
options.ColorDepth = ColorDepth.Format24bpp; // Set color depth

// Convert the chart to an image
chart.ToImage("output/path/chart.png", options);

By following these guidelines, you should be able to achieve a better representation of your 3D pie chart when converting it to an image. If you continue to experience issues, consider checking for updates or optimizations in the Aspose.Cells library that may address rendering problems.

3

@sanjeevkumar.v,

We already reproduced the issue (Ticket ID: “CELLSNET-57705”) as you posted the same issue in your other thread. We found 3D effect was lost when converting chart to image. Please refer to the mentioned thread for updates and further follow-ups.

4

Hi @sanjeevkumar.v,
For better 3D effects when converting charts to images, try setting ColorDepth.Format24bpp in ImageOrPrintOptions . Also, ensure the chart depth is adjusted for a clearer 3D look. Keep in mind Aspose.Cells simulates 3D effects on 2D images, so some limitations exist.

5

@sanjeevkumar.v
We have already reproduced the issue (Ticket ID: “CELLSNET-57705”) as you posted the same issue in your other thread. Once there is an update, we will notify you promptly.

6

@sanjeevkumar.v
We have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.

Issue ID(s): CELLSNET-57705

You can obtain Paid Support Services if you need support on a priority basis, along with the direct access to our Paid Support management team.

7

Hi @Jiyasharma @sanjeevkumar.v

We further investigated the code you provided, and we found that you achieved the 3D effect by setting the “bevel” property. Currently, bevel property is supported for reading, writing, setting, and it also works when saving to Excel.
However, when saving as an image, the bevel effect not supported at present because it involves some 3D rendering.

Currently, the simulated 3D effect that can be supported when saving as an image is of the “3D pie chart” type:

worksheet.Charts.Add(ChartType.Pie3D, 5, 1, 25, 8);

Please check the following code:
3dPie.zip (1.5 KB)

8

Thanks for explaining, @leoluo! I understand now that the bevel effect doesn’t work when saving as an image. I’ll try the simulated 3D effect with the ‘3D pie chart’ type and check the example you shared. Thanks for your help

9

@Jiyasharma,

You’re welcome! Yes, you can use the suggested code snippet (attached in the previous post) to implement a 3D Pie chart instead of a Pie chart with bevel effects. Please don’t hesitate to reach out if you have any more questions or feedback.

10

Thanks for the suggestion, @amjad.sahi! I’ll give the code snippet a try and let you know if I run into any issues.

11

@Jiyasharma

Sure, please take your time to evaluate it and hope it will work for you.

12

Thanks for explaining, @leoluo! I want same output of pie chart. How to achieve without using the “bevel” property? Are there any other ways?

13

@sanjeevkumar.v

We are afraid the 3D pie chart cannot give the the exactly same 3D effect with the result of “bevel” property. Anyways we will evaluate whether we can produce as similar as possible with the result of provided sample and give feedback soon.

14

Hi @johnson.shi
Any updates on this issue.

15

@sanjeevkumar.v
We are sorry but no updates at present . Once we have any new information, we will share it with you.