SpreadJS Documentation
DataOrientation Enumeration
Represents the orientation of the range.
Members
MemberDescription
HorizontalSpecifies the horizontal orientation.
VerticalSpecifies the vertical orientation.
Example
This example uses the DataOrientation 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.DataOrientation

See Also

Reference

GcSpread.Sheets Namespace

 

 


Copyright © GrapeCity, inc. All rights reserved.

Send comments on this topic.