Cell Vertical Alignment rendering issue

Aspose.Cells Product Family
1

Hello,

We are having a problem regarding the rendering of cells that have Left/Right Vertical Alignment using the latest version of Aspose.Cells (v7.3.0); checking the attached files you can see that Left is rendered as Right and Right is rendered as Left.

This is the code to reproduce this issue:

            var workbook = new Workbook(@“VerticalAlignment.xls”);

workbook.Save(@“VerticalAlignment.pdf”, SaveFormat.Pdf); //Save to PDF

        <span style="color:blue;">var</span> imageOptions = <span style="color:blue;">new</span> <span style="color:#2b91af;">ImageOrPrintOptions</span>
                               {
                                   Quality = 100,
                                   VerticalResolution = 200,
                                   HorizontalResolution = 200,
                                   PrintingPage = <span style="color:#2b91af;">PrintingPageType</span>.IgnoreBlank,
                                   ImageFormat = <span style="color:#2b91af;">ImageFormat</span>.Png,
                                   OnePagePerSheet = <span style="color:blue;">true</span>
                               };

        <span style="color:blue;">var</span> worksheet = workbook.Worksheets[0];

        worksheet.PageSetup.PrintArea = <span style="color:blue;">string</span>.Format(<span style="color:#a31515;">"a1:e5"</span>);
        worksheet.PageSetup.TopMargin = 0;
        worksheet.PageSetup.LeftMargin = 0;
        worksheet.PageSetup.RightMargin = 0;
        worksheet.PageSetup.BottomMargin = 0;

        <span style="color:blue;">var</span> sheetRender = <span style="color:blue;">new</span> <span style="color:#2b91af;">SheetRender</span>(worksheet, imageOptions);

        sheetRender.ToImage(0, <span style="color:#a31515;">@"VerticalAlignment.png"</span>); // save to PNG</pre><br>Thank you,<br>Bogdan Rusu,<br>IBM Romania.<br>
2

Hi,

Thanks for your posting and using Aspose.Cells for .NET.

I compared your results with Ms-Excel results and able to notice the issue. Please see the Ms-Excel results below in a screenshot.

I have highlighted the problems with red circles around them.

We have logged this issue in our database. Once it is resolved or we have some other feedback for you, we will let you know asap.

This issue has been logged in our database with issue id: CELLSNET-40858

Screenshot:

3

Hi Bogdan,


Thank you for using Aspose.Cells.

I can reproduce/notice the issue as you have mentioned in your post. It’s a bug in the rendering module of Aspose.Cells library.

I have forwarded these details to our development team for further investigation and rectification of the issue. We will let you know here once this issue is resolved.
4

Hello,

Thank you for the quick response, we are waiting for the fixed version.

Regards,
Bogdan Rusu,
IBM Romania.

5

Hi,

You are welcome. Once the fix is available we will update you soon.

Thanks for your patience and have a nice day.

6

Hi,

We have fixed this issue.

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

7

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

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

The issues you have found earlier (filed as ) have been fixed in this update. This message was posted using BugNotificationTool from Downloads module by MuzammilKhan