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

Free Support Forum - aspose.com

Lines became dotted on data bars in Emf/OfficeCompatibleEmf rendered by Aspose


When converting an Excel sheet with data bars on cells to Emf/OfficeCompatibleEmf using Aspose.Cells. I noticed the lines became dotted.


var workbook = new Workbook(@".\test.xlsx");
var ws = workbook.Worksheets[0];
ws.PageSetup.PrintArea = “B5:E11”;
ws.PageSetup.LeftMargin =
ws.PageSetup.RightMargin = ws.PageSetup.TopMargin = ws.PageSetup.BottomMargin = ws.PageSetup.HeaderMargin = ws.PageSetup.FooterMargin = 0;
var optionsOfficeCompatibleEmf = new ImageOrPrintOptions
ImageType = ImageType.OfficeCompatibleEmf,
OnlyArea = false,
TextRenderingHint = TextRenderingHint.AntiAlias,
OnePagePerSheet = true,
Transparent = true,
HorizontalResolution = 600,
VerticalResolution = 600

new SheetRender(workbook.Worksheets[0], optionsOfficeCompatibleEmf).ToImage(0, @".\outOfficeCompatibleEmf.emf");

var optionsEmfPlus = new ImageOrPrintOptions
ImageType = ImageType.Emf,
OnlyArea = false,
TextRenderingHint = TextRenderingHint.ClearTypeGridFit,
OnePagePerSheet = true,
Transparent = true

new SheetRender(workbook.Worksheets[0], optionsEmfPlus).ToImage(0, @".\outEmfPlus.emf");

I’ve attached the test files, output and a screenshot for your reference. Could you please take a look?

test.zip (53.6 KB)
image.png (42.8 KB)



Please notice, I am able to reproduce the issue as you mentioned by using your template file. I found lines become dotted on data bars in Emf/OfficeCompatibleEmf image rendered by Aspose.Cells for .NET APIs. I have logged a ticket with an id “CELLSNET-48540” for your issue. We will look into it soon.

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

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


Your issue is fixed in v21.8.2:
Aspose.Cells21.8.2 For .Net2_AuthenticodeSigned.Zip (5.6 MB)
Aspose.Cells21.8.2 For .Net4.0.Zip (5.6 MB)
Aspose.Cells21.8.2 For .NetStandard20.Zip (5.6 MB)

Let us know your feedback.

The issues you have found earlier (filed as CELLSNET-48540) have been fixed in this update. This message was posted using Bugs notification tool by simon.zhao