Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / SheetView Class / PreviewRowStyle Property
Example


In This Topic
    PreviewRowStyle Property
    In This Topic
    Gets or sets the style information for the preview row.
    Syntax
    'Declaration
     
    Public Property PreviewRowStyle As PreviewRowInfo
    'Usage
     
    Dim instance As SheetView
    Dim value As PreviewRowInfo
     
    instance.PreviewRowStyle = value
     
    value = instance.PreviewRowStyle
    public PreviewRowInfo PreviewRowStyle {get; set;}
    Example
    This example customizes the appearance of the preview row.
    // Add this style definition inside the STYLE element in the Default.aspx page.
    .previewer  
     {  
           border-style:dashed;
         border-color:Green;
         border-width:thick;
         font-family:Arial;
         font-style:italic;
         color:Blue;
         background-color:Yellow;
         text-align:right;
         text-decoration:'underline'|'overline'|'line-through'|'blink';
         vertical-align:bottom;
     } 
    
    
    // Define the background.
    FarPoint.Web.Spread.Background bg = new FarPoint.Web.Spread.Background();
    bg.SelectedBackgroundImageUrl = "picture/Winter.jpg";
    bg.BackgroundImageUrl = "picture/Image.bmp";
    FarPoint.Web.Spread.Border bd1 = new FarPoint.Web.Spread.Border();
    bd1.BorderColor = System.Drawing.Color.Blue;
    bd1.BorderStyle = System.Web.UI.WebControls.BorderStyle.Dashed;
    
    // Set the preview row properties.
    FarPoint.Web.Spread.PreviewRowInfo previewRowInfo = new FarPoint.Web.Spread.PreviewRowInfo();
    previewRowInfo.BackColor = Color.Blue;
    previewRowInfo.Background = bg;
    previewRowInfo.Border = bd1;
    previewRowInfo.HorizontalAlign = System.Web.UI.WebControls.HorizontalAlign.Center;
    previewRowInfo.VerticalAlign = System.Web.UI.WebControls.VerticalAlign.Middle; 
    previewRowInfo.TabStop = true;
    previewRowInfo.Margin.Bottom = 10;
    previewRowInfo.Margin.Left = 10;
    previewRowInfo.Margin.Right = 10;
    previewRowInfo.Margin.Top = 10;
    previewRowInfo.ForeColor = System.Drawing.Color.Green;
    previewRowInfo.CssClass = "previewer";    // If set to previewer, other setting have no effect.
    previewRowInfo.Font.Bold = true;
    previewRowInfo.Font.Italic = true;
    previewRowInfo.Font.Overline = true;
    previewRowInfo.Font.Size = 20;
    previewRowInfo.Font.Underline = true;
    previewRowInfo.Font.Strikeout = true;
    previewRowInfo.Font.Name = "Verdana";   // Try with some other name of font.
    ListBox1.Items.Add(previewRowInfo.IsEmpty.ToString());
    ListBox1.Items.Add(previewRowInfo.CanSerializeXml.ToString());
    
    // Use the preview row.
    FpSpread1.ActiveSheetView.PreviewRowColumnIndex = 0;
    FpSpread1.ActiveSheetView.PreviewRowStyle = previewRowInfo;
    FpSpread1.ActiveSheetView.PreviewRowVisible = true;
    
    ' Add this style definition inside the STYLE element in the Default.aspx page.
    .previewer  
     {  
           border-style:dashed;
         border-color:Green;
         border-width:thick;
         font-family:Arial;
         font-style:italic;
         color:Blue;
         background-color:Yellow;
         text-align:right;
         text-decoration:'underline'|'overline'|'line-through'|'blink';
         vertical-align:bottom;
     } 
    
    
    ' Define the background.
    Dim bg As New FarPoint.Web.Spread.Background()
    bg.SelectedBackgroundImageUrl = "picture/Winter.jpg"
    bg.BackgroundImageUrl = "picture/Image.bmp"
    Dim bd1 As New FarPoint.Web.Spread.Border()
    bd1.BorderColor = System.Drawing.Color.Blue
    bd1.BorderStyle = System.Web.UI.WebControls.BorderStyle.Dashed
    
    ' Set the preview row properties.
    Dim previewRowInfo As New FarPoint.Web.Spread.PreviewRowInfo()
    previewRowInfo.BackColor = Color.Blue
    previewRowInfo.Background = bg
    previewRowInfo.Border = bd1
    previewRowInfo.HorizontalAlign = System.Web.UI.WebControls.HorizontalAlign.Center
    previewRowInfo.VerticalAlign = System.Web.UI.WebControls.VerticalAlign.Middle
    previewRowInfo.TabStop = True
    previewRowInfo.Margin.Bottom = 10
    previewRowInfo.Margin.Left = 10
    previewRowInfo.Margin.Right = 10
    previewRowInfo.Margin.Top = 10
    previewRowInfo.ForeColor = System.Drawing.Color.Green
    previewRowInfo.CssClass = "previewer"  ' If set to previewer, other setting have no effect.
    previewRowInfo.Font.Bold = True
    previewRowInfo.Font.Italic = True
    previewRowInfo.Font.Overline = True
    previewRowInfo.Font.Size = 20
    previewRowInfo.Font.Underline = True
    previewRowInfo.Font.Strikeout = True
    previewRowInfo.Font.Name = "Verdana"  ' Try with some other name of font.
    ListBox1.Items.Add(previewRowInfo.IsEmpty.ToString())
    ListBox1.Items.Add(previewRowInfo.CanSerializeXml.ToString())
    
    ' Use the preview row.
    FpSpread1.ActiveSheetView.PreviewRowColumnIndex = 0
    FpSpread1.ActiveSheetView.PreviewRowStyle = previewRowInfo
    FpSpread1.ActiveSheetView.PreviewRowVisible = True
    
    See Also