Hello,
We’re currently having an issue with the way SheetRender is rendering ranges to image. Seems that the size of the output image differs when run on different systems:
Here is the code used to reproduce the issue:
var workbook = new Workbook(@“Image.xlsx”);<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]; <span style="color:blue;">string</span> printArea = <span style="color:blue;">string</span>.Format(<span style="color:#a31515;">"b2:k24"</span>); worksheet.PageSetup.PrintArea = printArea; 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); <span style="color:#2b91af;">Console</span>.WriteLine(<span style="color:#a31515;">"PageSize: </span><span style="color:mediumseagreen;">{0}</span><span style="color:#a31515;">"</span>, worksheet.PageSetup.PaperSize); <span style="color:blue;">var</span> size = sheetRender.GetPageSize(0); <span style="color:#2b91af;">Console</span>.WriteLine(<span style="color:#a31515;">"Page size: Width:</span><span style="color:mediumseagreen;">{0}</span><span style="color:#a31515;">, Height:</span><span style="color:mediumseagreen;">{1}</span><span style="color:#a31515;">"</span>, size.Width, size.Height); sheetRender.ToImage(0, <span style="color:#a31515;">@"out.png"</span>);</pre>After running the above code on different systems with different Windows versions will notice that the page size is reported differently, also the output image has different size:<br><br>Windows Server 2003, x86/x64<br>PageSize: PaperA4<br>Page size: Width:1607, Height:928<br><br>Windows Server 2008 R2, x64<br>PageSize: PaperA4<br>Page size: Width:1406, Height:928<br><br>Windows 7, x64<br>PageSize: PaperA4<br>Page size: Width:1406, Height:928<br><br>Thank you,<br>Bogdan Rusu,<br>IBM Romania.<br><br>