Toggle search
Toggle menu
875
3.8K
30.2K
279.1K
Catglobe Wiki
Toggle preferences menu
Toggle personal menu
Not logged in
Your IP address will be publicly visible if you make any edits.

Tabulation setTableDiagramStyle: Difference between revisions

From Catglobe Wiki
More actions
← Older editNewer edit →
Visual
No edit summary
No edit summary
Line 1: Line 1:
<br/>{{HelpFiles}}<br/><br/>===Tabulation_setTableDiagramStyle===<br/><br/>Sets the style for part of a chart.<br/><br/>===Syntax===<br/><br/>Tabulation_setTableDiagramStyle(styleType, tableDiagramStyle, argTableDiagramStyle);<br/><br/>===Arguments===<br/><br/>*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]<br/>*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]<br/>*argTableDiagramStyle: is argument for the given tableDiagramStyle<br/><br/>{| class="tableintopic" style="border-collapse: collapse;&nbsp; border: 1px solid rgb(1, 1, 1)" border="1" cellpadding="2" width="958"<br/>|- align="left" valign="top"<br/>| style="border: 1px solid #010101" bgcolor="#F59D56" width="227" |<br/>tableDiagramStyle<br/><br/>| style="border: 1px solid #010101" bgcolor="#F59D56" width="73" |<br/>Type<br/><br/>| style="border: 1px solid #010101" bgcolor="#F59D56" width="433" |<br/>Description<br/><br/>|-<br/>| colspan="1" style="border: 1px solid #010101" width="227" | TABLE_DIAGRAM_STYLE_FILL&lt;br/&gt;<br/>| style="border: 1px solid #010101" width="73" | array&lt;br/&gt;<br/>| style="border: 1px solid #010101" width="433" | Is the array of function [http://wiki.catglobe.com/index.php/DiagramFillStyle_getDefault DiagramFillStyle_getDefault]&lt;br/&gt;<br/>|-<br/>| colspan="1" style="border: 1px solid #010101" width="227" | TABLE_DIAGRAM_STYLE_DECIMAL&lt;br/&gt;<br/>| style="border: 1px solid #010101" width="174" | number&lt;br/&gt;<br/>| With min 0&lt;br/&gt;<br/>|-<br/>| colspan="1" style="border: 1px solid #010101" width="227" | TABLE_DIAGRAM_STYLE_FONT&lt;br/&gt;<br/>| style="border: 1px solid #010101" width="174" | array&lt;br/&gt;<br/>| Is the array of function [http://wiki.catglobe.com/index.php/DiagramFontStyle_getDefault DiagramFontStyle_getDefault]&lt;br/&gt;<br/>|-<br/>| colspan="1" style="border: 1px solid #010101" width="227" | TABLE_DIAGRAM_STYLE_VALIGN&lt;br/&gt;<br/>| style="border: 1px solid #010101" width="174" | string&lt;br/&gt;<br/>| takes string values of these Center, Top, Bottom&lt;br/&gt;<br/>|-<br/>| colspan="1" style="border: 1px solid #010101" width="227" | TABLE_DIAGRAM_STYLE_HALIGN&lt;br/&gt;<br/>| style="border: 1px solid #010101" width="174" | string&lt;br/&gt;<br/>| takes string values of these Center, Left, Right&lt;br/&gt;<br/>|-<br/>| colspan="1" style="border: 1px solid #010101" width="227" | TABLE_DIAGRAM_STYLE_NUMBER_FORMATTER&lt;br/&gt;<br/>| style="border: 1px solid #010101" width="174" | string&lt;br/&gt;<br/>| takes a string.format string, default is "{0:"+decimalplaces+"}"&lt;br/&gt;<br/>|-<br/>| colspan="1" style="border: 1px solid #010101" width="227" | TABLE_DIAGRAM_STYLE_PERCENT_FORMATTER&lt;br/&gt;<br/>| style="border: 1px solid #010101" width="174" | string&lt;br/&gt;<br/>| takes a string.format string, default is "{0:"+decimalplaces+"}%"&lt;br/&gt;<br/>|-<br/>| colspan="1" style="border: 1px solid #010101" width="227" | TABLE_DIAGRAM_STYLE_SIGNIFICANCE_FORMATTER&lt;br/&gt;<br/>| style="border: 1px solid #010101" width="174" | string&lt;br/&gt;<br/>| takes a string.format string, default is "{0:[+];[-];,} {1}"&lt;br/&gt;where 0 is int that is positive, negative or zero depending on significance and 1 is the Z value&lt;br/&gt;<br/>|-<br/>| colspan="1" style="border: 1px solid #010101" width="227" | TABLE_DIAGRAM_STYLE_BORDER_STYLE&lt;br/&gt;<br/>| style="border: 1px solid #010101" width="174" | object&lt;br/&gt;<br/>| takes a [http://wiki.catglobe.com/index.php/TabulationBorder_class Border object]&lt;br/&gt;<br/>|}<br/><br/>===Return type===<br/><br/>Empty<br/><br/>===Examples===<br/>*Before set Table diagram style<br/>[[File:Tabulation setTableDiagramStyle1.png|none|Tabulation setTableDiagramStyle1.png]]<br/><br/><br/>&lt;source lang="javascript"&gt;<br/>DCS_use(15507609);<br/>Tabulation_setTableLayout(TableChartLayout_Classic);<br/><br/>array FoS_default = DiagramFontStyle_getDefault(); //Gets a default chart font style object<br/>//Custom chart font style<br/>FoS_default[DIAGRAM_FONT_STYLE_COLOR] = Color_getByRGB("#000000");<br/>FoS_default[DIAGRAM_FONT_STYLE_FACE] = "Arial";<br/>FoS_default[DIAGRAM_FONT_STYLE_SIZE] = 10;<br/><br/>array FiS_default = DiagramFillStyle_getDefault(); //Gets a default chart fill style object<br/>//Custom chart fill style<br/>FiS_default[DIAGRAM_FILL_STYLE_COLOR] = Color_getByRGB("#f3f4f5");<br/><br/>Tabulation_setTableDiagramStyle(TableDiagram_AllTable, TABLE_DIAGRAM_STYLE_FONT, FoS_default); //Set custom chart font style<br/>Tabulation_setTableDiagramStyle(TableDiagram_AllTable, TABLE_DIAGRAM_STYLE_FILL, FiS_default); //Set custom chart fill style<br/>Tabulation_setTableDiagramStyle(TableDiagram_AllTable, TABLE_DIAGRAM_STYLE_VALIGN, "center"); //Vertical align the content inside<br/>Tabulation_setTableDiagramStyle(TableDiagram_AllTable, TABLE_DIAGRAM_STYLE_HALIGN, "right"); //Horizontal align the content inside<br/>Tabulation_setTableDiagramStyle(TableDiagram_AllTable, TABLE_DIAGRAM_STYLE_NUMBER_FORMATTER, "{0:#;minus #;zero}"); //Set number style format<br/>Tabulation_setTableDiagramStyle(TableDiagram_AllTable, TABLE_DIAGRAM_STYLE_PERCENT_FORMATTER, "{0:#;minus #;zero}pct"); //Set percent style format<br/>Tabulation_setTableDiagramStyle(TableDiagram_AllTable, TABLE_DIAGRAM_STYLE_SIGNIFICANCE_FORMATTER, "{1}{0:+;-;,}"); //Set significance style format<br/><br/>createCrossDiagram({"QA1"},{"D_Age_Group"});<br/>&lt;/source&gt;<br/><br/>*After setting Table diagram style with source above<br/>[[File:Tabulation setTableDiagramStyle2.png|none|Tabulation setTableDiagramStyle2.png]]<br/><br/><br/><br/><br/>&lt;source lang="javascript"&gt;<br/>DCS_use(15507609);<br/>Tabulation_setTableLayout(TableChartLayout_Classic);<br/>array FoS_header = DiagramFontStyle_getDefault();<br/>FoS_header[DIAGRAM_FONT_STYLE_COLOR] = Color_getByRGB("#307D7E");<br/><br/>array FiS_header = DiagramFillStyle_getDefault();<br/>FiS_header[DIAGRAM_FILL_STYLE_COLOR] =&nbsp; Color_getByRGB("#AF7817");<br/><br/>Tabulation_setTableDiagramStyle(TableDiagram_ColumnHeaderLevel1, TABLE_DIAGRAM_STYLE_FONT, FoS_header);<br/>Tabulation_setTableDiagramStyle(TableDiagram_ColumnHeaderLevel1, TABLE_DIAGRAM_STYLE_FILL, FiS_header);<br/>Tabulation_setTableDiagramStyle(TableDiagram_ColumnHeaderLevel1, TABLE_DIAGRAM_STYLE_HALIGN, "center");<br/>Tabulation_setTableDiagramStyle(TableDiagram_ColumnHeaderLevel2, TABLE_DIAGRAM_STYLE_BORDER_STYLE, new TabulationBorder("Top,Bottom", 2, "Solid", Color_getByRGB("#000000")));<br/>Tabulation_setTableDiagramStyle(TableDiagram_AbsoluteColumn, TABLE_DIAGRAM_STYLE_FONT, FoS_header);<br/>Tabulation_setTableDiagramStyle(TableDiagram_AbsoluteColumn, TABLE_DIAGRAM_STYLE_FILL, FiS_header);<br/>Tabulation_setTableDiagramStyle(TableDiagram_AbsoluteColumn, TABLE_DIAGRAM_STYLE_HALIGN, "center");<br/><br/><br/>//-----------------------------<br/>Tabulation_setTableDiagramStyle(TableDiagram_AbsoluteColumnValue, TABLE_DIAGRAM_STYLE_DECIMAL, 0);<br/>//-----------------------------<br/>FiS_header[DIAGRAM_FILL_STYLE_COLOR] = Color_getByRGB("#387C44");<br/>Tabulation_setTableDiagramStyle(TableDiagram_ColumnHeaderLevel2, TABLE_DIAGRAM_STYLE_DECIMAL, 1);<br/>Tabulation_setTableDiagramStyle(TableDiagram_ColumnHeaderLevel2, TABLE_DIAGRAM_STYLE_FILL, FiS_header);<br/>Tabulation_setTableDiagramStyle(TableDiagram_PercentageColumn, TABLE_DIAGRAM_STYLE_DECIMAL, 1);<br/>Tabulation_setTableDiagramStyle(TableDiagram_PercentageColumn, TABLE_DIAGRAM_STYLE_FILL, FiS_header);<br/><br/>///////////////////////////////////////////////////////////////<br/>array FoS_default = DiagramFontStyle_getDefault();<br/>FoS_default[DIAGRAM_FONT_STYLE_BOLD] = true; &nbsp;<br/>Tabulation_setTableDiagramStyle(TableDiagram_SignificanceCell, TABLE_DIAGRAM_STYLE_FONT, FoS_default);<br/>TabulationBorder tb = new TabulationBorder("Left", 2, "Solid", Color_getByRGB("#303030"));<br/>Tabulation_setTableDiagramStyle(TableDiagram_SignificanceCell, TABLE_DIAGRAM_STYLE_BORDER_STYLE, tb);<br/><br/>array FiS_default = DiagramFillStyle_getDefault();<br/>FoS_default[DIAGRAM_FONT_STYLE_BOLD] = false; &nbsp;<br/>FoS_default[DIAGRAM_FONT_STYLE_COLOR] = Color_getByRGB("#000000");<br/>FiS_default[DIAGRAM_FILL_STYLE_COLOR] = Color_getByRGB("#307D7E");<br/>Tabulation_setTableDiagramStyle(TableDiagram_SignificanceRow, TABLE_DIAGRAM_STYLE_FONT, FoS_default);<br/>Tabulation_setTableDiagramStyle(TableDiagram_SignificanceRow, TABLE_DIAGRAM_STYLE_FILL, FiS_default);<br/><br/>createCrossDiagram({"QA1"},{"D_Age_Group"});<br/>&lt;/source&gt;<br/><br/><br/><br/>*After setting Table diagram style with source above<br/>[[File:SetTableDiagramStyle3.png|none|SetTableDiagramStyle3.png]]<br/>__NOTOC__
{{HelpFiles}}
 
=== Tabulation_setTableDiagramStyle ===
 
Sets the style for 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 [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 [http://wiki.catglobe.com/index.php/CGS_Constants_list#Table_Diagram_style_constants Table Diagram style constants]
*argTableDiagramStyle: is argument for the given tableDiagramStyle
 
{| class="tableintopic" style="border-collapse: collapse; border: 1px solid rgb(1, 1, 1)" border="1" cellpadding="2" width="958"
|- align="left" valign="top"
| style="border: 1px solid #010101" bgcolor="#F59D56" width="227" |  
tableDiagramStyle
 
| style="border: 1px solid #010101" bgcolor="#F59D56" width="73" |
Type
 
| style="border: 1px solid #010101" bgcolor="#F59D56" width="433" |  
Description
 
|-
| colspan="1" style="border: 1px solid #010101" width="227" | TABLE_DIAGRAM_STYLE_FILL<br/>
| style="border: 1px solid #010101" width="73" | array<br/>
| style="border: 1px solid #010101" width="433" | Is the array of function [http://wiki.catglobe.com/index.php/DiagramFillStyle_getDefault DiagramFillStyle_getDefault]<br/>
|-
| colspan="1" style="border: 1px solid #010101" width="227" | TABLE_DIAGRAM_STYLE_DECIMAL<br/>
| style="border: 1px solid #010101" width="174" | number<br/>
| With min 0<br/>
|-
| colspan="1" style="border: 1px solid #010101" width="227" | TABLE_DIAGRAM_STYLE_FONT<br/>
| style="border: 1px solid #010101" width="174" | array<br/>
| Is the array of function [http://wiki.catglobe.com/index.php/DiagramFontStyle_getDefault DiagramFontStyle_getDefault]<br/>
|-
| colspan="1" style="border: 1px solid #010101" width="227" | TABLE_DIAGRAM_STYLE_VALIGN<br/>
| style="border: 1px solid #010101" width="174" | string<br/>
| takes string values of these Center, Top, Bottom<br/>
|-
| colspan="1" style="border: 1px solid #010101" width="227" | TABLE_DIAGRAM_STYLE_HALIGN<br/>
| style="border: 1px solid #010101" width="174" | string<br/>
| takes string values of these Center, Left, Right<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/>
| takes a string.format string, default is "{0:"+decimalplaces+"}"<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/>
| takes a string.format string, default is "{0:"+decimalplaces+"}%"<br/>
|-
| colspan="1" style="border: 1px solid #010101" width="227" | TABLE_DIAGRAM_STYLE_SIGNIFICANCE_FORMATTER<br/>
| style="border: 1px solid #010101" width="174" | string<br/>
| takes a string.format string, default is "{0:[+];[-];,} {1}"<br/>where 0 is int that is positive, negative or zero depending on significance and 1 is the Z value<br/>
|-
| colspan="1" style="border: 1px solid #010101" width="227" | TABLE_DIAGRAM_STYLE_BORDER_STYLE<br/>
| style="border: 1px solid #010101" width="174" | object<br/>
| takes a [http://wiki.catglobe.com/index.php/TabulationBorder_class Border object]<br/>
|}
 
=== Return type ===
 
Empty
 
=== Examples ===
 
*Before set Table diagram style
 
[[File:Tabulation setTableDiagramStyle1.png|none|Tabulation setTableDiagramStyle1.png]]
 
<br/><source lang="javascript">
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"});
</source>
 
*After setting Table diagram style with source above
 
[[File:Tabulation setTableDiagramStyle2.png|none|Tabulation setTableDiagramStyle2.png]]
 
 
 
<br/><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");
Tabulation_setTableDiagramStyle(TableDiagram_ColumnHeaderLevel2, TABLE_DIAGRAM_STYLE_BORDER_STYLE, new TabulationBorder("Top,Bottom", 2, "Solid", Color_getByRGB("#000000")));
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|SetTableDiagramStyle3.png]]
 
 
 
<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");
 
Tabulation_setTableDiagramStyle(TableDiagram_AllTable, TABLE_DIAGRAM_STYLE_BORDER_STYLE, new TabulationBorder("Top,Bottom,Left,Right", 0, "None", Color_getByRGB("#000000")));
Tabulation_setTableDiagramStyle(TableDiagram_ColumnHeaderLevel1, TABLE_DIAGRAM_STYLE_BORDER_STYLE, new TabulationBorder("Bottom", 1, "Solid", Color_getByRGB("#000000")));
Tabulation_setTableDiagramStyle(TableDiagram_ColumnHeaderLevel2, TABLE_DIAGRAM_STYLE_BORDER_STYLE, new TabulationBorder("Top,Bottom", 1, "Solid", Color_getByRGB("#000000")));
Tabulation_setTableDiagramStyle(TableDiagram_TotalRowValue, TABLE_DIAGRAM_STYLE_BORDER_STYLE, new TabulationBorder("Top", 1, "Solid", Color_getByRGB("#000000")));
Tabulation_setTableDiagramStyle(TableDiagram_SpacerCell, TABLE_DIAGRAM_STYLE_BORDER_STYLE, new TabulationBorder("All", 0, "None", Color_getByRGB("#000000")));
 
 
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|SetTableDiagramStyle4.png]]
 
__NOTOC__

Revision as of 02:35, 8 December 2015


Tabulation_setTableDiagramStyle

Sets the style for 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, 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+"}"
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

  • Before set Table diagram style
Tabulation setTableDiagramStyle1.png
Tabulation setTableDiagramStyle1.png


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
Tabulation setTableDiagramStyle2.png
Tabulation setTableDiagramStyle2.png



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");
Tabulation_setTableDiagramStyle(TableDiagram_ColumnHeaderLevel2, TABLE_DIAGRAM_STYLE_BORDER_STYLE, new TabulationBorder("Top,Bottom", 2, "Solid", Color_getByRGB("#000000")));
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
SetTableDiagramStyle3.png
SetTableDiagramStyle3.png


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");

Tabulation_setTableDiagramStyle(TableDiagram_AllTable, TABLE_DIAGRAM_STYLE_BORDER_STYLE, new TabulationBorder("Top,Bottom,Left,Right", 0, "None", Color_getByRGB("#000000")));
Tabulation_setTableDiagramStyle(TableDiagram_ColumnHeaderLevel1, TABLE_DIAGRAM_STYLE_BORDER_STYLE, new TabulationBorder("Bottom", 1, "Solid", Color_getByRGB("#000000")));
Tabulation_setTableDiagramStyle(TableDiagram_ColumnHeaderLevel2, TABLE_DIAGRAM_STYLE_BORDER_STYLE, new TabulationBorder("Top,Bottom", 1, "Solid", Color_getByRGB("#000000")));
Tabulation_setTableDiagramStyle(TableDiagram_TotalRowValue, TABLE_DIAGRAM_STYLE_BORDER_STYLE, new TabulationBorder("Top", 1, "Solid", Color_getByRGB("#000000")));
Tabulation_setTableDiagramStyle(TableDiagram_SpacerCell, TABLE_DIAGRAM_STYLE_BORDER_STYLE, new TabulationBorder("All", 0, "None", Color_getByRGB("#000000")));


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
SetTableDiagramStyle4.png
SetTableDiagramStyle4.png


Retrieved from "https://wiki.catglobe.com/index.php?title=Tabulation_setTableDiagramStyle&oldid=25302"