InvertIfNegative Property (SpreadDataSeries)

Gets or sets a value that indicates whether to display an alternative color if the value is negative.

Syntax

Visual Basic
C#

'Declaration
 
Public Property InvertIfNegative As System.Boolean

'Usage
 
Dim instance As SpreadDataSeries
Dim value As System.Boolean
 
instance.InvertIfNegative = value
 
value = instance.InvertIfNegative

public System.bool InvertIfNegative {get; set;}

Property Value

true to display an alternative color if the value is negative; otherwise, false.

Example

This example sets the InvertIfNegative property.

GrapeCity.Windows.SpreadSheet.Data.SpreadChart chart = new GrapeCity.Windows.SpreadSheet.Data.SpreadChart("Chart", GrapeCity.Windows.SpreadSheet.Data.SpreadChartType.ColumnStacked, 0, 0, 200, 200);
GrapeCity.Windows.SpreadSheet.Data.SpreadDataSeries ds = new GrapeCity.Windows.SpreadSheet.Data.SpreadDataSeries();
ds.Values.Add(4);
ds.Values.Add(-7);
ds.Values.Add(-6);
ds.Values.Add(10);
ds.Values.Add(4);
ds.Fill = new SolidColorBrush(Colors.Green);
ds.Stroke = new SolidColorBrush(Colors.Blue);
ds.StrokeDashType = GrapeCity.Windows.SpreadSheet.Data.StrokeDashType.Dash;
ds.StrokeThickness = 2;
ds.InvertIfNegative = true;
ds.NegativeFill = new SolidColorBrush(Colors.Red);
chart.DataSeries.Add(ds);
gcSpreadSheet1.ActiveSheet.Charts.Add(chart);

VB.NET

Dim chart As New GrapeCity.Windows.SpreadSheet.Data.SpreadChart("Chart", GrapeCity.Windows.SpreadSheet.Data.SpreadChartType.ColumnStacked, 0, 0, 200, 200)
Dim ds As New GrapeCity.Windows.SpreadSheet.Data.SpreadDataSeries()
ds.Values.Add(4)
ds.Values.Add(-7)
ds.Values.Add(-6)
ds.Values.Add(10)
ds.Values.Add(4)

ds.Fill = New SolidColorBrush(Colors.Green)
ds.Stroke = New SolidColorBrush(Colors.Blue)
ds.StrokeDashType = GrapeCity.Windows.SpreadSheet.Data.StrokeDashType.Dash
ds.StrokeThickness = 2
ds.InvertIfNegative = True
ds.NegativeFill = New SolidColorBrush(Colors.Red)
chart.DataSeries.Add(ds)
GcSpreadSheet1.ActiveSheet.Charts.Add(chart)

Reference

SpreadDataSeries Class
SpreadDataSeries Members