I need to fit all the excel export content on a single pdf page (as we are not using PDF for printing to paper) - regardless of the number of rows of data in excel.
When I setup the worksheet like so:
ws.PageSetup.Orientation = ExcelPageOrientation.Landscape;
ws.PageSetup.FitToPagesWide = 1;
ws.PageSetup.FitToPagesWide = 1;
//Trying largest paper size I could find, but still not nearly big enough.
ws.PageSetup.PaperSize = ExcelPaperSize.A2Paper;
var converter = new ExcelToPdfConverter(ws);
var pdf = converter.Convert();
And perform the convert to pdf, I get a bunch of overlapped text: screenshot here: http://i.imgur.com/d7IIYds.png
We are currently using SautinSoft.ExcelToPDF, and it automatically scales the paper size based on the content and provides our correct behavior - but the product is slow and support is poort.
Is there a way in syncfusion to do this?
Thank you!
Josh