GrapeCity.Xaml.SpreadSheet.Data
PageRange Property
Example 


GrapeCity.Xaml.SpreadSheet.Data Namespace > PrintInfo Class : PageRange Property
Gets or sets the page range for printing.
Syntax
'Declaration
 
<DefaultValueAttribute()>
Public Property PageRange As String
'Usage
 
Dim instance As PrintInfo
Dim value As String
 
instance.PageRange = value
 
value = instance.PageRange
[DefaultValue()]
public string PageRange {get; set;}

Property Value

A string that provides page numbers or page ranges. The default value is an empty string.
Remarks
Type page numbers or page ranges separated by commas counting from the beginning of the document. For example, type "1,3,5-12".
Example
This example sets the PageRange property.
int i, j;
for (i = 0; i <= 50; i++)
{
       for (j = 0; j <= 20; j++)
        gcSpreadSheet1.ActiveSheet.SetValue(i, j, "test");
}

GrapeCity.Xaml.SpreadSheet.Data.PrintInfo printset = new GrapeCity.Xaml.SpreadSheet.Data.PrintInfo();
printset.Orientation = GrapeCity.Xaml.SpreadSheet.Data.PrintPageOrientation.Portrait;
printset.PageOrder = GrapeCity.Xaml.SpreadSheet.Data.PrintPageOrder.Auto;
printset.PageRange = "1-3";
printset.PaperSize = new GrapeCity.Xaml.SpreadSheet.Data.PaperSize(GrapeCity.Xaml.SpreadSheet.Data.PaperKind.Letter);
//printset.PaperSize = new GrapeCity.Xaml.SpreadSheet.Data.PaperSize(600, 300);
//printset.PaperSize = new GrapeCity.Xaml.SpreadSheet.Data.PaperSize();
gcSpreadSheet1.Sheets[0].PrintInfo = printset;
For i = 0 To 50
For j = 0 To 20
GcSpreadSheet1.ActiveSheet.SetValue(i, j, "test")
Next j
Next i

Dim printset As New GrapeCity.Xaml.SpreadSheet.Data.PrintInfo()
printset.Orientation = GrapeCity.Xaml.SpreadSheet.Data.PrintPageOrientation.Portrait
printset.PageOrder = GrapeCity.Xaml.SpreadSheet.Data.PrintPageOrder.Auto
printset.PageRange = "1-3"
'printset.PaperSize = new GrapeCity.Xaml.SpreadSheet.Data.PaperSize(GrapeCity.Xaml.SpreadSheet.Data.PaperKind.Letter)
printset.PaperSize = New GrapeCity.Xaml.SpreadSheet.Data.PaperSize(600, 300)
'printset.PaperSize = new GrapeCity.Xaml.SpreadSheet.Data.PaperSize()
GcSpreadSheet1.Sheets(0).PrintInfo = printset
See Also

Reference

PrintInfo Class
PrintInfo Members