We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Data markers are missing in the chart converted from Excel

Hi,

When I converted a chart from Excel to an image, I noticed all data markers were missing.

Code:
var workbook2 = new Workbook(@“Book2.xlsx”);
var options = new ImageOrPrintOptions
{
ImageType = ImageType.Emf,
ChartImageType = ImageFormat.Emf,
OnlyArea = false,
TextRenderingHint = TextRenderingHint.ClearTypeGridFit,
OnePagePerSheet = true
};

        workbook2.Worksheets["Sheet1"].Charts[0].ToImage(@"out.emf", options);

I’ve attached the test files and a screenshot for your reference. Could you please kindly have a look?

image.png (32.4 KB)
Book2.zip (21.3 KB)

Thanks,

@ServerSide527,

Thanks for the template file, sample code and screenshot.

I observed the issue as you mentioned (as per your attached screenshot) by using your sample code with your template file. I found that data markers are missing in the output chart image from MS Excel file:
e.g
Sample code:

 var workbook2 = new Workbook(@"e:\\test2\\Book2.xlsx"); 
            var options = new ImageOrPrintOptions 
            { 
                ImageType = ImageType.Emf, 
                ChartImageType = ImageFormat.Emf, 
                OnlyArea = false, 
                TextRenderingHint = TextRenderingHint.ClearTypeGridFit, 
                OnePagePerSheet = true 
            }; 

//workbook2.CalculateFormula(); 
             
            workbook2.Worksheets["Sheet1"].Charts[0].ToImage(@"e:\\test2\\out1.emf", options);

I have logged a ticket with an id “CELLSNET-46408” for your issue. We will look into it soon.

Once we have an update on it, we will let you know here.

@ServerSide527,

This is to inform you that we have fixed your issue now. We will soon provide you the fixed version after performing QA and incorporating other enhancements and fixes.

The issues you have found earlier (filed as CELLSNET-46408) have been fixed in Aspose.Cells for .NET v18.11. This message was posted using BugNotificationTool from Downloads module by Amjad_Sahi