Printing and fitting the spreadsheet to one page

[Travis Chambers]

Good day,

I am having trouble with printing from the spreadsheet control. I have replicated the code from the print sample application and I cant get either method to work quire right. The first method:

"PrintPreviewForm previewform = new PrintPreviewForm() { sfspreadsheet = this.spreadsheet1 };

previewform.show();"

this method works well except for the fact that it does not fit the spreadsheet data on a single page. For example, if I open a spreadsheet that has data from col. A to col. U, I need it to be resized to fit on a single page, but it spreads it out over 9 pages.

The second method:

"PrintFrompdfViewer( this.spreadsheet1);"

I am able to fit everything on one page with this method using settings.layoutoptions and it displays perfectly in the preview dialog, but when I actually print it it only prints a blank page for some reason.

Any assistance with this would be hugely appreciated.

thanks.

[Kanimozhi Bharathi]

Hi Travis Chambers, 

 

Thank you for contacting Syncfusion Support. 

 

We have analyzed your query. You can print the spreadsheet data in a single page by setting the LayoutOptions as FitSheetOnOnePage. We have prepared a sample based on your requirement. Please find the link below, 

 

Sample: http://www.syncfusion.com/downloads/support/directtrac/general/ze/CS-266511938 

 

We have also checked by printing in XPS Viewer and One note book and it correctly sends only one page for print. Please find the attachment for your reference. 

 

XPS: http://www.syncfusion.com/downloads/support/directtrac/general/ze/print605821601 

 

If the printing issue still reproduces at your end, modify the above sample to reproduce the issue and update us with the replication procedure and product version details. So that we will analyze and update you with the appropriate solution. 

 

Regards 

Kanimozhi B 

[Travis Chambers]

Thank you for your response. I have attempted to open the sample you provided, however I am getting an error for each form within the solution. 

For form 1 is says "Could not find type 'DemoCommon.Grid.GridDemoForm'. Please make sure that the assembly that contains this type is referenced. If this type is a part of your development project, make sure that the project has been successfully built using settings for your current platform or Any CPU."

For PrintPreviewForm is says "Could not find type 'Syncfusion.Windows.Forms.MetroForm'. Please make sure that the assembly that contains this type is referenced. If this type is a part of your development project, make sure that the project has been successfully built using settings for your current platform or Any CPU."

Thank you.

[Travis Chambers]

Additionally, I need it to print in Landscape orientation.

Thanks.

[Kanimozhi Bharathi]

Hi Travis Chambers, 

 

Sorry about the inconvenience. 

 

We have prepared the sample based on your requirement of printing in “Landscape” orientation by setting the PageSettings of PdfDocument’s Orientation as “LandScape” like below code example, 

 

//Create the previewdialog for print the document. 

PrintPreviewDialog printdialog = new PrintPreviewDialog(); 

 

//Create the pdfviewer for load the document. 

PdfViewerControl pdfviewer = new PdfViewerControl(); 

 

// PdfDocumentViewer 

MemoryStream pdfstream = new MemoryStream(); 

 

ExcelToPdfConverter converter = new ExcelToPdfConverter(spreadsheetControl.Workbook); 

//Intialize the PdfDocument 

PdfDocument pdfDoc = new PdfDocument(); 

 

//Intialize the ExcelToPdfConverter Settings 

ExcelToPdfConverterSettings settings = new ExcelToPdfConverterSettings(); 

settings.LayoutOptions = LayoutOptions.FitSheetOnOnePage; 

 

 

//Assign the PdfDocument to the templateDocument property of ExcelToPdfConverterSettings 

settings.TemplateDocument = pdfDoc; 

settings.DisplayGridLines = GridLinesDisplayStyle.Invisible; 

 

//Convert Excel Document into PDF document 

pdfDoc = converter.Convert(settings); 

 

//Setting the Orientation 

pdfDoc.PageSettings.Orientation = PdfPageOrientation.Landscape; 

 

//Save the PDF file 

pdfDoc.Save(pdfstream); 

 

//Load the document to pdfviewer 

pdfviewer.Load(pdfstream); 

 

printdialog.Document = pdfviewer.PrintDocument; 

 

printdialog.ShowDialog(); 

 

 

 

For more information regarding page settings, please refer the below UG: 

 

https://help.syncfusion.com/file-formats/pdf/working-with-document#working-with-document-properties 

 

Regarding this issue “Could not find type 'Syncfusion.Windows.Forms.MetroForm”, can you please check whether “Syncfusion.Shared.Base.dll” assembly is correctly referenced in your sample and we have resolved this issue “"Could not find type 'DemoCommon.Grid.GridDemoForm'”. please find the updated sample below, 

 

Sample link: http://www.syncfusion.com/downloads/support/directtrac/general/ze/CS-1597003249 

 

 

Regards 

Kanimozhi B 

[Travis Chambers]

Thank you again for your response. The sample does work now, however my issues still remain. The code to convert to landscape you provided is for the pdfviewer option (the "print" button). While this does display the document perfectly, when you select the print option within the pdfviewer it prints a blank page as if the document being viewed and the document being printed are two seperate docs with the print doc being a new blank one. Your sample does this too.

That being said, the other option (using the printpreviewform / "Print Preview" button) does print the document but that is where it is not printing in landscape format and the above code does not appear to apply to that method. So, I either need the pdfviewer option to actually print the document being viewed or the printpreviewform to print in landscape.

Thank you again for all of your help!

[Kanimozhi Bharathi]

Hi Travis Chambers, 

We have checked the issue with our sample. But we were unable to reproduce the issue. So could you please share us the excel which you used for printing which will help us to analyze the issue better and provide you appropriate solution. 

Sample:  http://www.syncfusion.com/downloads/support/directtrac/general/ze/CS-1597003249 

Regards 

Kanimozhi B 

[Travis Chambers]

Good day,

Please see the attached excel doc that I am using to print. To recap my issues:

Using this method:

  private void button2_Click(object sender, EventArgs e)

        {

            PrintPreviewForm previewform = new PrintPreviewForm() { sfspreadsheet = this.spreadsheet1 };

            previewform.Show();

 private void btnPrint_Click(object sender, EventArgs e)

        {

            PrintDialog dialog = new PrintDialog();

            int pageCount = pdfDocumentView1.PageCount;

            dialog.AllowPrintToFile = true;

            dialog.AllowSomePages = true;

            dialog.PrinterSettings.FromPage = 1;

            dialog.PrinterSettings.ToPage = pageCount;

            dialog.PrinterSettings.MaximumPage = pageCount;

            dialog.PrinterSettings.MinimumPage = 1;

            dialog.PrinterSettings.DefaultPageSettings.Landscape = true;

        

            

            if (dialog.ShowDialog() == DialogResult.OK)

            {

                dialog.Document = pdfDocumentView1.PrintDocument;

                dialog.Document.Print();

            }

        }

     

This fits to one page and it prints just fine as well, however when it prints it does no do so in landscape but instead in tries to fit in all into the portrait view.

Using this secondmethod:

 private void button3_Click(object sender, EventArgs e)

        {

            PrintFromPdfViewer(this.spreadsheet1);

        }

        private static void PrintFromPdfViewer(Spreadsheet spreadsheetControl)

        {

            //Create the previewdialog for print the document. 

            PrintPreviewDialog printdialog = new PrintPreviewDialog();

            //Create the pdfviewer for load the document. 

            PdfViewerControl pdfviewer = new PdfViewerControl();

            // PdfDocumentViewer 

            MemoryStream pdfstream = new MemoryStream();

            ExcelToPdfConverter converter = new ExcelToPdfConverter(spreadsheetControl.Workbook);

            //Intialize the PdfDocument 

            PdfDocument pdfDoc = new PdfDocument();

            //Intialize the ExcelToPdfConverter Settings 

            ExcelToPdfConverterSettings settings = new ExcelToPdfConverterSettings();

            settings.LayoutOptions = LayoutOptions.FitSheetOnOnePage;

            //Assign the PdfDocument to the templateDocument property of ExcelToPdfConverterSettings 

            settings.TemplateDocument = pdfDoc;

            settings.DisplayGridLines = GridLinesDisplayStyle.Invisible;

            //Convert Excel Document into PDF document 

           

            pdfDoc = converter.Convert(settings);

            //Setting the Orientation 

            pdfDoc.PageSettings.Orientation = PdfPageOrientation.Landscape;

            //Save the PDF file 

            pdfDoc.Save(pdfstream);

            //Load the document to pdfviewer 

            pdfviewer.Load(pdfstream);

            printdialog.Document = pdfviewer.PrintDocument;

            pdfDoc.Save("SaveTest");

            printdialog.ShowDialog();

        }

Here the document shows great in the printpreview box, however when I print it only prints a blank page.

I need to be able to print the doc successfully in landscape format.

Also, if it is possible to add in an option to choose to save as a pdf document without printing, that is a feature I sorely need as well.

Thank you for your assistance!

Attachment: sanitized_sample_13d2542f.zip

[Kanimozhi Bharathi]

Hi Travis Chambers,  

   

We have checked your orientation issue. You can overcome this issue by setting the PageSettings of PdfDocument and PageSetup of Worksheet’s Orientation as “LandScape” while printing as given in the following code example.  

  

//Create the previewdialog for print the document.  

PrintPreviewDialog printdialog = new PrintPreviewDialog();  

  

//Create the pdfviewer for load the document.  

PdfViewerControl pdfviewer = new PdfViewerControl();  

  

// PdfDocumentViewer  

MemoryStream pdfstream = new MemoryStream();  

  

//Set Orientation in Worksheet also, 

spreadsheetControl.Workbook.ActiveSheet.PageSetup.Orientation = ExcelPageOrientation.Landscape;  

 

ExcelToPdfConverter converter = new ExcelToPdfConverter(spreadsheetControl.Workbook);  

 

//Intialize the PdfDocument  

PdfDocument pdfDoc = new PdfDocument();  

  

//Intialize the ExcelToPdfConverter Settings  

ExcelToPdfConverterSettings settings = new ExcelToPdfConverterSettings();  

settings.LayoutOptions = LayoutOptions.FitSheetOnOnePage;  

  

  

//Assign the PdfDocument to the templateDocument property of ExcelToPdfConverterSettings  

settings.TemplateDocument = pdfDoc;  

settings.DisplayGridLines = GridLinesDisplayStyle.Invisible;  

  

//Convert Excel Document into PDF document  

pdfDoc = converter.Convert(settings);  

  

//Setting the Orientation  

pdfDoc.PageSettings.Orientation = PdfPageOrientation.Landscape;  

  

//Save the PDF file  

pdfDoc.Save(pdfstream);  

  

//Load the document to pdfviewer  

pdfviewer.Load(pdfstream);  

  

printdialog.Document = pdfviewer.PrintDocument;  

  

printdialog.ShowDialog();  

  

  

  

We have also prepared a sample based on your requirement of including an option to save the content as PDF.  Please find the sample link below, 

 

Sample: http://www.syncfusion.com/downloads/support/directtrac/general/ze/CS1536371882 

 

We were unable to reproduce the issue of printing the blank pages in our side. For your reference, please find the attached PDF’s in LandScape and Potrait orientation which are generated from the sample. 

 

PDF’s: http://www.syncfusion.com/downloads/support/directtrac/general/ze/PDF887317098 

 

If the printing issue still persists, modify the above sample to reproduce the issue and send it to us with the replication procedure and product version details, so that we could check and provide an appropriate solution. 

  

Regards  

Kanimozhi B 

[Travis Chambers]

Thank you so much! The save to pdf option works and then I can print from there, so I believe that pretty much solves my issue. 

I do have one last question regarding this issue however. When it saves to pdf it hows typical margins at the top and bottom of the page (rougly 1 inch margins). Is there a way to remove the margins to reduce the white space?

Thanks again!

[Kanimozhi Bharathi]

Hi Travis Chambers,  

 

You can set the top and bottom margin of the pdf page like below code example, 

 

 

pdfDoc.PageSettings.Margins.Top = 0; 

pdfDoc.PageSettings.Margins.Bottom = 0; 

 

 

For more information, please refer the below UG link 

 

https://help.syncfusion.com/file-formats/pdf/working-with-pages 

 

Regards 

Kanimozhi B 

[Travis Chambers]

Thank you very much. Unfortunately that did not change the margins.  So, I am thinking that my issue may be with the spreadsheet's margins, not the pdf margins. I am comparing this document in pdf to the same excel document when saving it to pdf from Excel. However, in Excel I can modify the margins to "0" before saving to pdf. Does Spreadsheet have it's own margin settings that I may be missing?

Thanks!

[Kanimozhi Bharathi]

Hi Travis Chambers, 

 

We were able to reproduce the margin issue with PDF and forwarded the issue internally to XlsIO team. Also we have a created  incident in your account. So can you please log into our support website for further update on this issue. 

 

Regards 

Kanimozhi B 

[Kanimozhi Bharathi]

Hi Travis Chambers, 

We were able to reproduce the margin issue while exporting to PDF and forwarded the issue internally to XlsIO team. A support incident has been created under your account to track the status of this issue. Please log on to our support website to check for further updates. 

https://www.syncfusion.com/account/login?ReturnUrl=/support/directtrac/incidents 

Regards 

Kanimozhi B