Changing Print Settings - Print Preview with RadSpreadSheet

[Lloyd Johnson]

I am successfully using Print Preview with GridView using RadSpreadSheet.  The defaults in the Print Dialog box are completely wrong for my application but I can find no resources that say how to change these defaults.

Can someone please direct me to some sample code that shows how to change the print setting defaults?

[Stefan Nenchev]

Hello Lloyd,

In case some other customer is looking for the same functionality,  I am here providing the information from the other thread where we have discussed the issue:

The Orientation and Margins can be controlled by setting the WorksheetPageSetup settings of each individual Worksheet within the Workbook that the RadSpreadSheet contains. I suggest you have a look at the RadSpreadProcessing documentation for more information. As a certain Workbook can contain multiple Worksheets, you can iterate over them and set their settings:

private static RadSpreadsheet CreateSpreadsheet(RadGridView grid)
{
    var workbook = CreateWorkBook(grid);

    return new RadSpreadsheet()
    {
        Workbook = CreateWorkBook(grid)
    };
}

private static Workbook CreateWorkBook(RadGridView grid)
{
    Workbook book = null;

    using (var stream = new MemoryStream())
    {
        if (grid != null)
        {
            grid.ExportToXlsx(stream, new GridViewDocumentExportOptions()
            {
                ShowColumnFooters = grid.ShowColumnFooters,
                ShowColumnHeaders = grid.ShowColumnHeaders,
                ShowGroupFooters = grid.ShowGroupFooters,
                ExportDefaultStyles = true
            });
        }

        stream.Position = 0;

        book = new XlsxFormatProvider().Import(stream);
    }

    foreach (var item in book.Worksheets)
    {
        (item as Worksheet).WorksheetPageSetup.PageOrientation = Telerik.Windows.Documents.Model.PageOrientation.Landscape;
        (item as Worksheet).WorksheetPageSetup.Margins = PageMargins.WideMargins;
    }

    return book;
}

I am also attaching the sample - a modified version of the Print Preview with RadSpreadSheet demo from our SDK Samples Browser.

Regards,
Stefan Nenchev
Telerik by Progress