SpreadJS Documentation
SparklineType Enumeration
Represents the sparkline type.
Members
MemberDescription
columnSpecifies the column sparkline.
lineSpecifies the line sparkline.
winlossSpecifies the win-loss sparkline.
Example
This example uses the SparklineType enumeration.
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 GcSpread.Sheets.Range(1, 0, 8, 1);
var setting = new GcSpread.Sheets.SparklineSetting();
var s1=  activeSheet.setSparkline(11, 0, data, GcSpread.Sheets.DataOrientation.Vertical, GcSpread.Sheets.SparklineType.line, setting);
var s2 =activeSheet.setSparkline(11, 3, data, GcSpread.Sheets.DataOrientation.Vertical, GcSpread.Sheets.SparklineType.column, setting);
var s3=  activeSheet.setSparkline(11, 6, data, GcSpread.Sheets.DataOrientation.Vertical, GcSpread.Sheets.SparklineType.winloss, setting);
var group = activeSheet.groupSparkline([s1,s2,s3]);
//activeSheet.ungroupSparkline(group);
Inheritance Hierarchy

Object
   GcSpread.Sheets.SparklineType

See Also

Reference

GcSpread.Sheets Namespace
Understanding Sparklines

 

 


Copyright © GrapeCity, inc. All rights reserved.

Send comments on this topic.