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

Free Support Forum - aspose.com

Text being cut when rendering Excel sheet to image using Aspose

Hi,

When converting an Excel sheet to emf using Aspose, I noticed the text being cut.

Using the following code on the attachment template:
var workbook = new Workbook(@“test.xlsx”);
var options = new ImageOrPrintOptions
{
ImageFormat = ImageFormat.Emf,
OnlyArea = false, // copy as printed
TextRenderingHint = TextRenderingHint.ClearTypeGridFit,
OnePagePerSheet = true,
};

        new SheetRender(workbook.Worksheets["Sheet1"], options).ToImage(0, @"test.emf");

You will find in the output some text is cut (see screenshot), and it is different from copy&paste manually using MS Excel (select the cells, copy as picture-> as shown when printed) which produced a fine output.

Could you take a look into this?

Thanks
screenshot.png (217.0 KB)test.zip (31.4 KB)

@ServerSide527

Thanks for using Aspose APIs.

We were able to observe this issue as per your description with your sample code and sample Excel file.

We have logged this issue in our database for investigation and for a fix. We will look into it and fix this issue. Once, the issue is resolved or we have some other news for you, we will let you know asap.

This issue has been logged as

  • CELLSNET-45536 - Text being cut when rendering Excel sheet to Image

@ServerSide527,

This is to inform you that we have fixed your issue “CELLSNET-45536” now. We will soon provide the fix after performing QA and including other enhancements and fixes.

Thank you.

@ServerSide527,

Please try our latest version/fix: Aspose.Cells for .NET v17.7.5:


Your issue should be fixed in it.

Let us know your feedback.

Thank you.

The issues you have found earlier (filed as CELLSNET-45536) have been fixed in latest version of Aspose.Cells for .NET (Download | NuGet).