SpreadJS 13
GC.Spread.Sheets Namespace / Worksheet type / ungroupSparkline Method
The sparkline group.
In This Topic
    ungroupSparkline Method
    In This Topic
    Ungroups the sparklines in the specified group.
    Syntax
    var instance = new GC.Spread.Sheets.Worksheet(name);
    var value; // Type: any
    value = instance.ungroupSparkline(group);
    function ungroupSparkline( 
       group : SparklineGroup
    ) : any;

    Parameters

    group
    The sparkline group.
    Example
    This example uses the ungroupSparkline method.
    activeSheet.setValue(0, 0, "Data Range is A2-A9");
    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);
    
    var data = new GC.Spread.Sheets.Range(1, 0, 8, 1);
    var setting = new GC.Spread.Sheets.Sparklines.SparklineSetting();
    var s1=  activeSheet.setSparkline(11, 0, data, GC.Spread.Sheets.Sparklines.DataOrientation.Vertical, GC.Spread.Sheets.Sparklines.SparklineType.line, setting);
    var s2 =activeSheet.setSparkline(11, 3, data, GC.Spread.Sheets.Sparklines.DataOrientation.Vertical, GC.Spread.Sheets.Sparklines.SparklineType.column, setting);
    var s3=  activeSheet.setSparkline(11, 6, data, GC.Spread.Sheets.Sparklines.DataOrientation.Vertical, GC.Spread.Sheets.Sparklines.SparklineType.winloss, setting);
    var group = activeSheet.groupSparkline([s1,s2,s3]);
    //activeSheet.ungroupSparkline(group);
    See Also

    Reference

    Worksheet type