EmptyValueStyle Enumeration

Specifies how to show an empty value from a data series in the chart.

Members

Member	Description
Connect	Fills gaps with a connecting element instead of leaving gaps for empty values in a data series.
Gaps	Leaves gaps for empty values in a data series, which results in a segmented line.
Zero	Handles empty values in a data series as zero values, so that the line drops to zero for zero-value data points.

Example

This example uses the EmptyValueStyle enumeration.

Javascript

var data = new GcSpread.Sheets.Range(1, 0, 8, 1);
var setting = new GcSpread.Sheets.SparklineSetting();
setting.showMarkers(true);
setting.lineWeight = 3;
setting.displayXAxis = true;
setting.showFirst(true);
setting.showLast(true);
setting.showLow(true);
setting.showHigh(true);
setting.showNegative(true);
setting.seriesColor('Text 2 1');
setting.firstMarkerColor('Text 2 3');
setting.negativeColor('Accent 2 1');
setting.markersColor('Accent 3 1');
setting.lowMarkerColor('Accent 4 1');
setting.highMarkerColor('Accent 6 1');
setting.lastMarkerColor('Accent 6 6');
setting.axisColor('Text 1 1');
setting.displayEmptyCellsAs = GcSpread.Sheets.EmptyValueStyle.Zero;
activeSheet.addSpan(13, 0, 4, 3, null);
activeSheet.setSparkline(13, 0, data, GcSpread.Sheets.DataOrientation.Vertical, GcSpread.Sheets.SparklineType.line, setting);
activeSheet.setValue(1, 0, 1);
activeSheet.setValue(2, 0, -2);
activeSheet.setValue(3, 0, -1);
activeSheet.setValue(4, 0, 6);
activeSheet.setValue(5, 0, 4);
activeSheet.setValue(6, 0, -4);
activeSheet.setValue(7, 0, 3);
activeSheet.setValue(8, 0, 8);

Inheritance Hierarchy

Object
GcSpread.Sheets.EmptyValueStyle

Reference

GcSpread.Sheets Namespace