More actions
Cg huyphong (talk | contribs) No edit summary |
No edit summary |
||
Line 1: | Line 1: | ||
{{HelpFiles}} | |||
{{HelpFiles}} | |||
=====Tabulation_setDiagramStyle===== | ===== Tabulation_setDiagramStyle ===== | ||
Sets the style for part of a chart. | Sets the style for part of a chart. | ||
'''Syntax''' | '''Syntax''' | ||
Tabulation_setDiagramStyle(''styleType, diagramStyle'') | Tabulation_setDiagramStyle(''styleType, diagramStyle'') | ||
'''Arguments''' | '''Arguments''' | ||
''styleType'': enumeration for the part of a chart you want to set. Below is the full list of chart style type enumerations: | ''styleType'': enumeration for the part of a chart you want to set. Below is the full list of chart style type enumerations: | ||
TableDiagram_AllTable = 0 | TableDiagram_AllTable = 0 | ||
TableDiagram_ColumnHeader = 1 | TableDiagram_ColumnHeader = 1 | ||
TableDiagram_ColumnHeaderLevel1 = 2 | TableDiagram_ColumnHeaderLevel1 = 2 | ||
TableDiagram_ColumnHeaderLevel2 = 3 | TableDiagram_ColumnHeaderLevel2 = 3 | ||
TableDiagram_ColumnHeaderLevel3 = 4 | TableDiagram_ColumnHeaderLevel3 = 4 | ||
TableDiagram_ColumnHeaderLevel4 = 5 | TableDiagram_ColumnHeaderLevel4 = 5 | ||
TableDiagram_RowHeader = 6 | TableDiagram_RowHeader = 6 | ||
TableDiagram_RowHeaderLevel1 = 7 | TableDiagram_RowHeaderLevel1 = 7 | ||
TableDiagram_RowHeaderLevel2 = 8 | TableDiagram_RowHeaderLevel2 = 8 | ||
TableDiagram_RowHeaderLevel3 = 9 | TableDiagram_RowHeaderLevel3 = 9 | ||
TableDiagram_AnswerRow = 10 | TableDiagram_AnswerRow = 10 | ||
TableDiagram_AnswerRowAlternate = 11 | TableDiagram_AnswerRowAlternate = 11 | ||
TableDiagram_AbsoluteColumn = 12 | TableDiagram_AbsoluteColumn = 12 | ||
TableDiagram_AbsoluteColumnHeader = 13 | TableDiagram_AbsoluteColumnHeader = 13 | ||
TableDiagram_AbsoluteColumnValue = 14 | TableDiagram_AbsoluteColumnValue = 14 | ||
TableDiagram_PercentageColumn = 15 | TableDiagram_PercentageColumn = 15 | ||
TableDiagram_PercentageColumnHeader = 16 | TableDiagram_PercentageColumnHeader = 16 | ||
TableDiagram_PercentageColumnValue = 17 | TableDiagram_PercentageColumnValue = 17 | ||
TableDiagram_TotalColumn = 18 | TableDiagram_TotalColumn = 18 | ||
TableDiagram_TotalColumnHeader = 19 | TableDiagram_TotalColumnHeader = 19 | ||
TableDiagram_TotalColumnValue = 20 | TableDiagram_TotalColumnValue = 20 | ||
TableDiagram_TotalRow = 21 | TableDiagram_TotalRow = 21 | ||
TableDiagram_TotalRowHeader = 22 | TableDiagram_TotalRowHeader = 22 | ||
TableDiagram_TotalRowValue = 23 | TableDiagram_TotalRowValue = 23 | ||
TableDiagram_VarianceRow = 24 | TableDiagram_VarianceRow = 24 | ||
TableDiagram_VarianceRowHeader = 25 | TableDiagram_VarianceRowHeader = 25 | ||
TableDiagram_VarianceRowValue = 26 | TableDiagram_VarianceRowValue = 26 | ||
TableDiagram_AverageRow = 27 | TableDiagram_AverageRow = 27 | ||
TableDiagram_AverageRowHeader = 28 | TableDiagram_AverageRowHeader = 28 | ||
TableDiagram_AverageRowValue = 29 | TableDiagram_AverageRowValue = 29 | ||
TableDiagram_StdDevRow = 30 | TableDiagram_StdDevRow = 30 | ||
TableDiagram_StdDevRowHeader = 31 | TableDiagram_StdDevRowHeader = 31 | ||
TableDiagram_StdDevRowValue = 32 | TableDiagram_StdDevRowValue = 32 | ||
TableDiagram_StdErrorRow = 33 | TableDiagram_StdErrorRow = 33 | ||
TableDiagram_StdErrorRowHeader = 34 | TableDiagram_StdErrorRowHeader = 34 | ||
TableDiagram_StdErrorRowValue = 35 | TableDiagram_StdErrorRowValue = 35 | ||
TableDiagram_MedianRow = 36 | TableDiagram_MedianRow = 36 | ||
TableDiagram_MedianRowHeader = 37 | TableDiagram_MedianRowHeader = 37 | ||
TableDiagram_MedianRowValue = 38 | TableDiagram_MedianRowValue = 38 | ||
TableDiagram_QuantilesRow = 39 | TableDiagram_QuantilesRow = 39 | ||
TableDiagram_QuantilesRowHeader = 40 | TableDiagram_QuantilesRowHeader = 40 | ||
TableDiagram_QuantilesRowValue = 41 | TableDiagram_QuantilesRowValue = 41 | ||
TableDiagram_PercentileRow = 42 | TableDiagram_PercentileRow = 42 | ||
TableDiagram_PercentileRowHeader = 43 | TableDiagram_PercentileRowHeader = 43 | ||
TableDiagram_PercentileRowValue = 44 | TableDiagram_PercentileRowValue = 44 | ||
TableDiagram_SignificanceRow = 45 | TableDiagram_SignificanceRow = 45 | ||
TableDiagram_SignificanceRowHeader = 46 | TableDiagram_SignificanceRowHeader = 46 | ||
TableDiagram_SignificanceRowValue = 47 | TableDiagram_SignificanceRowValue = 47 | ||
TableDiagram_CountAnswerRow = 48 | TableDiagram_CountAnswerRow = 48 | ||
TableDiagram_CountAnswerRowHeader = 49 | TableDiagram_CountAnswerRowHeader = 49 | ||
TableDiagram_CountAnswerRowValue = 50 | TableDiagram_CountAnswerRowValue = 50 | ||
TableDiagram_TotalRespondentRow = 51 | TableDiagram_TotalRespondentRow = 51 | ||
TableDiagram_TotalRespondentRowHeader = 52 | TableDiagram_TotalRespondentRowHeader = 52 | ||
TableDiagram_TotalRespondentRowValue = 53 | TableDiagram_TotalRespondentRowValue = 53 | ||
''diagramStyle'': diagram style object want to apply. It is an array with the following constants. | ''diagramStyle'': diagram style object want to apply. It is an array with the following constants. | ||
{| class="tableintopic" style="border-collapse: collapse; border: 1px solid | {| cellpadding="2" border="1" width="907" class="tableintopic" style="border-collapse: collapse; border: 1px solid rgb(1, 1, 1);" | ||
|- align="left" valign="top" | |- align="left" valign="top" | ||
| | | bgcolor="#f59d56" width="227" style="border: 1px solid rgb(1, 1, 1);" | | ||
Constant | Constant | ||
| | |||
Type | | bgcolor="#f59d56" width="73" style="border: 1px solid rgb(1, 1, 1);" | | ||
| | Type | ||
Initial/Default value | |||
| | | bgcolor="#f59d56" width="174" style="border: 1px solid rgb(1, 1, 1);" | | ||
Description | Initial/Default value | ||
| bgcolor="#f59d56" width="433" style="border: 1px solid rgb(1, 1, 1);" | | |||
Description | |||
|- align="left" valign="top" | |- align="left" valign="top" | ||
| style="border: 1px solid | | width="227" style="border: 1px solid rgb(1, 1, 1);" | | ||
OBJECT_TYPE | OBJECT_TYPE | ||
| style="border: 1px solid | |||
Number | | width="73" style="border: 1px solid rgb(1, 1, 1);" | | ||
| style="border: 1px solid | Number | ||
21 | |||
| style="border: 1px solid | | width="174" style="border: 1px solid rgb(1, 1, 1);" | | ||
Enumeration defining the object type. | 21 | ||
| width="433" style="border: 1px solid rgb(1, 1, 1);" | | |||
Enumeration defining the object type. | |||
|- align="left" valign="top" | |- align="left" valign="top" | ||
| style="border: 1px solid | | width="227" style="border: 1px solid rgb(1, 1, 1);" | | ||
TABLE_DIAGRAM_STYLE_FILL | TABLE_DIAGRAM_STYLE_FILL | ||
| style="border: 1px solid | |||
Array | | width="73" style="border: 1px solid rgb(1, 1, 1);" | | ||
| style="border: 1px solid | Array | ||
As set in the object | |||
| style="border: 1px solid | | width="174" style="border: 1px solid rgb(1, 1, 1);" | | ||
Fill style. Background color. | As set in the object | ||
| width="433" style="border: 1px solid rgb(1, 1, 1);" | | |||
Fill style. Background color. | |||
|- align="left" valign="top" | |- align="left" valign="top" | ||
| style="border: 1px solid | | width="227" style="border: 1px solid rgb(1, 1, 1);" | | ||
TABLE_DIAGRAM_STYLE_DECIMAL | TABLE_DIAGRAM_STYLE_DECIMAL | ||
| style="border: 1px solid | |||
Number | | width="73" style="border: 1px solid rgb(1, 1, 1);" | | ||
| style="border: 1px solid | Number | ||
As set in the object | |||
| style="border: 1px solid | | width="174" style="border: 1px solid rgb(1, 1, 1);" | | ||
Decimal place. | As set in the object | ||
| width="433" style="border: 1px solid rgb(1, 1, 1);" | | |||
Decimal place. | |||
|- align="left" valign="top" | |- align="left" valign="top" | ||
| style="border: 1px solid | | width="227" style="border: 1px solid rgb(1, 1, 1);" | | ||
TABLE_DIAGRAM_STYLE_FONT | TABLE_DIAGRAM_STYLE_FONT | ||
| style="border: 1px solid | |||
Array | | width="73" style="border: 1px solid rgb(1, 1, 1);" | | ||
| style="border: 1px solid | Array | ||
As set in the object | |||
| style="border: 1px solid | | width="174" style="border: 1px solid rgb(1, 1, 1);" | | ||
Font. | As set in the object | ||
| width="433" style="border: 1px solid rgb(1, 1, 1);" | | |||
Font. | |||
|- align="left" valign="top" | |- align="left" valign="top" | ||
| style="border: 1px solid | | width="227" style="border: 1px solid rgb(1, 1, 1);" | | ||
TABLE_DIAGRAM_STYLE_VALIGN | TABLE_DIAGRAM_STYLE_VALIGN | ||
| style="border: 1px solid | |||
String | | width="73" style="border: 1px solid rgb(1, 1, 1);" | | ||
| style="border: 1px solid | String | ||
As set in the object | |||
| style="border: 1px solid | | width="174" style="border: 1px solid rgb(1, 1, 1);" | | ||
Vertical alignment (allows values "top", "center", or "bottom"). | As set in the object | ||
| width="433" style="border: 1px solid rgb(1, 1, 1);" | | |||
Vertical alignment (allows values "top", "center", or "bottom"). | |||
|- align="left" valign="top" | |- align="left" valign="top" | ||
| style="border: 1px solid | | width="227" style="border: 1px solid rgb(1, 1, 1);" | | ||
TABLE_DIAGRAM_STYLE_HALIGN | TABLE_DIAGRAM_STYLE_HALIGN | ||
| style="border: 1px solid | |||
String | | width="73" style="border: 1px solid rgb(1, 1, 1);" | | ||
| style="border: 1px solid | String | ||
As set in the object | |||
| style="border: 1px solid | | width="174" style="border: 1px solid rgb(1, 1, 1);" | | ||
Horizontal alignment (allows values "left", "center", or "right"). | As set in the object | ||
| width="433" style="border: 1px solid rgb(1, 1, 1);" | | |||
Horizontal alignment (allows values "left", "center", or "right"). | |||
|} | |||
'''Return type''' | |||
Empty | |||
'''Examples''' | |||
''Tabulation_setTableLayout(TableChartLayout_Ifka);'' | |||
''Tabulation_setAbsText("abs");'' | |||
''Tabulation_setPctText("%");'' | |||
''Tabulation_setCountAnswer(true);'' | |||
''Tabulation_setTotalAnswerText("Total sample size");'' | |||
''Tabulation_setEnableOddEvenRowHeader(true);'' | |||
''Tabulation_setMergeStatisticPctItem(true);'' | |||
'''''//set values for Abs column''''' | |||
''array font = {18,"Times New Roman",9,{17,0,0,0},false,false,false,true};'' | |||
''array fill_AbsCol = {19,{17,0,0,0},2,true};'' | |||
''string valign = "center";'' | |||
''string halign_AbsCol = "right";'' | |||
''number decimal = 0;'' | |||
''array diagramStyle_AbsCol={21,fill_AbsCol,decimal,font,valign,halign_AbsCol};'' | |||
''Tabulation_setDiagramStyle(TableDiagram_AbsoluteColumn,diagramStyle_AbsCol);'' | |||
'''''//set values for Count Answer Row''''' | |||
''array font_CountAnswer = {18,"Times New Roman",9,{17,0,0,0},true,false,false,false};'' | |||
''string halign_CountAnswer = "left";'' | |||
''array diagramStyle_CountAnswer ={21,fill_AbsCol,decimal,font_CountAnswer,valign,halign_CountAnswer};'' | |||
''Tabulation_setDiagramStyle(TableDiagram_CountAnswerRow,diagramStyle_CountAnswer);'' | |||
'''''//set values for Headers column''''' | |||
''array font_Header = DiagramFontStyle_getDefault(); '' | |||
''font_Header[DIAGRAM_FONT_STYLE_COLOR] = Color_getByRGB("#000000");'' | |||
'' | ''font_Header[DIAGRAM_FONT_STYLE_FACE] = "Times New Roman"; '' | ||
''font_Header[DIAGRAM_FONT_STYLE_SIZE] = 9 ; '' | |||
'' | ''array fill_style = DiagramFillStyle_getDefault(); '' | ||
''array style_header = Tabulation_getDefaultDiagramStyle(Diagram_Type_Table); '' | |||
''style_header[TABLE_DIAGRAM_STYLE_FILL] = fill_style; '' | |||
''style_header[TABLE_DIAGRAM_STYLE_FONT] = font_Header; '' | |||
''style_header[TABLE_DIAGRAM_STYLE_VALIGN] = "center";'' | |||
''style_header[TABLE_DIAGRAM_STYLE_HALIGN] = "center";'' | |||
''Tabulation_setDiagramStyle(TableDiagram_ColumnHeaderLevel2, style_header);'' | |||
''Tabulation_setDiagramStyle(TableDiagram_AbsoluteColumnHeader, style_header);'' | |||
''Tabulation_setDiagramStyle(TableDiagram_PercentageColumnHeader, style_header);'' | |||
''createFrequenceDiagram("Civil_status");'' | |||
[[Image:SetDiagramStyle.jpg]] | |||
'''Availability''' | |||
Version 5.8.1 __NOTOC__ <!-- imported from file: 8101.htm--> | |||
[[Category:Style_setting_functions]] | |||
Revision as of 11:19, 30 December 2011
Tabulation_setDiagramStyle
Sets the style for part of a chart.
Syntax
Tabulation_setDiagramStyle(styleType, diagramStyle)
Arguments
styleType: enumeration for the part of a chart you want to set. Below is the full list of chart style type enumerations:
TableDiagram_AllTable = 0
TableDiagram_ColumnHeader = 1
TableDiagram_ColumnHeaderLevel1 = 2
TableDiagram_ColumnHeaderLevel2 = 3
TableDiagram_ColumnHeaderLevel3 = 4
TableDiagram_ColumnHeaderLevel4 = 5
TableDiagram_RowHeader = 6
TableDiagram_RowHeaderLevel1 = 7
TableDiagram_RowHeaderLevel2 = 8
TableDiagram_RowHeaderLevel3 = 9
TableDiagram_AnswerRow = 10
TableDiagram_AnswerRowAlternate = 11
TableDiagram_AbsoluteColumn = 12
TableDiagram_AbsoluteColumnHeader = 13
TableDiagram_AbsoluteColumnValue = 14
TableDiagram_PercentageColumn = 15
TableDiagram_PercentageColumnHeader = 16
TableDiagram_PercentageColumnValue = 17
TableDiagram_TotalColumn = 18
TableDiagram_TotalColumnHeader = 19
TableDiagram_TotalColumnValue = 20
TableDiagram_TotalRow = 21
TableDiagram_TotalRowHeader = 22
TableDiagram_TotalRowValue = 23
TableDiagram_VarianceRow = 24
TableDiagram_VarianceRowHeader = 25
TableDiagram_VarianceRowValue = 26
TableDiagram_AverageRow = 27
TableDiagram_AverageRowHeader = 28
TableDiagram_AverageRowValue = 29
TableDiagram_StdDevRow = 30
TableDiagram_StdDevRowHeader = 31
TableDiagram_StdDevRowValue = 32
TableDiagram_StdErrorRow = 33
TableDiagram_StdErrorRowHeader = 34
TableDiagram_StdErrorRowValue = 35
TableDiagram_MedianRow = 36
TableDiagram_MedianRowHeader = 37
TableDiagram_MedianRowValue = 38
TableDiagram_QuantilesRow = 39
TableDiagram_QuantilesRowHeader = 40
TableDiagram_QuantilesRowValue = 41
TableDiagram_PercentileRow = 42
TableDiagram_PercentileRowHeader = 43
TableDiagram_PercentileRowValue = 44
TableDiagram_SignificanceRow = 45
TableDiagram_SignificanceRowHeader = 46
TableDiagram_SignificanceRowValue = 47
TableDiagram_CountAnswerRow = 48
TableDiagram_CountAnswerRowHeader = 49
TableDiagram_CountAnswerRowValue = 50
TableDiagram_TotalRespondentRow = 51
TableDiagram_TotalRespondentRowHeader = 52
TableDiagram_TotalRespondentRowValue = 53
diagramStyle: diagram style object want to apply. It is an array with the following constants.
Constant |
Type |
Initial/Default value |
Description |
OBJECT_TYPE |
Number |
21 |
Enumeration defining the object type. |
TABLE_DIAGRAM_STYLE_FILL |
Array |
As set in the object |
Fill style. Background color. |
TABLE_DIAGRAM_STYLE_DECIMAL |
Number |
As set in the object |
Decimal place. |
TABLE_DIAGRAM_STYLE_FONT |
Array |
As set in the object |
Font. |
TABLE_DIAGRAM_STYLE_VALIGN |
String |
As set in the object |
Vertical alignment (allows values "top", "center", or "bottom"). |
TABLE_DIAGRAM_STYLE_HALIGN |
String |
As set in the object |
Horizontal alignment (allows values "left", "center", or "right"). |
Return type
Empty
Examples
Tabulation_setTableLayout(TableChartLayout_Ifka);
Tabulation_setAbsText("abs");
Tabulation_setPctText("%");
Tabulation_setCountAnswer(true);
Tabulation_setTotalAnswerText("Total sample size");
Tabulation_setEnableOddEvenRowHeader(true);
Tabulation_setMergeStatisticPctItem(true);
//set values for Abs column
array font = {18,"Times New Roman",9,{17,0,0,0},false,false,false,true};
array fill_AbsCol = {19,{17,0,0,0},2,true};
string valign = "center";
string halign_AbsCol = "right";
number decimal = 0;
array diagramStyle_AbsCol={21,fill_AbsCol,decimal,font,valign,halign_AbsCol};
Tabulation_setDiagramStyle(TableDiagram_AbsoluteColumn,diagramStyle_AbsCol);
//set values for Count Answer Row
array font_CountAnswer = {18,"Times New Roman",9,{17,0,0,0},true,false,false,false};
string halign_CountAnswer = "left";
array diagramStyle_CountAnswer ={21,fill_AbsCol,decimal,font_CountAnswer,valign,halign_CountAnswer};
Tabulation_setDiagramStyle(TableDiagram_CountAnswerRow,diagramStyle_CountAnswer);
//set values for Headers column
array font_Header = DiagramFontStyle_getDefault();
font_Header[DIAGRAM_FONT_STYLE_COLOR] = Color_getByRGB("#000000");
font_Header[DIAGRAM_FONT_STYLE_FACE] = "Times New Roman";
font_Header[DIAGRAM_FONT_STYLE_SIZE] = 9 ;
array fill_style = DiagramFillStyle_getDefault();
array style_header = Tabulation_getDefaultDiagramStyle(Diagram_Type_Table);
style_header[TABLE_DIAGRAM_STYLE_FILL] = fill_style;
style_header[TABLE_DIAGRAM_STYLE_FONT] = font_Header;
style_header[TABLE_DIAGRAM_STYLE_VALIGN] = "center";
style_header[TABLE_DIAGRAM_STYLE_HALIGN] = "center";
Tabulation_setDiagramStyle(TableDiagram_ColumnHeaderLevel2, style_header);
Tabulation_setDiagramStyle(TableDiagram_AbsoluteColumnHeader, style_header);
Tabulation_setDiagramStyle(TableDiagram_PercentageColumnHeader, style_header);
createFrequenceDiagram("Civil_status");
Availability
Version 5.8.1