Difference between revisions of "Tabulation setTableDiagramStyle"
| (10 intermediate revisions by 2 users not shown) | |||
| Line 4: | Line 4: | ||
===Tabulation_setTableDiagramStyle=== | ===Tabulation_setTableDiagramStyle=== | ||
| − | Sets the style for | + | Sets the style for a chart. |
===Syntax=== | ===Syntax=== | ||
Tabulation_setTableDiagramStyle(styleType, tableDiagramStyle, argTableDiagramStyle); | Tabulation_setTableDiagramStyle(styleType, tableDiagramStyle, argTableDiagramStyle); | ||
| + | |||
| + | can use [[TabulationDiagramParameter_class|TabulationDiagramParameter.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 [http://wiki.catglobe.com/index.php/CGS_Constants_list#Table_Diagram_constants 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 | + | *tableDiagramStyle: is the kind of style. It's the value of the Table Diagram style constants. Or we can also use the name of [http://wiki.catglobe.com/index.php/CGS_Constants_list#Table_Diagram_style_constants Table Diagram style constants] |
*argTableDiagramStyle: is argument for the given tableDiagramStyle | *argTableDiagramStyle: is argument for the given tableDiagramStyle | ||
| Line 19: | Line 21: | ||
|- align="left" valign="top" | |- align="left" valign="top" | ||
| style="border: 1px solid #010101" bgcolor="#F59D56" width="227" | | | style="border: 1px solid #010101" bgcolor="#F59D56" width="227" | | ||
| − | + | TableDiagramStyle | |
| style="border: 1px solid #010101" bgcolor="#F59D56" width="73" | | | style="border: 1px solid #010101" bgcolor="#F59D56" width="73" | | ||
| − | + | Argument type | |
| style="border: 1px solid #010101" bgcolor="#F59D56" width="433" | | | style="border: 1px solid #010101" bgcolor="#F59D56" width="433" | | ||
| Line 50: | Line 52: | ||
| colspan="1" style="border: 1px solid #010101" width="227" | TABLE_DIAGRAM_STYLE_NUMBER_FORMATTER<br/> | | colspan="1" style="border: 1px solid #010101" width="227" | TABLE_DIAGRAM_STYLE_NUMBER_FORMATTER<br/> | ||
| style="border: 1px solid #010101" width="174" | string<br/> | | style="border: 1px solid #010101" width="174" | string<br/> | ||
| − | | takes a string.format string, default is "{0:"+decimalplaces+"}"<br/> | + | | takes a string.format string, default is "{0:"+decimalplaces+"}" ex: {0:0.00}<br/> |
|- | |- | ||
| colspan="1" style="border: 1px solid #010101" width="227" | TABLE_DIAGRAM_STYLE_PERCENT_FORMATTER<br/> | | colspan="1" style="border: 1px solid #010101" width="227" | TABLE_DIAGRAM_STYLE_PERCENT_FORMATTER<br/> | ||
| style="border: 1px solid #010101" width="174" | string<br/> | | style="border: 1px solid #010101" width="174" | string<br/> | ||
| − | | takes a string.format string, default is "{0:"+decimalplaces+"}%"<br/> | + | | takes a string.format string, default is "{0:"+decimalplaces+"}%" ex: {0:0.00}%<br/> |
|- | |- | ||
| colspan="1" style="border: 1px solid #010101" width="227" | TABLE_DIAGRAM_STYLE_SIGNIFICANCE_FORMATTER<br/> | | colspan="1" style="border: 1px solid #010101" width="227" | TABLE_DIAGRAM_STYLE_SIGNIFICANCE_FORMATTER<br/> | ||
| Line 70: | Line 72: | ||
===Examples=== | ===Examples=== | ||
| − | Before set Table diagram style | + | *Before set Table diagram style |
[[File:Tabulation setTableDiagramStyle1.png|none]] | [[File:Tabulation setTableDiagramStyle1.png|none]] | ||
| Line 78: | Line 80: | ||
Tabulation_setTableLayout(TableChartLayout_Classic); | Tabulation_setTableLayout(TableChartLayout_Classic); | ||
| − | array FoS_default = DiagramFontStyle_getDefault(); //Gets a default chart font style object | + | array FoS_default = DiagramFontStyle_getDefault(); //Gets a default chart font style object |
//Custom chart font style | //Custom chart font style | ||
FoS_default[DIAGRAM_FONT_STYLE_COLOR] = Color_getByRGB("#000000"); | FoS_default[DIAGRAM_FONT_STYLE_COLOR] = Color_getByRGB("#000000"); | ||
FoS_default[DIAGRAM_FONT_STYLE_FACE] = "Arial"; | FoS_default[DIAGRAM_FONT_STYLE_FACE] = "Arial"; | ||
| − | FoS_default[DIAGRAM_FONT_STYLE_SIZE] = 10 ; | + | FoS_default[DIAGRAM_FONT_STYLE_SIZE] = 10; |
| − | array FiS_default = DiagramFillStyle_getDefault(); //Gets a default chart fill style object | + | array FiS_default = DiagramFillStyle_getDefault(); //Gets a default chart fill style object |
//Custom chart fill style | //Custom chart fill style | ||
FiS_default[DIAGRAM_FILL_STYLE_COLOR] = Color_getByRGB("#f3f4f5"); | FiS_default[DIAGRAM_FILL_STYLE_COLOR] = Color_getByRGB("#f3f4f5"); | ||
| Line 99: | Line 101: | ||
</source> | </source> | ||
| − | After | + | *After setting Table diagram style with source above |
[[File:Tabulation setTableDiagramStyle2.png|none]] | [[File:Tabulation setTableDiagramStyle2.png|none]] | ||
| + | |||
| + | |||
| + | |||
| + | |||
| + | <source lang="javascript"> | ||
| + | DCS_use(15507609); | ||
| + | Tabulation_setTableLayout(TableChartLayout_Classic); | ||
| + | array FoS_header = DiagramFontStyle_getDefault(); | ||
| + | FoS_header[DIAGRAM_FONT_STYLE_COLOR] = Color_getByRGB("#307D7E"); | ||
| + | |||
| + | array FiS_header = DiagramFillStyle_getDefault(); | ||
| + | FiS_header[DIAGRAM_FILL_STYLE_COLOR] = Color_getByRGB("#AF7817"); | ||
| + | |||
| + | Tabulation_setTableDiagramStyle(TableDiagram_ColumnHeaderLevel1, TABLE_DIAGRAM_STYLE_FONT, FoS_header); | ||
| + | Tabulation_setTableDiagramStyle(TableDiagram_ColumnHeaderLevel1, TABLE_DIAGRAM_STYLE_FILL, FiS_header); | ||
| + | Tabulation_setTableDiagramStyle(TableDiagram_ColumnHeaderLevel1, TABLE_DIAGRAM_STYLE_HALIGN, "center"); | ||
| + | object customBorderLevel2 = new TabulationBorder("Top,Bottom", 2, "Solid", Color_getByRGB("#000000")); | ||
| + | Tabulation_setTableDiagramStyle(TableDiagram_ColumnHeaderLevel2, TABLE_DIAGRAM_STYLE_BORDER_STYLE, customBorderLevel2); | ||
| + | Tabulation_setTableDiagramStyle(TableDiagram_AbsoluteColumn, TABLE_DIAGRAM_STYLE_FONT, FoS_header); | ||
| + | Tabulation_setTableDiagramStyle(TableDiagram_AbsoluteColumn, TABLE_DIAGRAM_STYLE_FILL, FiS_header); | ||
| + | Tabulation_setTableDiagramStyle(TableDiagram_AbsoluteColumn, TABLE_DIAGRAM_STYLE_HALIGN, "center"); | ||
| + | |||
| + | |||
| + | //----------------------------- | ||
| + | Tabulation_setTableDiagramStyle(TableDiagram_AbsoluteColumnValue, TABLE_DIAGRAM_STYLE_DECIMAL, 0); | ||
| + | //----------------------------- | ||
| + | FiS_header[DIAGRAM_FILL_STYLE_COLOR] = Color_getByRGB("#387C44"); | ||
| + | Tabulation_setTableDiagramStyle(TableDiagram_ColumnHeaderLevel2, TABLE_DIAGRAM_STYLE_DECIMAL, 1); | ||
| + | Tabulation_setTableDiagramStyle(TableDiagram_ColumnHeaderLevel2, TABLE_DIAGRAM_STYLE_FILL, FiS_header); | ||
| + | Tabulation_setTableDiagramStyle(TableDiagram_PercentageColumn, TABLE_DIAGRAM_STYLE_DECIMAL, 1); | ||
| + | Tabulation_setTableDiagramStyle(TableDiagram_PercentageColumn, TABLE_DIAGRAM_STYLE_FILL, FiS_header); | ||
| + | |||
| + | /////////////////////////////////////////////////////////////// | ||
| + | array FoS_default = DiagramFontStyle_getDefault(); | ||
| + | FoS_default[DIAGRAM_FONT_STYLE_BOLD] = true; | ||
| + | Tabulation_setTableDiagramStyle(TableDiagram_SignificanceCell, TABLE_DIAGRAM_STYLE_FONT, FoS_default); | ||
| + | TabulationBorder tb = new TabulationBorder("Left", 2, "Solid", Color_getByRGB("#303030")); | ||
| + | Tabulation_setTableDiagramStyle(TableDiagram_SignificanceCell, TABLE_DIAGRAM_STYLE_BORDER_STYLE, tb); | ||
| + | |||
| + | array FiS_default = DiagramFillStyle_getDefault(); | ||
| + | FoS_default[DIAGRAM_FONT_STYLE_BOLD] = false; | ||
| + | FoS_default[DIAGRAM_FONT_STYLE_COLOR] = Color_getByRGB("#000000"); | ||
| + | FiS_default[DIAGRAM_FILL_STYLE_COLOR] = Color_getByRGB("#307D7E"); | ||
| + | Tabulation_setTableDiagramStyle(TableDiagram_SignificanceRow, TABLE_DIAGRAM_STYLE_FONT, FoS_default); | ||
| + | Tabulation_setTableDiagramStyle(TableDiagram_SignificanceRow, TABLE_DIAGRAM_STYLE_FILL, FiS_default); | ||
| + | |||
| + | createCrossDiagram({"QA1"},{"D_Age_Group"}); | ||
| + | </source> | ||
| + | |||
| + | *After setting Table diagram style with source above | ||
| + | [[File:setTableDiagramStyle3.png|none]] | ||
| + | |||
| + | |||
| + | |||
| + | |||
| + | <source lang="javascript"> | ||
| + | DCS_use(15507609); | ||
| + | Tabulation_setTableLayout(TableChartLayout_Standard); | ||
| + | |||
| + | Tabulation_setSignificance(true); | ||
| + | Tabulation_setCountAnswer(true); | ||
| + | |||
| + | Tabulation_setMergeStatisticPctItem(true); | ||
| + | Tabulation_setEnableOddEvenRowHeader(true); | ||
| + | |||
| + | Tabulation_setAbsText("abs"); | ||
| + | Tabulation_setPctText("%"); | ||
| + | Tabulation_setTotalText("Resp."); | ||
| + | //--------------------------------------------------// | ||
| + | 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_INHERIT] = true; | ||
| + | |||
| + | array DiagramS_default = Tabulation_getDefaultDiagramStyle(Diagram_Type_Table); | ||
| + | DiagramS_default[TABLE_DIAGRAM_STYLE_FONT] = FoS_default; | ||
| + | DiagramS_default[TABLE_DIAGRAM_STYLE_FILL] = FiS_default; | ||
| + | DiagramS_default[TABLE_DIAGRAM_STYLE_VALIGN] = "center"; | ||
| + | DiagramS_default[TABLE_DIAGRAM_STYLE_HALIGN] = "right"; | ||
| + | DiagramS_default[TABLE_DIAGRAM_STYLE_DECIMAL] = 0; | ||
| + | |||
| + | Tabulation_setDiagramStyle(TableDiagram_AllTable, DiagramS_default); | ||
| + | //--------------------------------------------------// | ||
| + | FiS_default[DIAGRAM_FILL_STYLE_COLOR] = Color_getByRGB("#FFFFFF"); | ||
| + | FiS_default[DIAGRAM_FILL_STYLE_INHERIT] = false; | ||
| + | Tabulation_setTableDiagramStyle(TableDiagram_ColumnHeader, TABLE_DIAGRAM_STYLE_FILL, FiS_default); | ||
| + | |||
| + | FoS_default[DIAGRAM_FONT_STYLE_BOLD] = true; | ||
| + | Tabulation_setTableDiagramStyle(TableDiagram_SignificanceCell, TABLE_DIAGRAM_STYLE_FONT, FoS_default); | ||
| + | Tabulation_setTableDiagramStyle(TableDiagram_SignificanceCell, TABLE_DIAGRAM_STYLE_HALIGN, "right"); | ||
| + | |||
| + | Tabulation_setTableDiagramStyle(TableDiagram_ColumnHeaderLevel1, TABLE_DIAGRAM_STYLE_HALIGN, "center"); | ||
| + | Tabulation_setTableDiagramStyle(TableDiagram_ColumnHeaderLevel2, TABLE_DIAGRAM_STYLE_HALIGN, "center"); | ||
| + | |||
| + | Tabulation_setTableDiagramStyle(TableDiagram_SignificanceRowValue, TABLE_DIAGRAM_STYLE_HALIGN, "center"); | ||
| + | object customBorderAllTable = new TabulationBorder("Top,Bottom,Left,Right", 0, "None", Color_getByRGB("#000000")); | ||
| + | Tabulation_setTableDiagramStyle(TableDiagram_AllTable, TABLE_DIAGRAM_STYLE_BORDER_STYLE, customBorderAllTable); | ||
| + | object customBorderHeaderLevel1 = new TabulationBorder("Bottom", 1, "Solid", Color_getByRGB("#000000")); | ||
| + | Tabulation_setTableDiagramStyle(TableDiagram_ColumnHeaderLevel1, TABLE_DIAGRAM_STYLE_BORDER_STYLE, customBorderHeaderLevel1); | ||
| + | object customBorderHeaderLevel2 = new TabulationBorder("Top,Bottom", 1, "Solid", Color_getByRGB("#000000")); | ||
| + | Tabulation_setTableDiagramStyle(TableDiagram_ColumnHeaderLevel2, TABLE_DIAGRAM_STYLE_BORDER_STYLE, customBorderHeaderLevel2); | ||
| + | object customBorderTotalRowValue = new TabulationBorder("Top", 1, "Solid", Color_getByRGB("#000000")); | ||
| + | Tabulation_setTableDiagramStyle(TableDiagram_TotalRowValue, TABLE_DIAGRAM_STYLE_BORDER_STYLE, customBorderTotalRowValue); | ||
| + | object customBorderSpacerCell = new TabulationBorder("All", 0, "None", Color_getByRGB("#000000")); | ||
| + | Tabulation_setTableDiagramStyle(TableDiagram_SpacerCell, TABLE_DIAGRAM_STYLE_BORDER_STYLE, customBorderSpacerCell); | ||
| + | |||
| + | |||
| + | Tabulation_setTableDiagramStyle(TableDiagram_AllTable, TABLE_DIAGRAM_STYLE_NUMBER_FORMATTER, "{0:##,#;(##,#)}"); | ||
| + | Tabulation_setTableDiagramStyle(TableDiagram_AllTable, TABLE_DIAGRAM_STYLE_PERCENT_FORMATTER, "{0:##,#;(##,#)}"); | ||
| + | Tabulation_setTableDiagramStyle(TableDiagram_AllTable, TABLE_DIAGRAM_STYLE_SIGNIFICANCE_FORMATTER, "{1}{0:+;-;,}"); | ||
| + | |||
| + | createCrossDiagram({"QA1"},{"D_Age_Group"}); | ||
| + | </source> | ||
| + | *After setting Table diagram style with source above | ||
| + | [[File:setTableDiagramStyle4.png|none]] | ||
| + | |||
__NOTOC__ | __NOTOC__ | ||
Latest revision as of 08:30, 22 September 2023
Tabulation_setTableDiagramStyle
Sets the style for a chart.
Syntax
Tabulation_setTableDiagramStyle(styleType, tableDiagramStyle, argTableDiagramStyle);
can use TabulationDiagramParameter.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 |
Argument 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, Top, Bottom |
| 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+"}" ex: {0:0.00} |
| TABLE_DIAGRAM_STYLE_PERCENT_FORMATTER |
string |
takes a string.format string, default is "{0:"+decimalplaces+"}%" ex: {0:0.00}% |
| 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
- Before set Table diagram style
DCS_use(15507609);
Tabulation_setTableLayout(TableChartLayout_Classic);
array FoS_default = DiagramFontStyle_getDefault(); //Gets a default chart font style object
//Custom chart font style
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(); //Gets a default chart fill style object
//Custom chart fill style
FiS_default[DIAGRAM_FILL_STYLE_COLOR] = Color_getByRGB("#f3f4f5");
Tabulation_setTableDiagramStyle(TableDiagram_AllTable, TABLE_DIAGRAM_STYLE_FONT, FoS_default); //Set custom chart font style
Tabulation_setTableDiagramStyle(TableDiagram_AllTable, TABLE_DIAGRAM_STYLE_FILL, FiS_default); //Set custom chart fill style
Tabulation_setTableDiagramStyle(TableDiagram_AllTable, TABLE_DIAGRAM_STYLE_VALIGN, "center"); //Vertical align the content inside
Tabulation_setTableDiagramStyle(TableDiagram_AllTable, TABLE_DIAGRAM_STYLE_HALIGN, "right"); //Horizontal align the content inside
Tabulation_setTableDiagramStyle(TableDiagram_AllTable, TABLE_DIAGRAM_STYLE_NUMBER_FORMATTER, "{0:#;minus #;zero}"); //Set number style format
Tabulation_setTableDiagramStyle(TableDiagram_AllTable, TABLE_DIAGRAM_STYLE_PERCENT_FORMATTER, "{0:#;minus #;zero}pct"); //Set percent style format
Tabulation_setTableDiagramStyle(TableDiagram_AllTable, TABLE_DIAGRAM_STYLE_SIGNIFICANCE_FORMATTER, "{1}{0:+;-;,}"); //Set significance style format
createCrossDiagram({"QA1"},{"D_Age_Group"});
- After setting Table diagram style with source above
DCS_use(15507609);
Tabulation_setTableLayout(TableChartLayout_Classic);
array FoS_header = DiagramFontStyle_getDefault();
FoS_header[DIAGRAM_FONT_STYLE_COLOR] = Color_getByRGB("#307D7E");
array FiS_header = DiagramFillStyle_getDefault();
FiS_header[DIAGRAM_FILL_STYLE_COLOR] = Color_getByRGB("#AF7817");
Tabulation_setTableDiagramStyle(TableDiagram_ColumnHeaderLevel1, TABLE_DIAGRAM_STYLE_FONT, FoS_header);
Tabulation_setTableDiagramStyle(TableDiagram_ColumnHeaderLevel1, TABLE_DIAGRAM_STYLE_FILL, FiS_header);
Tabulation_setTableDiagramStyle(TableDiagram_ColumnHeaderLevel1, TABLE_DIAGRAM_STYLE_HALIGN, "center");
object customBorderLevel2 = new TabulationBorder("Top,Bottom", 2, "Solid", Color_getByRGB("#000000"));
Tabulation_setTableDiagramStyle(TableDiagram_ColumnHeaderLevel2, TABLE_DIAGRAM_STYLE_BORDER_STYLE, customBorderLevel2);
Tabulation_setTableDiagramStyle(TableDiagram_AbsoluteColumn, TABLE_DIAGRAM_STYLE_FONT, FoS_header);
Tabulation_setTableDiagramStyle(TableDiagram_AbsoluteColumn, TABLE_DIAGRAM_STYLE_FILL, FiS_header);
Tabulation_setTableDiagramStyle(TableDiagram_AbsoluteColumn, TABLE_DIAGRAM_STYLE_HALIGN, "center");
//-----------------------------
Tabulation_setTableDiagramStyle(TableDiagram_AbsoluteColumnValue, TABLE_DIAGRAM_STYLE_DECIMAL, 0);
//-----------------------------
FiS_header[DIAGRAM_FILL_STYLE_COLOR] = Color_getByRGB("#387C44");
Tabulation_setTableDiagramStyle(TableDiagram_ColumnHeaderLevel2, TABLE_DIAGRAM_STYLE_DECIMAL, 1);
Tabulation_setTableDiagramStyle(TableDiagram_ColumnHeaderLevel2, TABLE_DIAGRAM_STYLE_FILL, FiS_header);
Tabulation_setTableDiagramStyle(TableDiagram_PercentageColumn, TABLE_DIAGRAM_STYLE_DECIMAL, 1);
Tabulation_setTableDiagramStyle(TableDiagram_PercentageColumn, TABLE_DIAGRAM_STYLE_FILL, FiS_header);
///////////////////////////////////////////////////////////////
array FoS_default = DiagramFontStyle_getDefault();
FoS_default[DIAGRAM_FONT_STYLE_BOLD] = true;
Tabulation_setTableDiagramStyle(TableDiagram_SignificanceCell, TABLE_DIAGRAM_STYLE_FONT, FoS_default);
TabulationBorder tb = new TabulationBorder("Left", 2, "Solid", Color_getByRGB("#303030"));
Tabulation_setTableDiagramStyle(TableDiagram_SignificanceCell, TABLE_DIAGRAM_STYLE_BORDER_STYLE, tb);
array FiS_default = DiagramFillStyle_getDefault();
FoS_default[DIAGRAM_FONT_STYLE_BOLD] = false;
FoS_default[DIAGRAM_FONT_STYLE_COLOR] = Color_getByRGB("#000000");
FiS_default[DIAGRAM_FILL_STYLE_COLOR] = Color_getByRGB("#307D7E");
Tabulation_setTableDiagramStyle(TableDiagram_SignificanceRow, TABLE_DIAGRAM_STYLE_FONT, FoS_default);
Tabulation_setTableDiagramStyle(TableDiagram_SignificanceRow, TABLE_DIAGRAM_STYLE_FILL, FiS_default);
createCrossDiagram({"QA1"},{"D_Age_Group"});
- After setting Table diagram style with source above
DCS_use(15507609);
Tabulation_setTableLayout(TableChartLayout_Standard);
Tabulation_setSignificance(true);
Tabulation_setCountAnswer(true);
Tabulation_setMergeStatisticPctItem(true);
Tabulation_setEnableOddEvenRowHeader(true);
Tabulation_setAbsText("abs");
Tabulation_setPctText("%");
Tabulation_setTotalText("Resp.");
//--------------------------------------------------//
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_INHERIT] = true;
array DiagramS_default = Tabulation_getDefaultDiagramStyle(Diagram_Type_Table);
DiagramS_default[TABLE_DIAGRAM_STYLE_FONT] = FoS_default;
DiagramS_default[TABLE_DIAGRAM_STYLE_FILL] = FiS_default;
DiagramS_default[TABLE_DIAGRAM_STYLE_VALIGN] = "center";
DiagramS_default[TABLE_DIAGRAM_STYLE_HALIGN] = "right";
DiagramS_default[TABLE_DIAGRAM_STYLE_DECIMAL] = 0;
Tabulation_setDiagramStyle(TableDiagram_AllTable, DiagramS_default);
//--------------------------------------------------//
FiS_default[DIAGRAM_FILL_STYLE_COLOR] = Color_getByRGB("#FFFFFF");
FiS_default[DIAGRAM_FILL_STYLE_INHERIT] = false;
Tabulation_setTableDiagramStyle(TableDiagram_ColumnHeader, TABLE_DIAGRAM_STYLE_FILL, FiS_default);
FoS_default[DIAGRAM_FONT_STYLE_BOLD] = true;
Tabulation_setTableDiagramStyle(TableDiagram_SignificanceCell, TABLE_DIAGRAM_STYLE_FONT, FoS_default);
Tabulation_setTableDiagramStyle(TableDiagram_SignificanceCell, TABLE_DIAGRAM_STYLE_HALIGN, "right");
Tabulation_setTableDiagramStyle(TableDiagram_ColumnHeaderLevel1, TABLE_DIAGRAM_STYLE_HALIGN, "center");
Tabulation_setTableDiagramStyle(TableDiagram_ColumnHeaderLevel2, TABLE_DIAGRAM_STYLE_HALIGN, "center");
Tabulation_setTableDiagramStyle(TableDiagram_SignificanceRowValue, TABLE_DIAGRAM_STYLE_HALIGN, "center");
object customBorderAllTable = new TabulationBorder("Top,Bottom,Left,Right", 0, "None", Color_getByRGB("#000000"));
Tabulation_setTableDiagramStyle(TableDiagram_AllTable, TABLE_DIAGRAM_STYLE_BORDER_STYLE, customBorderAllTable);
object customBorderHeaderLevel1 = new TabulationBorder("Bottom", 1, "Solid", Color_getByRGB("#000000"));
Tabulation_setTableDiagramStyle(TableDiagram_ColumnHeaderLevel1, TABLE_DIAGRAM_STYLE_BORDER_STYLE, customBorderHeaderLevel1);
object customBorderHeaderLevel2 = new TabulationBorder("Top,Bottom", 1, "Solid", Color_getByRGB("#000000"));
Tabulation_setTableDiagramStyle(TableDiagram_ColumnHeaderLevel2, TABLE_DIAGRAM_STYLE_BORDER_STYLE, customBorderHeaderLevel2);
object customBorderTotalRowValue = new TabulationBorder("Top", 1, "Solid", Color_getByRGB("#000000"));
Tabulation_setTableDiagramStyle(TableDiagram_TotalRowValue, TABLE_DIAGRAM_STYLE_BORDER_STYLE, customBorderTotalRowValue);
object customBorderSpacerCell = new TabulationBorder("All", 0, "None", Color_getByRGB("#000000"));
Tabulation_setTableDiagramStyle(TableDiagram_SpacerCell, TABLE_DIAGRAM_STYLE_BORDER_STYLE, customBorderSpacerCell);
Tabulation_setTableDiagramStyle(TableDiagram_AllTable, TABLE_DIAGRAM_STYLE_NUMBER_FORMATTER, "{0:##,#;(##,#)}");
Tabulation_setTableDiagramStyle(TableDiagram_AllTable, TABLE_DIAGRAM_STYLE_PERCENT_FORMATTER, "{0:##,#;(##,#)}");
Tabulation_setTableDiagramStyle(TableDiagram_AllTable, TABLE_DIAGRAM_STYLE_SIGNIFICANCE_FORMATTER, "{1}{0:+;-;,}");
createCrossDiagram({"QA1"},{"D_Age_Group"});
- After setting Table diagram style with source above
