[]
• new Style(backColor?, foreColor?, hAlign?, vAlign?, font?, themeFont?, formatter?, borderLeft?, borderTop?, borderRight?, borderBottom?, locked?, textIndent?, wordWrap?, showEllipsis?, shrinkToFit?, backgroundImage?, cellType?, backgroundImageLayout?, tabStop?, textDecoration?, imeMode?, name?, parentName?, watermark?, cellPadding?, labelOptions?, quotePrefix?, diagonalDown?, diagonalUp?, isVerticalText?, cellButtons?, dropdown?, textOrientation?, decoration?, mask?, fontStyle?, fontWeight?, fontSize?, fontFamily?, hidden?, textDirection?)
表示单元格、行和列的样式。
example
//此示例使用带规则的样式。
activeSheet.setArray(0,0,[1,2,3,4,5,6,7,8,9,10]);
var style = new GC.Spread.Sheets.Style();
style.backColor = "red";
style.foreColor = "black";
var cell = new GC.Spread.Sheets.ConditionalFormatting.NormalConditionRule();
cell.ruleType(GC.Spread.Sheets.ConditionalFormatting.RuleType.cellValueRule);
cell.operator(GC.Spread.Sheets.ConditionalFormatting.ComparisonOperators.greaterThan);
cell.value1(5);
cell.ranges([new GC.Spread.Sheets.Range(0, 0, 10, 1)]);
cell.style(style);
activeSheet.conditionalFormats.addRule(cell);
var style1 = new GC.Spread.Sheets.Style();
style1.foreColor = "red";
var top = new GC.Spread.Sheets.ConditionalFormatting.NormalConditionRule();
top.ruleType(GC.Spread.Sheets.ConditionalFormatting.RuleType.top10Rule);
top.type(GC.Spread.Sheets.ConditionalFormatting.Top10ConditionType.top);
top.rank(3);
top.style(style1);
top.ranges([new GC.Spread.Sheets.Range(0, 0, 10, 1)]);
top.stopIfTrue(true);
activeSheet.conditionalFormats.addRule(top);
example
//此示例创建并设置样式参数。
sheet.setValue(0,0, 1,3);
sheet.setValue(1,0, 50,3);
sheet.setValue(2,0, 100,3);
sheet.setValue(3,0, 2,3);
sheet.setValue(4,0, 60,3);
sheet.setValue(5,0, 90,3);
sheet.setValue(6,0, 3,3);
sheet.setValue(7,0, 40,3);
sheet.setValue(8,0, 70,3);
sheet.setValue(9,0, 5,3);
sheet.setValue(10,0, 35,3);
var style = new GC.Spread.Sheets.Style();
style.backColor = "red";
style.borderLeft =new GC.Spread.Sheets.LineBorder("blue",GC.Spread.Sheets.LineStyle.medium);
style.borderTop = new GC.Spread.Sheets.LineBorder("blue",GC.Spread.Sheets.LineStyle.medium);
style.borderRight = new GC.Spread.Sheets.LineBorder("blue",GC.Spread.Sheets.LineStyle.medium);
style.borderBottom = new GC.Spread.Sheets.LineBorder("blue",GC.Spread.Sheets.LineStyle.medium);
sheet.conditionalFormats.addAverageRule(GC.Spread.Sheets.ConditionalFormatting.AverageConditionType.above, style, [new GC.Spread.Sheets.Range(0, 0, 10, 3)]);
| Name | Type | Description |
|---|---|---|
backColor? |
string | IGradientFill | IGradientPathFill | IPatternFill |
背景颜色。 |
foreColor? |
string |
前景颜色。 |
hAlign? |
HorizontalAlign |
水平对齐方式。 |
vAlign? |
VerticalAlign |
垂直对齐方式。 |
font? |
string |
字体。 |
themeFont? |
string |
字体主题。 |
formatter? |
string | GeneralFormatter |
格式化对象。 |
borderLeft? |
LineBorder |
左边框。 |
borderTop? |
LineBorder |
上边框。 |
borderRight? |
LineBorder |
右边框。 |
borderBottom? |
LineBorder |
下边框。 |
locked? |
boolean |
单元格、行或列是否锁定。 |
textIndent? |
number |
文本缩进量。 |
wordWrap? |
boolean |
文本是否在单元格内自动换行。 |
showEllipsis? |
boolean |
- |
shrinkToFit? |
boolean |
内容是否自动缩小以适应单元格。 |
backgroundImage? |
string |
要显示的背景图片。 |
cellType? |
Base |
单元格类型。 |
backgroundImageLayout? |
ImageLayout |
背景图片的布局。 |
tabStop? |
boolean |
用户是否可以使用Tab键将焦点设置到单元格。 |
textDecoration? |
TextDecorationType |
指定添加到文本的装饰。 |
imeMode? |
ImeMode |
指定输入法编辑器模式。 |
name? |
string |
指定名称。 |
parentName? |
string |
指定父样式的名称。 |
watermark? |
string |
指定水印内容。 |
cellPadding? |
string |
指定单元格内边距。 |
labelOptions? |
ILabelOptions |
指定单元格标签选项。 |
quotePrefix? |
boolean |
- |
diagonalDown? |
LineBorder |
从左上到右下的对角线。 |
diagonalUp? |
LineBorder |
从右上到左下的对角线。 |
isVerticalText? |
boolean |
是否设置单元格文本垂直显示。 |
cellButtons? |
ICellButton[] |
- |
dropdown? |
IDropdown[] |
- |
textOrientation? |
number |
单元格文本旋转角度。 |
decoration? |
TextDecorationType |
- |
mask? |
IMaskType |
输入掩码的掩码对象。 |
fontStyle? |
string |
指定字体样式。 |
fontWeight? |
string |
指定字体粗细。 |
fontSize? |
string |
指定字体大小。 |
fontFamily? |
string |
指定字体系列。 |
hidden? |
boolean |
- |
textDirection? |
TextDirectionType |
指定文本方向。 |
• allowEditInCell: undefined | boolean
指示单元格是否可以进入编辑模式进行编辑。
example
//此示例设置allowEditInCell属性。
var style = activeSheet.getStyle(1,1,GC.Spread.Sheets.SheetArea.viewport);
style.allowEditInCell = false;
• applyAlignment: boolean
仅适用于命名样式,布尔值指示是否应用对齐格式。
example
//此示例为命名样式设置applyAlignment属性。
var style = new GC.Spread.Sheets.Style();
style.name = 'test';
style.applyAlignment = false;
spread.addNamedStyle(style);
• applyBorder: boolean
仅适用于命名样式,布尔值指示是否应用边框格式。
example
//此示例为命名样式设置applyBorder属性。
var style = new GC.Spread.Sheets.Style();
style.name = 'test';
style.applyBorder = false;
spread.addNamedStyle(style);
• applyFill: boolean
仅适用于命名样式,布尔值指示是否应用填充格式。
example
//此示例为命名样式设置applyFill属性。
var style = new GC.Spread.Sheets.Style();
style.name = 'test';
style.applyFill = false;
spread.addNamedStyle(style);
• applyFont: boolean
仅适用于命名样式,布尔值指示是否应用字体格式。
example
//此示例为命名样式设置applyFont属性。
var style = new GC.Spread.Sheets.Style();
style.name = 'test';
style.applyFont = false;
spread.addNamedStyle(style);
• applyNumberFormat: boolean
仅适用于命名样式,布尔值指示是否应用数字格式。
example
//此示例为命名样式设置applyNumberFormat属性。
var style = new GC.Spread.Sheets.Style();
style.name = 'test';
style.applyNumberFormat = false;
spread.addNamedStyle(style);
• applyProtection: boolean
仅适用于命名样式,布尔值指示是否应用保护格式。
example
//此示例为命名样式设置applyProtection属性。
var style = new GC.Spread.Sheets.Style();
style.name = 'test';
style.applyProtection = false;
spread.addNamedStyle(style);
• backColor: undefined | string | IGradientFill | IGradientPathFill | IPatternFill
指示背景颜色。
example
//此示例设置样式backColor属性。
activeSheet.setArray(0,0,[1,2,3,4,5,6,7,8,9,10]);
var style = new GC.Spread.Sheets.Style();
style.backColor = "red";
style.foreColor = "black";
var cell = new GC.Spread.Sheets.ConditionalFormatting.NormalConditionRule();
cell.ruleType(GC.Spread.Sheets.ConditionalFormatting.RuleType.cellValueRule);
cell.operator(GC.Spread.Sheets.ConditionalFormatting.ComparisonOperators.greaterThan);
cell.value1(5);
cell.ranges([new GC.Spread.Sheets.Range(0, 0, 10, 1)]);
cell.style(style);
activeSheet.conditionalFormats.addRule(cell);
var style1 = new GC.Spread.Sheets.Style();
style1.foreColor = "red";
var top = new GC.Spread.Sheets.ConditionalFormatting.NormalConditionRule();
top.ruleType(GC.Spread.Sheets.ConditionalFormatting.RuleType.top10Rule);
top.type(GC.Spread.Sheets.ConditionalFormatting.Top10ConditionType.top);
top.rank(3);
top.style(style1);
top.ranges([new GC.Spread.Sheets.Range(0, 0, 10, 1)]);
top.stopIfTrue(true);
activeSheet.conditionalFormats.addRule(top);
• backgroundImage: undefined | string
指示背景图片。
example
//此示例设置backgroundImage属性。
var style = new GC.Spread.Sheets.Style();
style.backColor = "lightgreen";
style.backgroundImage = "./css/images/quarter1.png";
activeSheet.setStyle(1,1,style,GC.Spread.Sheets.SheetArea.viewport);
• backgroundImageLayout: undefined | ImageLayout
指示背景图片布局。
example
//此示例设置backgroundImageLayout属性。
var style = new GC.Spread.Sheets.Style();
style.backColor = "lightgreen";
style.backgroundImage = "./css/images/quarter1.png";
style.backgroundImageLayout = GC.Spread.Sheets.ImageLayout.center;
activeSheet.setStyle(1,1,style,GC.Spread.Sheets.SheetArea.viewport);
• borderBottom: undefined | LineBorder
指示底部边框线。
example
//此示例创建边框。
var cellType = new GC.Spread.Sheets.CellTypes.Button();
cellType.buttonBackColor("#FFFF00");
cellType.text("this is a button");
var style = new GC.Spread.Sheets.Style();
style.backColor = "red";
style.borderLeft =new GC.Spread.Sheets.LineBorder("blue",GC.Spread.Sheets.LineStyle.medium);
style.borderTop = new GC.Spread.Sheets.LineBorder("blue",GC.Spread.Sheets.LineStyle.medium);
style.borderRight = new GC.Spread.Sheets.LineBorder("blue",GC.Spread.Sheets.LineStyle.medium);
style.borderBottom = new GC.Spread.Sheets.LineBorder("blue",GC.Spread.Sheets.LineStyle.medium);
style.cellType = cellType
activeSheet.setStyle(1,1,style,GC.Spread.Sheets.SheetArea.viewport);
• borderLeft: undefined | LineBorder
指示左侧边框线。
example
//此示例创建边框。
var cellType = new GC.Spread.Sheets.CellTypes.Button();
cellType.buttonBackColor("#FFFF00");
cellType.text("this is a button");
var style = new GC.Spread.Sheets.Style();
style.backColor = "red";
style.borderLeft =new GC.Spread.Sheets.LineBorder("blue",GC.Spread.Sheets.LineStyle.medium);
style.borderTop = new GC.Spread.Sheets.LineBorder("blue",GC.Spread.Sheets.LineStyle.medium);
style.borderRight = new GC.Spread.Sheets.LineBorder("blue",GC.Spread.Sheets.LineStyle.medium);
style.borderBottom = new GC.Spread.Sheets.LineBorder("blue",GC.Spread.Sheets.LineStyle.medium);
style.cellType = cellType
activeSheet.setStyle(1,1,style,GC.Spread.Sheets.SheetArea.viewport);
• borderRight: undefined | LineBorder
指示右侧边框线。
example
//此示例创建边框。
var cellType = new GC.Spread.Sheets.CellTypes.Button();
cellType.buttonBackColor("#FFFF00");
cellType.text("this is a button");
var style = new GC.Spread.Sheets.Style();
style.backColor = "red";
style.borderLeft =new GC.Spread.Sheets.LineBorder("blue",GC.Spread.Sheets.LineStyle.medium);
style.borderTop = new GC.Spread.Sheets.LineBorder("blue",GC.Spread.Sheets.LineStyle.medium);
style.borderRight = new GC.Spread.Sheets.LineBorder("blue",GC.Spread.Sheets.LineStyle.medium);
style.borderBottom = new GC.Spread.Sheets.LineBorder("blue",GC.Spread.Sheets.LineStyle.medium);
style.cellType = cellType
activeSheet.setStyle(1,1,style,GC.Spread.Sheets.SheetArea.viewport);
• borderTop: undefined | LineBorder
指示顶部边框线。
example
//此示例创建边框。
var cellType = new GC.Spread.Sheets.CellTypes.Button();
cellType.buttonBackColor("#FFFF00");
cellType.text("this is a button");
var style = new GC.Spread.Sheets.Style();
style.backColor = "red";
style.borderLeft =new GC.Spread.Sheets.LineBorder("blue",GC.Spread.Sheets.LineStyle.medium);
style.borderTop = new GC.Spread.Sheets.LineBorder("blue",GC.Spread.Sheets.LineStyle.medium);
style.borderRight = new GC.Spread.Sheets.LineBorder("blue",GC.Spread.Sheets.LineStyle.medium);
style.borderBottom = new GC.Spread.Sheets.LineBorder("blue",GC.Spread.Sheets.LineStyle.medium);
style.cellType = cellType
activeSheet.setStyle(1,1,style,GC.Spread.Sheets.SheetArea.viewport);
• cellButtons: undefined | ICellButton[]
指示单元格的按钮。
property [caption] - 指定按钮显示的文本
property [captionAlign] - 指定图像和标题的位置
property [position] - 指定按钮在单元格中的位置
property [enabled] - 指定单元格按钮是否响应用户操作,默认值为true
property [useButtonStyle] - 指定单元格按钮是否为按钮样式,默认值为false
property [width] - 指定按钮的宽度。如果设置为null或undefined,按钮宽度将根据标题和图像大小自动调整
property [visibility] - 指定按钮的可见性:始终可见、选中时可见、编辑时可见,默认值为始终可见
property {string | function} [command] - 点击按钮时,允许用户执行spread命令或执行回调函数
property [imageType] - 指定按钮的类型(按钮中显示的图像类型)。为cellButton提供一些预定义类型,custom允许指定图标
property [imageSrc] - 当imageType为custom时,可以通过imageSrc指定图像(base64)
property [imageSize] - 指定图像的大小,默认值为16px
property [hoverBackColor] - 指定按钮可见且启用时单元格按钮的悬停背景色
property [buttonBackColor] - 指定按钮启用时单元格按钮的背景色
example
buttonConfig1 = {
caption: "left",
enabled: true,
buttonBackColor: "#174EA6",
visibility:GC.Spread.Sheets.ButtonVisibility.always,
};
buttonConfig2 = {
caption: "left",
enabled: true,
hoverBackColor: "#3390FF",
visibility:GC.Spread.Sheets.ButtonVisibility.onSelected,
};
buttonConfig3 = {
caption: "Cut",
imageType: GC.Spread.Sheets.ButtonImageType.custom,
useButtonStyle: true,
imageSrc:"data:image/svg+xml;base64,PD94bWwgdmVyc2lvb...", //这不是完整的base64字符串
};
//创建样式
var style = new GC.Spread.Sheets.Style();
style.cellButtons=[
buttonConfig1,
buttonConfig2,
buttonConfig3
];
sheet.setStyle(0, 0, style);
• cellPadding: undefined | string
指示单元格内边距。
example
//此示例设置水印的单元格内边距。
var type = new GC.Spread.Sheets.Style();
type.watermark = "User name";
type.cellPadding = "20";
type.labelOptions = {alignment:GC.Spread.Sheets.LabelAlignment.topLeft, visibility: GC.Spread.Sheets.LabelVisibility.visible};
activeSheet.setStyle(0, 1, type);
activeSheet.getRange(0, -1, 1, -1, GC.Spread.Sheets.SheetArea.viewport).height(60);
activeSheet.getRange(-1, 1, -1, 1).width(150);
var combo = new GC.Spread.Sheets.CellTypes.ComboBox();
combo.items([{ text: "Oranges", value: "11k" }, { text: "Apples", value: "15k" }, { text: "Grape", value: "100k" }]);
combo.editorValueType(GC.Spread.Sheets.CellTypes.EditorValueType.text);
activeSheet.setCellType(2, 1, combo, GC.Spread.Sheets.SheetArea.viewport);
activeSheet.getCell(2, 1, GC.Spread.Sheets.SheetArea.viewport).watermark("ComboBox Cell Type").cellPadding('10 10 20 10');
activeSheet.getCell(2, 1, GC.Spread.Sheets.SheetArea.viewport).labelOptions({alignment: GC.Spread.Sheets.LabelAlignment.bottomCenter, foreColor: 'yellowgreen', font: 'bold 15px Arial'});
activeSheet.getRange(2, -1, 1, -1, GC.Spread.Sheets.SheetArea.viewport).height(60);
• cellType: undefined | Base
指示单元格类型。
example
//此示例创建样式并将其应用于单元格。
var cellType = new GC.Spread.Sheets.CellTypes.Button();
cellType.buttonBackColor("#FFFF00");
cellType.text("this is a button");
var style = new GC.Spread.Sheets.Style();
style.backColor = "red";
style.borderLeft =new GC.Spread.Sheets.LineBorder("blue",GC.Spread.Sheets.LineStyle.medium);
style.borderTop = new GC.Spread.Sheets.LineBorder("blue",GC.Spread.Sheets.LineStyle.medium);
style.borderRight = new GC.Spread.Sheets.LineBorder("blue",GC.Spread.Sheets.LineStyle.medium);
style.borderBottom = new GC.Spread.Sheets.LineBorder("blue",GC.Spread.Sheets.LineStyle.medium);
style.cellType = cellType
activeSheet.setStyle(1,1,style,GC.Spread.Sheets.SheetArea.viewport);
• decoration: IDecoration
定义单元格装饰器以更好地表示单元格。
example
//此示例设置Style的decoration属性。
var style = new GC.Spread.Sheets.Style();
style.decoration = {
cornerFold: {
size: 6,
position: GC.Spread.Sheets.CornerPosition.leftTop,
color: "red"
},
icons: [
{
src: './icon.png',
width: 12,
height: 12,
position: GC.Spread.Sheets.IconPosition.left,
}
]
}
• diagonalDown: undefined | LineBorder
指示对角线向下边框线。
example
activeSheet.getRange(-1, 3, -1, 1, GC.Spread.Sheets.SheetArea.viewport).diagonalDown(new GC.Spread.Sheets.LineBorder("blue", GC.Spread.Sheets.LineStyle.mediumDashed));
• diagonalUp: undefined | LineBorder
指示对角线向上边框线。
example
activeSheet.getRange(-1, 3, -1, 1, GC.Spread.Sheets.SheetArea.viewport).diagonalUp(new GC.Spread.Sheets.LineBorder("blue", GC.Spread.Sheets.LineStyle.mediumDashed));
• dropDowns: undefined | IDropdown[]
指示单元格的下拉类型。
example
leftButtonConfig1 = {
caption: "left",
enabled: true,
isLeft: true,
visibility:GC.Spread.Sheets.ButtonVisibility.always,
command: "opendropdown"
}
//创建样式
var style = new GC.Spread.Sheets.Style();
style.cellButtons=[
leftButtonConfig1
];
style.dropDowns= [{ type: "colorPicker" }];
sheet.setStyle(0, 0, style);
• font: undefined | string
指示字体。
example
//此示例设置font属性。
var style = new GC.Spread.Sheets.Style();
style.font = "8pt Arial";
style.hAlign = GC.Spread.Sheets.HorizontalAlign.center;
style.vAlign = GC.Spread.Sheets.VerticalAlign.center;
activeSheet.setStyle(1,1,style,GC.Spread.Sheets.SheetArea.viewport);
activeSheet.getCell(1,1).value("B2");
• fontFamily: undefined | string
指示字体系列。
example
//此示例设置fontFamily属性。
var style = new GC.Spread.Sheets.Style();
style.fontFamily = "Arial";
activeSheet.setStyle(1,1,style,GC.Spread.Sheets.SheetArea.viewport);
activeSheet.getCell(1,1).value("B2");
• fontSize: undefined | string
指示字体大小。
example
//此示例设置fontSize属性。
var style = new GC.Spread.Sheets.Style();
style.fontSize = "22px";
activeSheet.setStyle(1,1,style,GC.Spread.Sheets.SheetArea.viewport);
activeSheet.getCell(1,1).value("B2");
• fontStyle: undefined | string
指示字体样式。
example
//此示例设置fontStyle属性。
var style = new GC.Spread.Sheets.Style();
style.fontStyle = "italic";
activeSheet.setStyle(1,1,style,GC.Spread.Sheets.SheetArea.viewport);
activeSheet.getCell(1,1).value("B2");
• fontWeight: undefined | string
指示字体粗细。
example
//此示例设置fontWeight属性。
var style = new GC.Spread.Sheets.Style();
style.fontWeight = "bold";
activeSheet.setStyle(1,1,style,GC.Spread.Sheets.SheetArea.viewport);
activeSheet.getCell(1,1).value("B2");
• foreColor: undefined | string
指示前景色。
example
//此示例设置foreColor属性。
activeSheet.setArray(0,0,[1,2,3,4,5,6,7,8,9,10]);
var style = new GC.Spread.Sheets.Style();
style.backColor = "red";
style.foreColor = "black";
var cell = new GC.Spread.Sheets.ConditionalFormatting.NormalConditionRule();
cell.ruleType(GC.Spread.Sheets.ConditionalFormatting.RuleType.cellValueRule);
cell.operator(GC.Spread.Sheets.ConditionalFormatting.ComparisonOperators.greaterThan);
cell.value1(5);
cell.ranges([new GC.Spread.Sheets.Range(0, 0, 10, 1)]);
cell.style(style);
activeSheet.conditionalFormats.addRule(cell);
var style1 = new GC.Spread.Sheets.Style();
style1.foreColor = "red";
var top = new GC.Spread.Sheets.ConditionalFormatting.NormalConditionRule();
top.ruleType(GC.Spread.Sheets.ConditionalFormatting.RuleType.top10Rule);
top.type(GC.Spread.Sheets.ConditionalFormatting.Top10ConditionType.top);
top.rank(3);
top.style(style1);
top.ranges([new GC.Spread.Sheets.Range(0, 0, 10, 1)]);
top.stopIfTrue(true);
activeSheet.conditionalFormats.addRule(top);
• formatter: undefined | string | GeneralFormatter
指示格式化程序。
example
//此示例使用formatter属性。
var style = new GC.Spread.Sheets.Style();
style.formatter = "0.000%";
style.themeFont = "Body";
activeSheet.setStyle(1,1,style,GC.Spread.Sheets.SheetArea.viewport);
activeSheet.getCell(1,1).value("11");
• hAlign: undefined | HorizontalAlign
指示水平对齐。
example
//此示例设置hAlign属性。
var style = new GC.Spread.Sheets.Style();
style.font = "8pt Arial";
style.hAlign = GC.Spread.Sheets.HorizontalAlign.center;
style.vAlign = GC.Spread.Sheets.VerticalAlign.center;
activeSheet.setStyle(1,1,style,GC.Spread.Sheets.SheetArea.viewport);
activeSheet.getCell(1,1).value("B2");
• hidden: undefined | boolean
指示单元格公式是否在受保护的工作表中可见。
example
//此示例隐藏单个单元格。
activeSheet.options.isProtected = true;
activeSheet.setValue(1, 1, "=SUM(1,2)");
var style = new GC.Spread.Sheets.Style();
style.backColor = "red";
style.borderLeft =new GC.Spread.Sheets.LineBorder("blue",GC.Spread.Sheets.LineStyle.medium);
style.borderTop = new GC.Spread.Sheets.LineBorder("blue",GC.Spread.Sheets.LineStyle.medium);
style.borderRight = new GC.Spread.Sheets.LineBorder("blue",GC.Spread.Sheets.LineStyle.medium);
style.borderBottom = new GC.Spread.Sheets.LineBorder("blue",GC.Spread.Sheets.LineStyle.medium);
style.hidden = true;
activeSheet.setStyle(1,1,style,GC.Spread.Sheets.SheetArea.viewport);
• imeMode: undefined | ImeMode
指示输入法编辑器(IME)模式。
deprecated 此属性当前仅在Internet Explorer中有效。
example
//此示例设置IME模式。
var style = new GC.Spread.Sheets.Style();
style.imeMode = GC.Spread.Sheets.ImeMode.auto;
activeSheet.setStyle(0, 0, style);
• isVerticalText: undefined | boolean
指示是否设置文本垂直。
example
//此示例使用rotate属性。
var style = new GC.Spread.Sheets.Style();
style.isVerticalText = true;
activeSheet.setStyle(1,1,style,GC.Spread.Sheets.SheetArea.viewport);
• labelOptions: undefined | ILabelOptions
指示单元格标签选项。
property [alignment] - 单元格标签位置。
property [visibility] - 单元格标签可见性。
property [font] - 单元格标签字体。
property [foreColor] - 单元格标签前景色。
property [margin] - 单元格标签边距。
example
//此示例设置水印的单元格标签选项。
var type = new GC.Spread.Sheets.Style();
type.watermark = "User name";
type.cellPadding = "20";
type.labelOptions = {alignment:GC.Spread.Sheets.LabelAlignment.topLeft, visibility: GC.Spread.Sheets.LabelVisibility.visible};
activeSheet.setStyle(0, 1, type);
activeSheet.getRange(0, -1, 1, -1, GC.Spread.Sheets.SheetArea.viewport).height(60);
activeSheet.getRange(-1, 1, -1, 1).width(150);
var combo = new GC.Spread.Sheets.CellTypes.ComboBox();
combo.items([{ text: "Oranges", value: "11k" }, { text: "Apples", value: "15k" }, { text: "Grape", value: "100k" }]);
combo.editorValueType(GC.Spread.Sheets.CellTypes.EditorValueType.text);
activeSheet.setCellType(2, 1, combo, GC.Spread.Sheets.SheetArea.viewport);
activeSheet.getCell(2, 1, GC.Spread.Sheets.SheetArea.viewport).watermark("ComboBox Cell Type").cellPadding('10 10 20 10');
activeSheet.getCell(2, 1, GC.Spread.Sheets.SheetArea.viewport).labelOptions({alignment: GC.Spread.Sheets.LabelAlignment.bottomCenter, foreColor: 'yellowgreen', font: 'bold 15px Arial'});
activeSheet.getRange(2, -1, 1, -1, GC.Spread.Sheets.SheetArea.viewport).height(60);
• locked: undefined | boolean
指示单元格是否被标记为锁定,无法编辑。
example
//此示例解锁单个单元格。
activeSheet.options.isProtected = true;
var style = new GC.Spread.Sheets.Style();
style.backColor = "red";
style.borderLeft =new GC.Spread.Sheets.LineBorder("blue",GC.Spread.Sheets.LineStyle.medium);
style.borderTop = new GC.Spread.Sheets.LineBorder("blue",GC.Spread.Sheets.LineStyle.medium);
style.borderRight = new GC.Spread.Sheets.LineBorder("blue",GC.Spread.Sheets.LineStyle.medium);
style.borderBottom = new GC.Spread.Sheets.LineBorder("blue",GC.Spread.Sheets.LineStyle.medium);
style.locked = false;
activeSheet.setStyle(1,1,style,GC.Spread.Sheets.SheetArea.viewport);
• mask: undefined | IMaskType
指示输入掩码。
example
// 此示例使用mask属性。
var style = new GC.Spread.Sheets.Style();
style.mask = {
pattern: '000-00000',
excludeLiteral: true,
placeholder: '#'
};
activeSheet.setStyle(1, 1, style, GC.Spread.Sheets.SheetArea.viewport);
• name: undefined | string
指示名称。
example
//此示例设置样式名称。
var namedStyle = new GC.Spread.Sheets.Style();
namedStyle.name = "style1";
namedStyle.backColor = "green";
activeSheet.addNamedStyle(namedStyle);
activeSheet.setStyleName(1, 1, "style1"); // cell(1,1)'s backColor is green.
var namedStyle1 = new GC.Spread.Sheets.Style();
namedStyle1.name = "style2";
namedStyle1.parentName = "style1";
namedStyle1.foreColor = "red"; // the namedStyle's foreColor is red.
activeSheet.addNamedStyle(namedStyle1);
activeSheet.setStyleName(2, 1, "style2");
• parentName: undefined | string
指示父样式名称。
example
//此示例设置父样式名称。
var namedStyle = new GC.Spread.Sheets.Style();
namedStyle.name = "style1";
namedStyle.backColor = "green";
activeSheet.addNamedStyle(namedStyle);
activeSheet.setStyleName(1, 1, "style1"); // cell(1,1)'s backColor is green.
var namedStyle1 = new GC.Spread.Sheets.Style();
namedStyle1.name = "style2";
namedStyle1.parentName = "style1";
namedStyle1.foreColor = "red"; // the namedStyle's foreColor is red.
activeSheet.addNamedStyle(namedStyle1);
activeSheet.setStyleName(2, 1, "style2");
• showEllipsis: undefined | boolean
控制文本超出边界时是否显示省略号。
example
//此示例设置showEllipsis属性。
var style = new GC.Spread.Sheets.Style();
style.showEllipsis = true;
activeSheet.setStyle(1,1,style,GC.Spread.Sheets.SheetArea.viewport);
activeSheet.getCell(1,1).text("TestTestTestTest");
• shrinkToFit: undefined | boolean
指示是否缩小以适应。
example
//此示例设置shrinkToFit属性。
var style = new GC.Spread.Sheets.Style();
style.shrinkToFit = true;
activeSheet.setStyle(1,1,style,GC.Spread.Sheets.SheetArea.viewport);
activeSheet.getCell(1,1).text("Shrink To Fit");
• tabStop: undefined | boolean
指示用户是否可以使用Tab键将焦点设置到单元格。
example
//此示例设置tabStop属性。
var style = new GC.Spread.Sheets.Style();
style.tabStop = false;
style.backColor = "lightgreen";
activeSheet.setStyle(1,1,style,GC.Spread.Sheets.SheetArea.viewport);
• textDecoration: undefined | TextDecorationType
表示添加到文本中的装饰。
example
//此示例使用textDecoration属性。
activeSheet.getCell(0, 0).textDecoration(GC.Spread.Sheets.TextDecorationType.underline);
activeSheet.getRange(1, -1, 1, -1).textDecoration(GC.Spread.Sheets.TextDecorationType.overline | GC.Spread.Sheets.TextDecorationType.underline);
activeSheet.getRange(-1, 1, -1, 1).textDecoration(GC.Spread.Sheets.TextDecorationType.overline | GC.Spread.Sheets.TextDecorationType.lineThrough | GC.Spread.Sheets.TextDecorationType.underline);
var style = new GC.Spread.Sheets.Style();
style.textDecoration = GC.Spread.Sheets.TextDecorationType.overline | GC.Spread.Sheets.TextDecorationType.underline;
activeSheet.setStyle(1, 1, style, GC.Spread.Sheets.SheetArea.viewport);
activeSheet.getCell(0, 0).value("Test");
activeSheet.getCell(1, 0).value("Test");
activeSheet.getCell(0, 1).value("Test");
• textDirection: undefined | TextDirectionType
定义单元格的文本方向,以更好地表示单元格。
example
//此示例设置Style的textDirection属性。
var style = new GC.Spread.Sheets.Style();
style.textDirection = GC.Spread.Sheets.TextDirectionType.rightToLeft;
• textIndent: undefined | number
指示单元格中文本缩进量,一个整数值,其中每个增量代表8像素。
example
//此示例设置textIndent属性。
var style = new GC.Spread.Sheets.Style();
style.textIndent = 3;
// 使用Alt+Enter输入多行
style.wordWrap = true;
activeSheet.setStyle(1,1,style,GC.Spread.Sheets.SheetArea.viewport);
activeSheet.getCell(1,1).text("Test");
• textOrientation: undefined | number
指示单元格中文本旋转角度。
example
//此示例设置textOrientation属性。
var style = new GC.Spread.Sheets.Style();
style.textOrientation = 66;
activeSheet.setStyle(1,1,style,GC.Spread.Sheets.SheetArea.viewport);
activeSheet.getCell(1,1).text("TestTestTestTest");
• themeFont: undefined | string
指示字体主题。
example
//此示例使用themeFont属性。
var style = new GC.Spread.Sheets.Style();
style.formatter = "0.000%";
style.themeFont = "Body";
activeSheet.setStyle(1,1,style,GC.Spread.Sheets.SheetArea.viewport);
activeSheet.getCell(1,1).value("11");
• vAlign: undefined | VerticalAlign
指示垂直对齐。
example
//此示例设置vAlign属性。
var style = new GC.Spread.Sheets.Style();
style.font = "8pt Arial";
style.hAlign = GC.Spread.Sheets.HorizontalAlign.center;
style.vAlign = GC.Spread.Sheets.VerticalAlign.center;
activeSheet.setStyle(1,1,style,GC.Spread.Sheets.SheetArea.viewport);
activeSheet.getCell(1,1).value("B2");
• watermark: undefined | string
指示水印内容。
example
//以下示例将水印添加到单元格、列和行。
var type = new GC.Spread.Sheets.Style();
type.watermark = "User name";
sheet.setStyle(0, 1, type);
var type = new GC.Spread.Sheets.Style();
type.watermark = "Password";
sheet.setStyle(1, 1, type);
example
var type = new GC.Spread.Sheets.Style();
type.watermark = "The watermark.";
activeSheet.setStyle(-1, 1, type);
activeSheet.setStyle(1, -1, type);
activeSheet.setStyle(2, 2, type);
• wordWrap: undefined | boolean
指示是否换行。
example
//此示例设置wordWrap属性。
var style = new GC.Spread.Sheets.Style();
style.textIndent = 3;
// 使用Alt+Enter输入多行
style.wordWrap = true;
activeSheet.setStyle(1,1,style,GC.Spread.Sheets.SheetArea.viewport);
activeSheet.getCell(1,1).text("Test");
▸ clone(): Style
克隆当前样式。
克隆的样式。