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

Tabulation setTableDiagramStyle

From Catglobe Wiki
More actions



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


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