Hi,
When rendering an Excel sheet into image, I noticed it rendered an extra legend which does not appear in the original Excel file.
Code:
var book = new Workbook(@“test.xlsx”);
Worksheet sheet = book.Worksheets[0];
var options = new ImageOrPrintOptions
{
ImageFormat = ImageFormat.Emf,
OnlyArea = false,
OnePagePerSheet = true
};
SheetRender sr = new SheetRender(sheet, options);
sr.ToImage(0, @“output.emf”);
Could you check this issue to see if it could be fixed?
Thanks,
Hi John,
Hi,
Hi Amjad,
I think you might be using the evaluation version so the ‘dotted line’ is actually the Aspose’s evaluation version info.
However, I’ve provided the new test samples and a screenshot to point the difference.
Thanks
Hi,
Hi,
Thanks for your reply.
As far as I’m aware of, OnlyArea is to determine if the rendering is ‘Copy as Printed’. (edited: If the value is false then it’s copy as printed, and if it is true it’s copy as shown on screen).
I asked the question earlier in the other post and understood it is necessary to use this value as false when I want the image to be displayed as printed.
How to Copy as Picture - As shown when printed in Aspose
And also in Office Excel, copy this area either using ‘Copy Picture - As shown on screen’ or ‘Copy Picture - As shown when printed’ will not produce the extra legend. So the behavior from Microsoft Excel and Aspose are different here.
As I will need to render the output as printed, so I think I might not be able to set this value to true. Could you please help me to check if this is an issue?
Thanks
Hi,
Hi John,
Hi again,
Hi,
Thanks for your update. I have tested the case using Aspose.Cells 16.11.1.0 and the issue didn’t seem to happen again.
I will be able to test with a full document once the .Net 4.0 version has been released. Thanks very much.
We have requested the product team to provide you .NET 4.0 compiled version if possible. Once, it is available, we will let you know asap. Otherwise, you will have to wait for Aspose.Cells official release which will be available in next month.
The issues you have found earlier (filed as CELLSNET-44831) have been fixed in this update.
This message was posted using Notification2Forum from Downloads module by Aspose Notifier.