Spread WPF Documentation
InvertIfNegative Property (SpreadDataSeries)
Example 


GrapeCity.Windows.SpreadSheet.Data Namespace > SpreadDataSeries Class : InvertIfNegative Property
Gets or sets a value that indicates whether to display an alternative color if the value is negative.
Syntax
'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);
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)
See Also

Reference

SpreadDataSeries Class
SpreadDataSeries Members