GrapeCity.Xaml.SpreadSheet.Data
PageRange Property
Example 


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
Requirements

Target Platforms: Windows Server 2012, Windows RT

See Also

Reference

PrintInfo Class
PrintInfo Members

 

 


Copyright © GrapeCity, inc. All rights reserved.

Support Options