SpreadJS 13
GC.Spread.Sheets.Sparklines Namespace / EmptyValueStyle Enumeration
In This Topic
    EmptyValueStyle Enumeration
    In This Topic
    Specifies how to show an empty value from a data series in the chart.
    Members
    MemberDescription
    connectFills gaps with a connecting element instead of leaving gaps for empty values in a data series.
    gapsLeaves gaps for empty values in a data series, which results in a segmented line.
    zeroHandles 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.
    var data = new GC.Spread.Sheets.Range(1, 0, 8, 1);
    var setting = new GC.Spread.Sheets.Sparklines.SparklineSetting
    setting.options.showMarkers = true;
    setting.options.lineWeight = 3;
    setting.options.displayXAxis = true;
    setting.options.showFirst = true;
    setting.options.showLast = true;
    setting.options.showLow = true;
    setting.options.showHigh = true;
    setting.options.showNegative = true;
    setting.options.seriesColor = "Text 2 1";
    setting.options.firstMarkerColor = "Text 2 3";
    setting.options.negativeColor = "Accent 2 1";
    setting.options.markersColor = "Accent 3 1";
    setting.options.lowMarkerColor = "Accent 4 1";
    setting.options.highMarkerColor = "Accent 6 1";
    setting.options.lastMarkerColor = "Accent 6 6";
    setting.options.axisColor = "Text 1 1";
    
    setting.options.displayEmptyCellsAs =  GC.Spread.Sheets.Sparklines.EmptyValueStyle.Zero;
    activeSheet.addSpan(13, 0, 4, 3, null);
    activeSheet.setSparkline(13, 0, data, GC.Spread.Sheets.Sparklines.DataOrientation.vertical, GC.Spread.Sheets.Sparklines.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
       GC.Spread.Sheets.Sparklines.EmptyValueStyle

    See Also