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 setSortOrderHorizontal: Difference between revisions

From Catglobe Wiki
No edit summary
Nguyenduyan (talk | contribs)
No edit summary
 
(4 intermediate revisions by one other user not shown)
Line 1: Line 1:
==== Tabulation_setSortOrderHorizontal ====
{{HelpFiles}}
__NOTOC__
[[Category:Sorting_functions]]


Sort data horizontally
Sort the tabulation table in horizontal


'''Syntax'''
===Syntax===


Tabulation_setSortOrderHorizontal(constant)
Tabulation_setSortOrderHorizontal(sortOrder)  


'''Arguments'''
===Arguments===


*''Tabulation_SortOrder_None'': is a ''constant ''.
''sortOrder'': Is a numeric (non-decimal) expression. The constants for this parameter:
*''Tabulation_SortOrder_LowToHigh'': is a ''constant ''.
*''Tabulation_SortOrder_HighToLow'': is a ''constant ''.
*''Tabulation_SortOrder_AtoZ'': is a ''constant ''.
*''Tabulation_SortOrder_ZtoA'': is a ''constant ''.


'''Return type'''
*0: Tabulation_SortOrder_None
*1: Tabulation_SortOrder_HighToLow
*2: Tabulation_SortOrder_LowToHigh
*3: Tabulation_SortOrder_AtoZ
*4: Tabulation_SortOrder_ZtoA
*5: Tabulation_SortOrder_HighToLowOnTotal
*6: Tabulation_SortOrder_LowToHighOnTotal


N/A
===Return type===


'''Examples'''
empty


Tabulation_setSortOrderHorizontal(Tabulation_SortOrder_LowToHigh);<br/>createCrossDiagram(rowAxis,colAxis);
===Examples===


'''Availability'''
Tabulation_setSortOrderHorizontal(Tabulation_SortOrder_None);
<br/>Result:<br/>
[[File:Tabulation_setSortOrderHorizontal_None.jpg]]


Version 6.0
Tabulation_setSortOrderHorizontal(Tabulation_SortOrder_HighToLow);
<br/>Result:<br/>
[[File:Tabulation_setSortOrderHorizontal_HighToLow.jpg]]
 
Tabulation_setSortOrderHorizontal(Tabulation_SortOrder_LowToHigh);
<br/>Result:<br/>
[[File:Tabulation_setSortOrderHorizontal_LowToHigh.jpg]]
 
Tabulation_setSortOrderHorizontal(Tabulation_SortOrder_AtoZ);
<br/>Result:<br/>
[[File:Tabulation_setSortOrderHorizontal_AToZ.jpg]]
 
Tabulation_setSortOrderHorizontal(Tabulation_SortOrder_ZtoA);
<br/>Result:<br/>
[[File:Tabulation_setSortOrderHorizontal_ZToA.jpg]]
 
Tabulation_setSortOrderHorizontal(Tabulation_SortOrder_HighToLowOnTotal);
<br/>Result:<br/>
[[File:Horizontal_sort_on_total_high_to_low.png]]
 
Tabulation_setSortOrderHorizontal(Tabulation_SortOrder_LowToHighOnTotal);
<br/>Result:<br/>
[[File:Horizontal_sort_on_total.png]]

Latest revision as of 10:28, 11 July 2017



Sort the tabulation table in horizontal

Syntax

Tabulation_setSortOrderHorizontal(sortOrder)

Arguments

sortOrder: Is a numeric (non-decimal) expression. The constants for this parameter:

  • 0: Tabulation_SortOrder_None
  • 1: Tabulation_SortOrder_HighToLow
  • 2: Tabulation_SortOrder_LowToHigh
  • 3: Tabulation_SortOrder_AtoZ
  • 4: Tabulation_SortOrder_ZtoA
  • 5: Tabulation_SortOrder_HighToLowOnTotal
  • 6: Tabulation_SortOrder_LowToHighOnTotal

Return type

empty

Examples

Tabulation_setSortOrderHorizontal(Tabulation_SortOrder_None);
Result:

Tabulation_setSortOrderHorizontal(Tabulation_SortOrder_HighToLow);
Result:

Tabulation_setSortOrderHorizontal(Tabulation_SortOrder_LowToHigh);
Result:

Tabulation_setSortOrderHorizontal(Tabulation_SortOrder_AtoZ);
Result:

Tabulation_setSortOrderHorizontal(Tabulation_SortOrder_ZtoA);
Result:

Tabulation_setSortOrderHorizontal(Tabulation_SortOrder_HighToLowOnTotal);
Result:

Tabulation_setSortOrderHorizontal(Tabulation_SortOrder_LowToHighOnTotal);
Result: