SheetRender exports shape incorrectly

Hello! When exporting a range containing a shape, the shape is rendered incorrectly. Please, check the attached console project!

Thank you.

Hi,


Thanks for providing us the sample project here.

I can notice the issue as you have mentioned. The auto-shape is rendered incorrectly in the output image.

Sample code:

var workbook = new Workbook(@“E:\test2\TextBoxInExcel_shapeexport\TextBoxInExcel\bin\Debug\formshape.xls”);
workbook.CalculateFormula();

var imageOptions = new ImageOrPrintOptions
{
Quality = 100,
VerticalResolution = 200,
HorizontalResolution = 200,
PrintingPage = PrintingPageType.IgnoreBlank,
ImageFormat = ImageFormat.Png,
OnePagePerSheet = true
};

var worksheet = workbook.Worksheets[0];

worksheet.PageSetup.PrintArea = string.Format(“b4:h16”);
worksheet.PageSetup.TopMargin = 0;
worksheet.PageSetup.LeftMargin = 0;
worksheet.PageSetup.RightMargin = 0;
worksheet.PageSetup.BottomMargin = 0;

var sheetRender = new SheetRender(worksheet, imageOptions);

sheetRender.ToImage(0, @“E:\test2\TextBoxInExcel_shapeexport\TextBoxInExcel\bin\Debug\output1.png”);

I have logged a ticket with an id: CELLSNET-40914. We will look into your issue soon.

Thank you.

Hi,

We have fixed this issue.

Please download and try this fix: Aspose.Cells for .NET v7.3.0.3

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


This message was posted using Notification2Forum from Downloads module by aspose.notifier.