Spread WinRT Documentation
GrapeCity.Xaml.SpreadSheet.Data Namespace / Axis Class / LabelFormatter Property
Example


In This Topic
    LabelFormatter Property
    In This Topic
    Gets or sets the label formatter.
    Syntax
    'Declaration
     
    Public Property LabelFormatter As IFormatter
    'Usage
     
    Dim instance As Axis
    Dim value As IFormatter
     
    instance.LabelFormatter = value
     
    value = instance.LabelFormatter
    public IFormatter LabelFormatter {get; set;}
    Example
    This example sets the LabelFormatter property.
    GrapeCity.Xaml.SpreadSheet.Data.SpreadChart chart = new GrapeCity.Xaml.SpreadSheet.Data.SpreadChart("Chart", GrapeCity.Xaml.SpreadSheet.Data.SpreadChartType.BarStacked, "Sheet1!$A$1:$A$7", 0, 0, 200, 200);
    gcSpreadSheet1.ActiveSheet.SetArray(0, 0, new object[,] { { 1 }, { 2 }, { 3 }, { 4 }, { 5 }, { 6 }, { 7 }, { 8 }, { 9 }, { 10 } });
    
    chart.ChartTitle = new GrapeCity.Xaml.SpreadSheet.Data.ChartTitle();
    chart.AxisX.Text = "-1234";
    //stroke
    chart.AxisX.StrokeDashType = GrapeCity.Xaml.SpreadSheet.Data.StrokeDashType.DashDot;
    chart.AxisX.StrokeThickness = 2;
    chart.AxisX.Stroke = new SolidColorBrush(Windows.UI.Colors.Cyan);
    //fill
    chart.AxisX.Fill = new SolidColorBrush(Windows.UI.Colors.Red);
    //font
    chart.AxisX.FontSize = 12;
    chart.AxisX.FontFamily = FontFamily;
    chart.AxisX.FontStyle = Windows.UI.Text.FontStyle.Italic;
    chart.AxisX.FontWeight = Windows.UI.Text.FontWeights.Bold;
    chart.AxisX.FontStretch = Windows.UI.Text.FontStretch.ExtraExpanded;
    chart.AxisX.Foreground = new SolidColorBrush(Windows.UI.Colors.Blue);
    chart.AxisX.LineCapType = PenLineCap.Round;
    chart.AxisX.LineJoinType = PenLineJoin.Bevel;
    chart.AxisX.LabelAngle = 60;
    chart.AxisX.LabelFormatter = new GrapeCity.Xaml.SpreadSheet.Data.GeneralFormatter("##.00");
    chart.AxisX.Reversed = true;
    chart.AxisX.LogBase = 100;
    chart.AxisX.UseLogBase = true;
    gcSpreadSheet1.ActiveSheet.Charts.Add(chart);
    Dim chart As New GrapeCity.Xaml.SpreadSheet.Data.SpreadChart("Chart", GrapeCity.Xaml.SpreadSheet.Data.SpreadChartType.BarStacked, "Sheet1!$A$1:$A$7", 0, 0, 200, 200)
    GcSpreadSheet1.ActiveSheet.SetArray(0, 0, New Object(,) {{1}, {2}, {3}, {4}, {5}, {6}, {7}, {8}, {9}, {10}})
    
    chart.ChartTitle = New GrapeCity.Xaml.SpreadSheet.Data.ChartTitle()
    chart.AxisX.Text = "-1234"
    'stroke
    chart.AxisX.StrokeDashType = GrapeCity.Xaml.SpreadSheet.Data.StrokeDashType.DashDot
    chart.AxisX.StrokeThickness = 2
    chart.AxisX.Stroke = New SolidColorBrush(Windows.UI.Colors.Cyan)
    'fill
    chart.AxisX.Fill = New SolidColorBrush(Windows.UI.Colors.Red)
    'font
    chart.AxisX.FontSize = 12
    chart.AxisX.FontFamily = FontFamily
    chart.AxisX.FontStyle = Windows.UI.Text.FontStyle.Italic
    chart.AxisX.FontWeight = Windows.UI.Text.FontWeights.Bold
    chart.AxisX.FontStretch = Windows.UI.Text.FontStretch.ExtraExpanded
    chart.AxisX.Foreground = New SolidColorBrush(Windows.UI.Colors.Blue)
    chart.AxisX.LineCapType = PenLineCap.Round
    chart.AxisX.LineJoinType = PenLineJoin.Bevel
    chart.AxisX.LabelAngle = 60
    chart.AxisX.LabelFormatter = New GrapeCity.Xaml.SpreadSheet.Data.GeneralFormatter("##.00")
    chart.AxisX.Reversed = True
    chart.AxisX.LogBase = 100
    chart.AxisX.UseLogBase = True
    GcSpreadSheet1.ActiveSheet.Charts.Add(chart)
    See Also