Softanza
StartFrançais
Softanza
The library documents itself · Tables & data

stzPivotTable

38 own methods · 1 forms written with extensions, listed under their method · Also inherits from stzList (884)

the source: base/table/stzPivotTable.ring(opens in a new tab) · All classes · The area reference: Tables & data

Under each method, its extensions (Q CS XT Z ZZ IB W U): bold and ticked, it exists; struck, it does not. The extensions and what they mean

Examples: 0 come from the library's tests; 2 were composed from each method's signature and run for this page, on a fresh object, for example oTab = new stzTable([ [ :Region, :Product, :Sales ], [ "N", "A", 10 ], [ "N", "B", 30 ], [ "S", "A", 40 ], [ "S", "B", 50 ] ]) o1 = new stzPivotTable(oTab). 36 methods have none yet. Examples run on 2026-10-03 20:23 inside the library at commit 0e72e2e2c.

Method
Explanation, as the source carries it
init
initialization and setupno extension
ClassName
initialization and setup
composed example
oTab = new stzTable([ [ :Region, :Product, :Sales ], [ "N", "A", 10 ], [ "N", "B", 30 ], [ "S", "A", 40 ], [ "S", "B", 50 ] ])
o1 = new stzPivotTable(oTab)
? o1.ClassName()
#--> stzpivottable
composed from the signature, run for this page
no extension
KlassName
initialization and setup
composed example
oTab = new stzTable([ [ :Region, :Product, :Sales ], [ "N", "A", 10 ], [ "N", "B", 30 ], [ "S", "A", 40 ], [ "S", "B", 50 ] ])
o1 = new stzPivotTable(oTab)
? o1.KlassName()
#--> stzpivottable
composed from the signature, run for this page
no extension
Analyze
(no comment in the source: the name reads as a sentence) analyzein the section configuration methodsno extension
By
(no comment in the source: the name reads as a sentence) byin the section configuration methodsno extension
SetRowsBy
(no comment in the source: the name reads as a sentence) set rows byin the section configuration methodsno extension
InRowsPut
(no comment in the source: the name reads as a sentence) in rows putin the section configuration methodsno extension
SetColsBy
(no comment in the source: the name reads as a sentence) set cols byin the section configuration methodsno extension
SetColumnsBy
(no comment in the source: the name reads as a sentence) set columns byin the section configuration methodsno extension
InColsPut
(no comment in the source: the name reads as a sentence) in cols putin the section configuration methodsno extension
InColumnsPut
(no comment in the source: the name reads as a sentence) in columns putin the section configuration methodsno extension
SetRowLabels
(no comment in the source: the name reads as a sentence) set row labelsin the section configuration methodsno extension
SetRowLabel
(no comment in the source: the name reads as a sentence) set row labelin the section configuration methodsno extension
SetColumnLabels
(no comment in the source: the name reads as a sentence) set column labelsin the section configuration methodsno extension
SetColumnLabel
(no comment in the source: the name reads as a sentence) set column labelin the section configuration methodsno extension
SetValues
(no comment in the source: the name reads as a sentence) set valuesin the section configuration methodsno extension
SetValue
(no comment in the source: the name reads as a sentence) set valuein the section configuration methodsno extension
SetAggregateFunction
(no comment in the source: the name reads as a sentence) set aggregate functionin the section configuration methodsno extension
SetRowLabelsSeparator
(no comment in the source: the name reads as a sentence) set row labels separatorin the section configuration methodsno extension
SetRowLabelsSeperator
@Misspelledno extension
SetShowTotals
(no comment in the source: the name reads as a sentence) set show totalsin the section configuration methodsno extension
SetHideTotals
(no comment in the source: the name reads as a sentence) set hide totalsin the section configuration methodsno extension
SetTotalLabel
(no comment in the source: the name reads as a sentence) set total labelin the section configuration methodsno extension
SetNullValue
(no comment in the source: the name reads as a sentence) set null valuein the section configuration methodsno extension
SetColumnOrder
(no comment in the source: the name reads as a sentence) set column orderin the section configuration methodsno extension
Generate
pivot table generationno extension
Value
data access methodsno extension
RowTotal
data access methodsno extension
ColumnTotal
data access methodsno extension
GrandTotal
data access methodsno extension
SaveToFile
serialization methodsno extension
LoadFromFile
serialization methodsno extension
ToTable
ToTable Methodno extension
Show
Show MethodQCSXTZZZIBWU
PadRight
utility functionsno extension
PadLeft
utility functionsno extension
CenterText
utility functionsno extension
StrFill
utility functionsno extension