GrapeCity.Documents.Excel.ICascadeSparkLine.Vertical

Vertical Property

Vertical

Returns whether the cascade sparkline's box direction is vertical or horizontal.

A value of true indicates that the boxes are displayed vertically, and false indicates that they are displayed horizontally. The default value is false.

Declaration

bool Vertical { get; }

ReadOnly Property Vertical As Boolean

Examples

worksheet.Range["A2:A4"].Value = new object[] {"Start", "Increase", "End"};
worksheet.Range["B2:B4"].Value = new object[] {100, 50, 150};
worksheet.Range["C2"].Formula = "=CASCADESPARKLINE(B2:B4,1,A2:A4,,,\"#8CBF64\",\"#D6604D\",TRUE)";
ICascadeSparkLine sparkLine = (ICascadeSparkLine) worksheet.Range["C2"].Value;
bool vertical = sparkLine.Vertical;