Tabulation setSortOrderVertical: Difference between revisions

VisualWikitext

Latest revision as of 10: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_setSortOrderVertical(Tabulation_SortOrder_HighToLow);
Result:

Tabulation_setSortOrderVertical(Tabulation_SortOrder_LowToHigh);
Result:

Tabulation_setSortOrderVertical(Tabulation_SortOrder_AtoZ);
Result:

Tabulation_setSortOrderVertical(Tabulation_SortOrder_ZtoA);
Result:

Tabulation_setSortOrderVertical(Tabulation_SortOrder_HighToLowOnTotal);
Result:

Tabulation_setSortOrderVertical(Tabulation_SortOrder_LowToHighOnTotal);
Result:

@@ 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);<br/><br/>
+===Examples===
+Tabulation_setSortOrderVertical(Tabulation_SortOrder_None);
+<br/>Result:<br/>
+[[File:Tabulation_getSortOrderVertical_None.jpg]]
+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]]