Class: PivotTableStyle

Spread.Pivot.PivotTableStyle

Table of contents

Constructors

• constructor

Properties

• backColor
• borderBottom
• borderHorizontal
• borderLeft
• borderRight
• borderTop
• borderVertical
• font
• fontFamily
• fontSize
• fontStyle
• fontWeight
• foreColor
• textDecoration

Constructors

constructor

• new PivotTableStyle(backColor?, foreColor?, font?, borderLeft?, borderTop?, borderRight?, borderBottom?, borderHorizontal?, borderVertical?, textDecoration?, fontStyle?, fontWeight?, fontSize?, fontFamily?)

Represents a PivotTable Style.

Parameters

Name	Type
backColor?	string
foreColor?	string
font?	string
borderLeft?	LineBorder
borderTop?	LineBorder
borderRight?	LineBorder
borderBottom?	LineBorder
borderHorizontal?	LineBorder
borderVertical?	LineBorder
textDecoration?	TextDecorationType
fontStyle?	string
fontWeight?	string
fontSize?	string
fontFamily?	string

Properties

backColor

• backColor: string

Indicates the background color.

---

borderBottom

• borderBottom: LineBorder

Indicates the bottom border.

---

borderHorizontal

• borderHorizontal: LineBorder

Indicates the horizontal border.

---

borderLeft

• borderLeft: LineBorder

Indicates the left border.

---

borderRight

• borderRight: LineBorder

Indicates the right border.

---

borderTop

• borderTop: LineBorder

Indicates the top border.

---

borderVertical

• borderVertical: LineBorder

Indicates the vertical border.

---

font

• font: string

Indicates the font.

---

fontFamily

• fontFamily: string

Indicates the font family.

example

//This example sets the fontFamily property.
var spread = new GC.Spread.Sheets.Workbook(document.getElementById("ss"),{sheetCount:3});
var sourceSheet = spread.getSheet(0);
var sheet = spread.getSheet(1);
var sourceData = [["Date","Buyer","Type","Amount"],
                  ["01-Jan","Mom","Fuel",74],
                  ["15-Jan","Mom","Food",235],
                  ["17-Jan","Dad","Sports",20],
                  ["21-Jan","Kelly","Books",125]];
sourceSheet.setArray(0, 0, sourceData );
sourceSheet.tables.add('sourceData', 0, 0, 5, 4);
var layout = GC.Spread.Pivot.PivotTableLayoutType.compact;
var theme = GC.Spread.Pivot.PivotTableThemes.medium2;
var wholePivotTableStyle = new GC.Spread.Pivot.PivotTableStyle();
wholePivotTableStyle.fontFamily = "Arial Black";
theme.wholeTableStyle(wholePivotTableStyle);
var pivotTable = sheet.pivotTables.add("pivotTable_1", 'sourceData', 1, 1, layout, theme);

---

fontSize

• fontSize: string

Indicates the font size.

example

//This example sets the fontSize property.
var spread = new GC.Spread.Sheets.Workbook(document.getElementById("ss"),{sheetCount:3});
var sourceSheet = spread.getSheet(0);
var sheet = spread.getSheet(1);
var sourceData = [["Date","Buyer","Type","Amount"],
                  ["01-Jan","Mom","Fuel",74],
                  ["15-Jan","Mom","Food",235],
                  ["17-Jan","Dad","Sports",20],
                  ["21-Jan","Kelly","Books",125]];
sourceSheet.setArray(0, 0, sourceData );
sourceSheet.tables.add('sourceData', 0, 0, 5, 4);
var layout = GC.Spread.Pivot.PivotTableLayoutType.compact;
var theme = GC.Spread.Pivot.PivotTableThemes.medium2;
var wholePivotTableStyle = new GC.Spread.Pivot.PivotTableStyle();
wholePivotTableStyle.fontSize = "16px";
theme.wholeTableStyle(wholePivotTableStyle);
var pivotTable = sheet.pivotTables.add("pivotTable_1", 'sourceData', 1, 1, layout, theme);

---

fontStyle

• fontStyle: string

Indicates the font style.

example

//This example sets the fontStyle property.
var spread = new GC.Spread.Sheets.Workbook(document.getElementById("ss"),{sheetCount:3});
var sourceSheet = spread.getSheet(0);
var sheet = spread.getSheet(1);
var sourceData = [["Date","Buyer","Type","Amount"],
                  ["01-Jan","Mom","Fuel",74],
                  ["15-Jan","Mom","Food",235],
                  ["17-Jan","Dad","Sports",20],
                  ["21-Jan","Kelly","Books",125]];
sourceSheet.setArray(0, 0, sourceData );
sourceSheet.tables.add('sourceData', 0, 0, 5, 4);
var layout = GC.Spread.Pivot.PivotTableLayoutType.compact;
var theme = GC.Spread.Pivot.PivotTableThemes.medium2;
var wholePivotTableStyle = new GC.Spread.Pivot.PivotTableStyle();
wholePivotTableStyle.fontStyle = "italic";
theme.wholeTableStyle(wholePivotTableStyle);
var pivotTable = sheet.pivotTables.add("pivotTable_1", 'sourceData', 1, 1, layout, theme);

---

fontWeight

• fontWeight: string

Indicates the font weight.

example

//This example sets the fontWeight property.
var spread = new GC.Spread.Sheets.Workbook(document.getElementById("ss"),{sheetCount:3});
var sourceSheet = spread.getSheet(0);
var sheet = spread.getSheet(1);
var sourceData = [["Date","Buyer","Type","Amount"],
                  ["01-Jan","Mom","Fuel",74],
                  ["15-Jan","Mom","Food",235],
                  ["17-Jan","Dad","Sports",20],
                  ["21-Jan","Kelly","Books",125]];
sourceSheet.setArray(0, 0, sourceData );
sourceSheet.tables.add('sourceData', 0, 0, 5, 4);
var layout = GC.Spread.Pivot.PivotTableLayoutType.compact;
var theme = GC.Spread.Pivot.PivotTableThemes.medium2;
var wholePivotTableStyle = new GC.Spread.Pivot.PivotTableStyle();
wholePivotTableStyle.fontWeight = "bold";
theme.wholeTableStyle(wholePivotTableStyle);
var pivotTable = sheet.pivotTables.add("pivotTable_1", 'sourceData', 1, 1, layout, theme);

---

foreColor

• foreColor: string

Indicates the fore color.

---

textDecoration

• textDecoration: TextDecorationType

Indicates the text decoration.