Difference between revisions of "Tabulation setSortOrderVertical"

From Catglobe Wiki
Jump to: navigation, search
 
(5 intermediate revisions by 2 users not shown)
Line 1: Line 1:
==== Tabulation_setSortOrderVertical ====
+
{{HelpFiles}}
 +
__NOTOC__
 +
[[Category:Sorting_functions]]
  
Sort data vertically
+
Sort the tabulation table in vertical
  
'''Syntax'''
+
===Syntax===
  
Tabulation_setSortOrderVertical(constant)
+
Tabulation_setSortOrderVertical(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_setSortOrderVertical(Tabulation_SortOrder_LowToHigh);<br/>createCrossDiagram(rowAxis,colAxis);
+
===Examples===
  
'''Availability'''
+
Tabulation_setSortOrderVertical(Tabulation_SortOrder_None);
 +
<br/>Result:<br/>
 +
[[File:Tabulation_getSortOrderVertical_None.jpg]]
  
Version 6.0
+
Tabulation_setSortOrderVertical(Tabulation_SortOrder_HighToLow);
 +
<br/>Result:<br/>
 +
[[File:Tabulation_getSortOrderVertical_HighToLow.jpg]]
 +
 
 +
Tabulation_setSortOrderVertical(Tabulation_SortOrder_LowToHigh);
 +
<br/>Result:<br/>
 +
[[File:Tabulation_getSortOrderVertical_LowToHigh.jpg]]
 +
 
 +
Tabulation_setSortOrderVertical(Tabulation_SortOrder_AtoZ);
 +
<br/>Result:<br/>
 +
[[File:Tabulation_getSortOrderVertical_AToZ.jpg]]
 +
 
 +
Tabulation_setSortOrderVertical(Tabulation_SortOrder_ZtoA);
 +
<br/>Result:<br/>
 +
[[File:Tabulation_getSortOrderVertical_ZToA.jpg]]
 +
 
 +
Tabulation_setSortOrderVertical(Tabulation_SortOrder_HighToLowOnTotal);
 +
<br/>Result:<br/>
 +
[[File:Vertical_sort_on_total_high_to_low.png]]
 +
 
 +
Tabulation_setSortOrderVertical(Tabulation_SortOrder_LowToHighOnTotal);
 +
<br/>Result:<br/>
 +
[[File:Vertical_sort_on_total.png]]

Latest revision as of 11:23, 11 July 2017



Sort the tabulation table in vertical

Syntax

Tabulation_setSortOrderVertical(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_setSortOrderVertical(Tabulation_SortOrder_None);
Result:
Tabulation getSortOrderVertical None.jpg

Tabulation_setSortOrderVertical(Tabulation_SortOrder_HighToLow);
Result:
Tabulation getSortOrderVertical HighToLow.jpg

Tabulation_setSortOrderVertical(Tabulation_SortOrder_LowToHigh);
Result:
Tabulation getSortOrderVertical LowToHigh.jpg

Tabulation_setSortOrderVertical(Tabulation_SortOrder_AtoZ);
Result:
Tabulation getSortOrderVertical AToZ.jpg

Tabulation_setSortOrderVertical(Tabulation_SortOrder_ZtoA);
Result:
Tabulation getSortOrderVertical ZToA.jpg

Tabulation_setSortOrderVertical(Tabulation_SortOrder_HighToLowOnTotal);
Result:
Vertical sort on total high to low.png

Tabulation_setSortOrderVertical(Tabulation_SortOrder_LowToHighOnTotal);
Result:
Vertical sort on total.png