Image rendering does not work properly with rotated textboxes and chart's x-axis ticklabels

Aspose.Cells Product Family
1

Hi,



Here are two cases where Aspose.Cells did not render images properly.



When a textbox in Excel sheet has a rotation angle, the textbox in output image will be badly positioned.



Also, when a ticklabel in X-Axis is long, this ticklabel in the output image may have characters missing, even when it is displayed in the original chart properly.



Code:



var book = new Workbook(“test.xlsx”);

Worksheet sheet = book.Worksheets[0];

var options = new ImageOrPrintOptions { HorizontalResolution = 300, VerticalResolution = 300, ImageFormat = ImageFormat.Emf };

var renderer = new SheetRender(sheet, options);

renderer.ToImage(0, “out.emf”);



You can see the ticklabel “THIS IS A LONG TEXT” is displayed in excel chart properly but in the output image " TEXT" is missing. And you can also find the red textbox is wrongly positioned.



It is not only happening with EMF images but with all image formats.



Thanks,

2

Hi John,


Thank you for sharing the sample spreadsheet.

We have evaluated the presented scenarios while using the latest version of Aspose.Cells for .NET 8.8.0.1, and we are able to replicate both mentioned issues. In order to further investigate these incidents, we have logged the following tickets.

  • CELLSNET-44400: Text of the Tick Labels is trimmed while rendering worksheet
  • CELLSNET-44401: Rotated TextBox is misplaced while rendering worksheet

Please spare us little time to properly analyze these scenarios and get back with updates in this regard.
3

Hi again,


This is to update you that both of the tickets attached to this thread have been marked resolved. We will shortly share the fix here after ensuring the quality and incorporating other enhancements.
4

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

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