Hello,
We are having a problem, with latest version of Aspose.Cells (v7.3.0), when rendering cells that have text orientation set. Following is the code used to reproduce the issue:
var workbook = new Workbook(@“TextOrientation.xls”);
workbook.Save(@“TextOrientation.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:f5"</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;">@"TextOrientation.png"</span>); //save to PNG<br><br><br>You can observe in the attached image that orientation of the cells (marked with red) is not preserved.<br><br>Thank you,<br>Bogdan Rusu,<br>IBM Romania.<br></pre>
Hi,
Thanks for your posting and using Aspose.Cells.
We were able to replicate this issue using the latest version:
Aspose.Cells for .NET 7.3.0 with your source files.
We have logged this issue in our database. We will look into it and fix the problems. Once the fix is available or we have some other update for you, we will let you know asap.
Also thanks for your sample code, screenshot and sample files, we have logged all of these in our database, these will be definitely helpful in fixing this bug.
This issue has been logged as CELLSNET-40865.
Hello,
Thank you for your quick reply, we are waiting for the fixed version.
Regards,
Bogdan Rusu,
IBM Romania.
Hi Adrian,
Sure. Your issue has been linked with this thread, and as soon as it is resolved, you will be notified about the resolution/fix of this issue. We appreciate your patience in this regard.
Hi! This issue is still present in Aspose Cells 7.3.2.
Thank you,
Dragos Culea
Hi,
Thanks for your feedback.
We have reopened this issue. We will look into it and fix this issue and get back to you asap.
Hi,
Thanks for your posting and using Aspose.Cells for .NET.
We have fixed this issue.
.
Please download and try this fix: Aspose.Cells for .NET v7.4.0.1 and let us know your feedback.
The issues you have found earlier (filed as CELLSNET-40865) have been fixed in this update.
This message was posted using Notification2Forum from Downloads module by aspose.notifier.
Hi,
Thank you for the fix.
Regards,
Lucian Nistor
Senior .Net Developer
IBM Romania
Hi,
You are welcome.
Feel free to contact us any time if you have any issue or need further help, we will be happy to assist you soon.
Thank you.