Toggle menu
876
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 setDiagramStyle: Difference between revisions

From Catglobe Wiki
No edit summary
Cg van (talk | contribs)
No edit summary
Line 1: Line 1:
[[Category:Style setting functions]]
{{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 #010101" width="907" border="1" cellpadding="2"
{| 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"
| style="border: 1px solid #010101" width="227" bgcolor="#F59D56" |
| bgcolor="#f59d56" width="227" style="border: 1px solid rgb(1, 1, 1);" |  
Constant
Constant  
| style="border: 1px solid #010101" width="73" bgcolor="#F59D56" |
 
Type
| bgcolor="#f59d56" width="73" style="border: 1px solid rgb(1, 1, 1);" |  
| style="border: 1px solid #010101" width="174" bgcolor="#F59D56" |
Type  
Initial/Default value
 
| style="border: 1px solid #010101" width="433" bgcolor="#F59D56" |
| 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 #010101" width="227" |
| width="227" style="border: 1px solid rgb(1, 1, 1);" |  
OBJECT_TYPE
OBJECT_TYPE  
| style="border: 1px solid #010101" width="73" |
 
Number
| width="73" style="border: 1px solid rgb(1, 1, 1);" |  
| style="border: 1px solid #010101" width="174" |
Number  
21
 
| style="border: 1px solid #010101" width="433" |
| 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 #010101" width="227" |
| width="227" style="border: 1px solid rgb(1, 1, 1);" |  
TABLE_DIAGRAM_STYLE_FILL
TABLE_DIAGRAM_STYLE_FILL  
| style="border: 1px solid #010101" width="73" |
 
Array
| width="73" style="border: 1px solid rgb(1, 1, 1);" |  
| style="border: 1px solid #010101" width="174" |
Array  
As set in the object
 
| style="border: 1px solid #010101" width="433" |
| 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 #010101" width="227" |
| width="227" style="border: 1px solid rgb(1, 1, 1);" |  
TABLE_DIAGRAM_STYLE_DECIMAL
TABLE_DIAGRAM_STYLE_DECIMAL  
| style="border: 1px solid #010101" width="73" |
 
Number
| width="73" style="border: 1px solid rgb(1, 1, 1);" |  
| style="border: 1px solid #010101" width="174" |
Number  
As set in the object
 
| style="border: 1px solid #010101" width="433" |
| 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 #010101" width="227" |
| width="227" style="border: 1px solid rgb(1, 1, 1);" |  
TABLE_DIAGRAM_STYLE_FONT
TABLE_DIAGRAM_STYLE_FONT  
| style="border: 1px solid #010101" width="73" |
 
Array
| width="73" style="border: 1px solid rgb(1, 1, 1);" |  
| style="border: 1px solid #010101" width="174" |
Array  
As set in the object
 
| style="border: 1px solid #010101" width="433" |
| 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 #010101" width="227" |
| width="227" style="border: 1px solid rgb(1, 1, 1);" |  
TABLE_DIAGRAM_STYLE_VALIGN
TABLE_DIAGRAM_STYLE_VALIGN  
| style="border: 1px solid #010101" width="73" |
 
String
| width="73" style="border: 1px solid rgb(1, 1, 1);" |  
| style="border: 1px solid #010101" width="174" |
String  
As set in the object
 
| style="border: 1px solid #010101" width="433" |
| 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 #010101" width="227" |
| width="227" style="border: 1px solid rgb(1, 1, 1);" |  
TABLE_DIAGRAM_STYLE_HALIGN
TABLE_DIAGRAM_STYLE_HALIGN  
| style="border: 1px solid #010101" width="73" |
 
String
| width="73" style="border: 1px solid rgb(1, 1, 1);" |  
| style="border: 1px solid #010101" width="174" |
String  
As set in the object
 
| style="border: 1px solid #010101" width="433" |
| 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");''


'''Return type'''
''font_Header[DIAGRAM_FONT_STYLE_FACE] = "Times New Roman"; ''  


Empty
''font_Header[DIAGRAM_FONT_STYLE_SIZE] = 9 ; ''


'''Examples'''
''array fill_style = DiagramFillStyle_getDefault(); ''  


string center = "center";
''array style_header = Tabulation_getDefaultDiagramStyle(Diagram_Type_Table); ''


string right = "right";
''style_header[TABLE_DIAGRAM_STYLE_FILL] = fill_style; ''


string left = "left";
''style_header[TABLE_DIAGRAM_STYLE_FONT] = font_Header; ''


number decimal1 = 1;
''style_header[TABLE_DIAGRAM_STYLE_VALIGN] = "center";''


number decimal0 = 0;
''style_header[TABLE_DIAGRAM_STYLE_HALIGN] = "center";''


array fill = {19,{17,0,0,0},2,true};
''Tabulation_setDiagramStyle(TableDiagram_ColumnHeaderLevel2, style_header);''


number styleType31 = 31;
''Tabulation_setDiagramStyle(TableDiagram_AbsoluteColumnHeader, style_header);''


array font31 = {18,"Times New Roman",13,{17,0,0,0},false,true,false,false};
''Tabulation_setDiagramStyle(TableDiagram_PercentageColumnHeader, style_header);''


array diagramStyle31={21,fill,decimal0,font31,center,left};
''createFrequenceDiagram("Civil_status");''
[[Image:SetDiagramStyle.jpg]]


Tabulation_setDiagramStyle(styleType31,diagramStyle31);
'''Availability'''


'''Availability'''
Version 5.8.1 __NOTOC__ <!-- imported from file: 8101.htm-->


Version 5.8.1
[[Category:Style_setting_functions]]
__NOTOC__
<!-- imported from file: 8101.htm-->

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