When rendering an Excel sheet into image, I found when there are text which is wider than its column width, the image rendered will be different from the Excel sheet and also different from copy/paste from Excel manually.
var book = new Workbook(@“test.xlsx”);
Worksheet sheet = book.Worksheets;
var options = new ImageOrPrintOptions
ImageFormat = ImageFormat.Emf,
OnlyArea = false,
OnePagePerSheet = true
SheetRender sr = new SheetRender(sheet, options);
You can find in text.xlsx, Cell B1 has a value ‘0’ but because of container not big enough, the character is hidden. But in the rendered image, the character appears.
Could you check this issue to see if Aspose can behave the same as Office there?
Thanks for your update.
I’ve tried 184.108.40.206 with the test.xlsx I provided for you and it worked. However, when I tested with another sample .xlsx file the issue remains.
I’ve attached the new test file, could you have a look into that?
Thanks for your update. I’ve tested Aspose.Cells for .NET v220.127.116.11 (.NET 4.0) with the test files and did not see the issue again.
Thanks very much