Lost spaces when rendering Excel range to image

Aspose.Cells Product Family
1

Hello! In a workbook there is a cell containing some text with multiple space characters. When exporting a container range to image using SheetRender, the space characters are lost. Please, check the attached console project!

Thank you.

2

Hi,

Thanks for your sample project and using the latest version.

I was able to replicate the problem using the latest version:
Aspose.Cells
for .NET v7.3.0.2


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

This issue has been logged as CELLSNET-40907.

Below is a sample code and screenshot that highlights the problem. I have also attached the output image.

C#


string filePath = @“F:\Shak-Data-RW\Downloads\TextConcat.xlsx”;


var workbook = new Workbook(filePath);


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(“a1:c3”);

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, filePath + “.out.png”);

Ouptut Image & Screenshot:
3

Hi,

We have fixed this issue.

Please download and try this fix: Aspose.Cells for .NET v7.3.1.7 and let us know your feedback.

4

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

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