Vertical Text Justification via SheetRender ToImage

Aspose.Cells Product Family
1

In Aspose.Cells for .NET, when using ToImage with a SheetRender, is it possible to preserve vertical justification of text in merged cells? Please see attached the relevant code and screenshots of the image and the Excel output. The Excel output is correctly justified, the image is not. Thank you.

2

Hi,

Thanks for using Aspose.Cells.

It might be because of some bug with Aspose.Cells. Please download and try the latest version: Aspose.Cells
for .NET v8.0.1.3 and see if it fixes your issue.

If your issue persists, then please provide us your sample xls/xlsx file and the sample code replicating the issue with the latest version. We will look into it and update you asap.

Please also highlight your issue with red circles, because I do not see any noticeable difference between your images except text at the right (i.e At the end 4Q 2013, the total vacancy…) has more vertical spacing. Is this the issue you are encountering?

3

Thank you for the response; you have identified the issue correctly. I tried the latest version of Aspose.Cells, but the problem persists.



Attached is the related code file and a sample xlsx file generated using the latest version.

4

Hi Jeff,

Thanks for your sample file and using Aspose.Cells.

We were able to notice this issue. Vertical text justification is not working correctly in the sheet render.

We have logged this issue in our database for investigation. We will look into it and fix this issue. 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-42594.

I have tested it with the following code. I have attached the output image that also highlights the issue for a reference.

C#


Workbook workbook = new Workbook(path);


Worksheet worksheet = workbook.Worksheets[0];


Aspose.Cells.Rendering.ImageOrPrintOptions options = new Aspose.Cells.Rendering.ImageOrPrintOptions();

options.OnePagePerSheet = true;

options.ImageFormat = ImageFormat.Png;


SheetRender sr = new SheetRender(worksheet, options);

sr.ToImage(0, path + “.out.png”);

5

Hi Jeff,

Thanks for using Aspose.Cells.

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

6

The fix appears to be working - thanks very much for providing the solution.

7

Hi,


Good to know that it figures out your issue, we have closed your ticket now. Feel free to contact us any time if you need further help or have some other issue or queries, we will be happy to assist you soon.

Thank you.


8

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

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.