Difference between revisions of "Tabulation setTableDiagramStyle"
| Line 1: | Line 1: | ||
| − | {{HelpFiles}} | + | [[Category:Style_setting_functions]] |
| + | {{HelpFiles}} | ||
| − | ===Tabulation_setTableDiagramStyle=== | + | ===Tabulation_setTableDiagramStyle===) |
| − | + | Sets the style for part of a chart. | |
| − | === Syntax === | + | ===Syntax=== |
Tabulation_setTableDiagramStyle(styleType, tableDiagramStyle, argTableDiagramStyle); | Tabulation_setTableDiagramStyle(styleType, tableDiagramStyle, argTableDiagramStyle); | ||
| − | === Arguments === | + | ===Arguments=== |
*styleType: is the CELL type that will be affected by the call. It's the value of the Table diagram constants. Or we can also use the name of Table Diagram constants | *styleType: is the CELL type that will be affected by the call. It's the value of the Table diagram constants. Or we can also use the name of Table Diagram constants | ||
| Line 20: | Line 21: | ||
tableDiagramStyle | tableDiagramStyle | ||
| − | | style="border: 1px solid #010101" bgcolor="#F59D56" width="73" | | + | | style="border: 1px solid #010101" bgcolor="#F59D56" width="73" | |
Type | Type | ||
| Line 64: | Line 65: | ||
|} | |} | ||
| − | === Return type === | + | ===Return type=== |
Empty | Empty | ||
| − | === Examples === | + | ===Examples=== |
| + | [[File:Tabulation setTableDiagramStyle1.png|none]] | ||
| + | <source lang="javascript"> | ||
| + | DCS_use(15507609); | ||
| + | Tabulation_setTableLayout(TableChartLayout_Classic); | ||
| − | + | array FoS_default = DiagramFontStyle_getDefault(); | |
| − | + | FoS_default[DIAGRAM_FONT_STYLE_COLOR] = Color_getByRGB("#000000"); | |
| − | </source> __NOTOC__ | + | FoS_default[DIAGRAM_FONT_STYLE_FACE] = "Arial"; |
| + | FoS_default[DIAGRAM_FONT_STYLE_SIZE] = 10 ; | ||
| + | |||
| + | array FiS_default = DiagramFillStyle_getDefault(); | ||
| + | FiS_default[DIAGRAM_FILL_STYLE_COLOR] = Color_getByRGB("#f3f4f5"); | ||
| + | |||
| + | Tabulation_setTableDiagramStyle(TableDiagram_AllTable, TABLE_DIAGRAM_STYLE_FONT, FoS_default); | ||
| + | Tabulation_setTableDiagramStyle(TableDiagram_AllTable, TABLE_DIAGRAM_STYLE_FILL, FiS_default); | ||
| + | Tabulation_setTableDiagramStyle(TableDiagram_AllTable, TABLE_DIAGRAM_STYLE_VALIGN, "center"); | ||
| + | Tabulation_setTableDiagramStyle(TableDiagram_AllTable, TABLE_DIAGRAM_STYLE_HALIGN, "right"); | ||
| + | Tabulation_setTableDiagramStyle(TableDiagram_AllTable, TABLE_DIAGRAM_STYLE_NUMBER_FORMATTER, "{0:#;minus #;zero}"); | ||
| + | Tabulation_setTableDiagramStyle(TableDiagram_AllTable, TABLE_DIAGRAM_STYLE_PERCENT_FORMATTER, "{0:#;minus #;zero}pct"); | ||
| + | Tabulation_setTableDiagramStyle(TableDiagram_AllTable, TABLE_DIAGRAM_STYLE_SIGNIFICANCE_FORMATTER, "{1}{0:+;-;,}"); | ||
| + | |||
| + | createCrossDiagram({"QA1"},{"D_Age_Group"}); | ||
| + | </source> | ||
| + | [[File:Tabulation setTableDiagramStyle2.png|none]] | ||
| + | __NOTOC__ | ||
Revision as of 10:32, 7 December 2015
===Tabulation_setTableDiagramStyle===)
Sets the style for part of a chart.
Syntax
Tabulation_setTableDiagramStyle(styleType, tableDiagramStyle, argTableDiagramStyle);
Arguments
- styleType: is the CELL type that will be affected by the call. It's the value of the Table diagram constants. Or we can also use the name of Table Diagram constants
- tableDiagramStyle: is the kind of style. It's the value of the Table Diagram style constants. Or we can also use the name of Table Diagram style constants
- argTableDiagramStyle: is argument for the given tableDiagramStyle
|
tableDiagramStyle |
Type |
Description |
| TABLE_DIAGRAM_STYLE_FILL |
array |
Is the array of function DiagramFillStyle_getDefault |
| TABLE_DIAGRAM_STYLE_DECIMAL |
number |
With min 0 |
| TABLE_DIAGRAM_STYLE_FONT |
array |
Is the array of function DiagramFontStyle_getDefault |
| TABLE_DIAGRAM_STYLE_VALIGN |
string |
takes string values of these Center, Left, Right |
| TABLE_DIAGRAM_STYLE_HALIGN |
string |
takes string values of these Center, Left, Right |
| TABLE_DIAGRAM_STYLE_NUMBER_FORMATTER |
string |
takes a string.format string, default is "{0:"+decimalplaces+"}" |
| TABLE_DIAGRAM_STYLE_PERCENT_FORMATTER |
string |
takes a string.format string, default is "{0:"+decimalplaces+"}%" |
| TABLE_DIAGRAM_STYLE_SIGNIFICANCE_FORMATTER |
string |
takes a string.format string, default is "{0:[+];[-];,} {1}" where 0 is int that is positive, negative or zero depending on significance and 1 is the Z value |
| TABLE_DIAGRAM_STYLE_BORDER_STYLE |
object |
takes a Border object |
Return type
Empty
Examples
DCS_use(15507609);
Tabulation_setTableLayout(TableChartLayout_Classic);
array FoS_default = DiagramFontStyle_getDefault();
FoS_default[DIAGRAM_FONT_STYLE_COLOR] = Color_getByRGB("#000000");
FoS_default[DIAGRAM_FONT_STYLE_FACE] = "Arial";
FoS_default[DIAGRAM_FONT_STYLE_SIZE] = 10 ;
array FiS_default = DiagramFillStyle_getDefault();
FiS_default[DIAGRAM_FILL_STYLE_COLOR] = Color_getByRGB("#f3f4f5");
Tabulation_setTableDiagramStyle(TableDiagram_AllTable, TABLE_DIAGRAM_STYLE_FONT, FoS_default);
Tabulation_setTableDiagramStyle(TableDiagram_AllTable, TABLE_DIAGRAM_STYLE_FILL, FiS_default);
Tabulation_setTableDiagramStyle(TableDiagram_AllTable, TABLE_DIAGRAM_STYLE_VALIGN, "center");
Tabulation_setTableDiagramStyle(TableDiagram_AllTable, TABLE_DIAGRAM_STYLE_HALIGN, "right");
Tabulation_setTableDiagramStyle(TableDiagram_AllTable, TABLE_DIAGRAM_STYLE_NUMBER_FORMATTER, "{0:#;minus #;zero}");
Tabulation_setTableDiagramStyle(TableDiagram_AllTable, TABLE_DIAGRAM_STYLE_PERCENT_FORMATTER, "{0:#;minus #;zero}pct");
Tabulation_setTableDiagramStyle(TableDiagram_AllTable, TABLE_DIAGRAM_STYLE_SIGNIFICANCE_FORMATTER, "{1}{0:+;-;,}");
createCrossDiagram({"QA1"},{"D_Age_Group"});
