Please find attached a sample project and a photo of my print and the spreadsheet used to render them with. The sheet was generated too using Cells.
Hi there, apologies but I am a little bit confused… When sending a sheet with sheet renderer to an image, I am expecting the sheets to fit one per page. When I am sending a book to Workbook Renderer, I expect the rendered image to contain all the sheets in one image (since ToImage() indicates creating a single image from the workbook not individual sheets)
Hi there, I am not sure what text wrapping has to do with copies of the totals over printing on page 2 from page 1 (see the photograph in the first message). When you print the worksheet on paper using the sample code sent does it print correctly (please for the moment ignore all the rendering to image issues since they are just confusing the issue)
This issue is caused by we cannot make the same default page breaks for certain default fonts similar to what Excel does. You can use the following as a workaround:
sheet.PageSetup.FitToPagesTall = 1;
sheet.PageSetup.FitToPagesWide = 1;
2) For "WorkbookRender" :
It can only be used when saving to Tiff image, XPS or printer.
All worksheets will be saved to single multi-page Tiff image, one sheet will be saved in a Tiff Page.
Your can view each page in Tiff using Microsoft Picture viewer tool.
The size of Tiff image is decided by the largest Tiff Pages.
3) For "OnePagePerSheet property":
IF this property is true, it will change size of the output image size, because all data needs to be rendered to a single image. And if OnePagePerSheet is true, the page size setting of PageSetup will not take effect (mind you), I think for this issue or case, you should set OnePagePerSheet to false, for you do not want to change size of the output image.
Thanks for your understanding!