GrapeCity.Xaml.SpreadSheet.Data
FontStretch Property (SpreadChartTextElement)
Example 


Gets or sets the font stretch.
Syntax
'Declaration
 
Public Property FontStretch As FontStretch
'Usage
 
Dim instance As SpreadChartTextElement
Dim value As FontStretch
 
instance.FontStretch = value
 
value = instance.FontStretch
public FontStretch FontStretch {get; set;}

Property Value

The font stretch.
Example
This example sets the FontStretch property.
private double strokeThickness;
private Brush stroke;
private Brush fillBrush;
private double axisFontSize;
private double chartFontSize;
private FontFamily fontFamily;        
private Brush foreground;

strokeThickness = 2;
stroke = new SolidColorBrush(Windows.UI.Colors.Green);
fillBrush = new SolidColorBrush(Windows.UI.Colors.Red);
foreground = new SolidColorBrush(Windows.UI.Colors.Blue);
chartFontSize = 25;
axisFontSize = 25;
fontFamily = new FontFamily("Arial Narrow");
Windows.UI.Text.FontStyle fontStyle = Windows.UI.Text.FontStyle.Italic;
Windows.UI.Text.FontWeight fontWeight = Windows.UI.Text.FontWeights.Bold;
Windows.UI.Text.FontStretch fontStretch = Windows.UI.Text.FontStretch.ExtraExpanded;

GrapeCity.Xaml.SpreadSheet.Data.SpreadDataSeries aseries = new GrapeCity.Xaml.SpreadSheet.Data.SpreadDataSeries();
aseries.Name = "1234";
aseries.Values.Add(2);
aseries.Values.Add(4);
aseries.Values.Add(3);
aseries.Values.Add(5);
aseries.Fill = new SolidColorBrush(Windows.UI.Colors.Red);
aseries.ChartType = GrapeCity.Xaml.SpreadSheet.Data.SpreadChartType.ColumnStacked;
aseries.DataLabelSettings = new GrapeCity.Xaml.SpreadSheet.Data.DataLabelSettings() { ShowValue = true, ShowBubbleSize = true };
aseries.DataLabelStyle.Fill = new SolidColorBrush(Windows.UI.Colors.Green);
GrapeCity.Xaml.SpreadSheet.Data.SpreadChart chart = new GrapeCity.Xaml.SpreadSheet.Data.SpreadChart();
chart.DataSeries.Add(aseries);
chart.Name = "name1";
chart.ChartTitle = new GrapeCity.Xaml.SpreadSheet.Data.ChartTitle();
chart.ChartTitle.Text = "-1234";
//stroke
chart.ChartTitle.StrokeDashType = GrapeCity.Xaml.SpreadSheet.Data.StrokeDashType.Dash;
chart.ChartTitle.StrokeThickness = strokeThickness;
chart.ChartTitle.Stroke = stroke;
//fill
chart.ChartTitle.Fill = fillBrush;
//font
chart.ChartTitle.FontSize = chartFontSize;
chart.ChartTitle.FontFamily = FontFamily;
chart.ChartTitle.FontStyle = fontStyle;
chart.ChartTitle.FontWeight = fontWeight;
chart.ChartTitle.FontStretch = fontStretch;
chart.ChartTitle.Foreground = foreground;

gcSpreadSheet1.ActiveSheet.Charts.Add(chart);

Private strokeThickness As Double
Private stroke As Brush
Private fillBrush As Brush
Private chartFontSize As Double
Private axisFontSize As Double
Private fontFamily As FontFamily
Private foreground As Brush

' Add to Form load event
strokeThickness = 2
stroke = New SolidColorBrush(Windows.UI.Colors.Green)
fillBrush = New SolidColorBrush(Windows.UI.Colors.Red)
foreground = New SolidColorBrush(Windows.UI.Colors.Blue)
chartFontSize = 25
axisFontSize = 25
fontFamily = New FontFamily("Arial Narrow")
fontStyle = Windows.UI.Text.FontStyle.Italic
fontWeight = Windows.UI.Text.FontWeights.Bold
fontStretch = Windows.UI.Text.FontStretch.ExtraExpanded

Dim aseries As New GrapeCity.Xaml.SpreadSheet.Data.SpreadDataSeries()
aseries.Name = "1234"
aseries.Values.Add(2)
aseries.Values.Add(4)
aseries.Values.Add(3)
aseries.Values.Add(5)
aseries.Fill = New SolidColorBrush(Windows.UI.Colors.Red)
aseries.ChartType = GrapeCity.Xaml.SpreadSheet.Data.SpreadChartType.ColumnStacked
aseries.DataLabelSettings = New GrapeCity.Xaml.SpreadSheet.Data.DataLabelSettings() With {.ShowValue = True, .ShowBubbleSize = True}
aseries.DataLabelStyle.Fill = New SolidColorBrush(Windows.UI.Colors.Green)
Dim chart As New GrapeCity.Xaml.SpreadSheet.Data.SpreadChart()
chart.DataSeries.Add(aseries)
chart.Name = "name1"
chart.ChartTitle = New GrapeCity.Xaml.SpreadSheet.Data.ChartTitle()
chart.ChartTitle.Text = "-1234"
'stroke
chart.ChartTitle.StrokeDashType = GrapeCity.Xaml.SpreadSheet.Data.StrokeDashType.Dash
chart.ChartTitle.StrokeThickness = strokeThickness
chart.ChartTitle.Stroke = stroke
'fill
chart.ChartTitle.Fill = fillBrush
'font
chart.ChartTitle.FontSize = chartFontSize
chart.ChartTitle.FontFamily = fontFamily
chart.ChartTitle.FontStyle = fontStyle
chart.ChartTitle.FontWeight = fontWeight
chart.ChartTitle.FontStretch = fontStretch
chart.ChartTitle.Foreground = foreground

GcSpreadSheet1.ActiveSheet.Charts.Add(chart)
Requirements

Target Platforms: Windows Server 2012, Windows RT

See Also

Reference

SpreadChartTextElement Class
SpreadChartTextElement Members

 

 


Copyright © GrapeCity, inc. All rights reserved.

Support Options