3D charts export to images issues

Aspose.Cells Product Family
1

Hi:

I noticed that the export of 3D chart images doesn’t look quite the same as the charts in excel.

Here is some code that allows you to see the differences. It runs against the attached file. Please run the app to export the chart to a png file then open the file in excel and compare them. You’ll notice the following:
- the labels for dates are chopped off
- the labels for drinks are horizontal while in Excel they are oblique.
- the horizontal axis that has the beverages is displayed in a different
angle. On the aspose version is horizontal while in the excel version
is oblique.

  • Aspose seems to create small rectangle surfaces for the missing values, while Excel simple doesn’t put anything there. Excel seems to add something only as long as there is a value.
    - the view angles are not exactly the same
    - the vertical values are placed on the right side


    Is this something that you are going to fix? I know making the charts look like the excel ones can be a daunting task. I would say the most stringent issues are the dates being chopped off and the small areas should be removed if there are no values.

    Thank you

    Code:


    using System;
    using System.Data;
    using System.Drawing;
    using System.Drawing.Imaging;
    using System.Text;
    using Aspose.Cells;
    using Aspose.Cells.Drawing;
    using Aspose.Cells.Pivot;
    using Aspose.Cells.Rendering;

    namespace TestAspose
    {
    class Program
    {
    static void Main(string[] args)
    {
    Procedure20();
    Console.WriteLine(“Done!”);
    Console.ReadKey();
    }

    private static void Procedure20()
    {
    Workbook workbook = new Workbook(@"…\test3d_chart.xlsx");
    Worksheet worksheet = workbook.Worksheets[0];

    workbook.CalculateFormula(false);

    worksheet.Charts[0].ToImage(@"…\chart.png", ImageFormat.Png);
    }
    }
    }


2

Hi,

Thanks for using Aspose.Cells for .NET.

I can notice the 3d Chart issues by running the code with your source xlsx file using the latest version:
Aspose.Cells
for .NET v7.3.0.6

I have attached the output chart image for your reference.

We have logged this issue in our database. We will look into it and see if such enhancements could be made and implement them if possible.

This issue has been logged as CELLSNET-40985.

C#


string filePath = “test3d_chart.xlsx”;


Workbook workbook = new Workbook(filePath);


Worksheet worksheet = workbook.Worksheets[0];


workbook.CalculateFormula(false);


Chart chart = worksheet.Charts[0];


chart.ToImage().Save(filePath + “.out.png”);