# SPREADSPARKLINE

Spread for WinForms provides advanced software components that support Excel import/export, full cell customization, an extensive calculation engine with over 450 functions and more, all with zero dependencies on Excel.

## Content



This function returns a data set used for representing a spread sparkline.

## Syntax

SPREADSPARKLINE(*points, [showAverage, scaleStart, scaleEnd, style, colorScheme, vertical*])

## Arguments

This function has these arguments:

| **Argument** | **Description** |
| -------- | ----------- |
| *points* | A reference that represents a range of cells that contains the values, such as "A1:A10". |
| *showAverage* | (Optional) A boolean that represents whether to show the average. The default value is false. |
| *scaleStart* | (Optional) A number that represents the minimum boundary of the sparkline. The default value is the minimum of all values. |
| *scaleEnd* | (Optional) A number that represents the maximum boundary of the sparkline. The default value is the maximum of all values. |
| *style* | (Optional) A number that references the style of the Spread sparkline. The default value is 4 (poles). |
| *colorScheme* | (Optional) A string that represents the color of the sparkline. The default value is "#646464". |
| *vertical* | (Optional) A boolean that represents whether to display the sparkline vertically. The default value is false. |

## Data Types

Returns sparkline.

## Example

```csharp
activeSheet.setFormula(2, 2, '=SPREADSPARKLINE(B3:B20,TRUE,,,4,"green")');
```