Function group

Function

Numerical functions

Abs()

Asc()

BasedStr$()

CurrentDataLineIndex()

CurrentLineIndex()

CurrentLineTypeIndex()

DateDiff()

Even()

Fstr$()

LastPage()

LocCurr$()

LocCurrL$()

LocNumber$()

LocVal()

Max()

Min()

Odd()

Page()

PrintPassCount()

PrintPassIndex()

Round()

ScriptVal()

TextWidth()

ToFrac$()

ToNumber()

Val()

Mathematical functions

Abs()

ArcCos()

ArcSin()

ArcTan()

Ceil()

Constant.Pi()

Cos()

Div()

Even()

Exp()

Exp10()

Floor()

Frac()

Int()

Log()

Log1()

Odd()

Pow()

Round()

Sign()

Sin()

Sqrt()

Tan()

Date functions

AddDays()

AddHours()

AddMinutes()

AddMonths()

Add8econds()

AddWeeks()

AddYears()

Century()

Date()

Date$()

DateDiff()

DateDiff$()

DateHMS()

DateHMSStr()

DatelnLeapYear()

DatelnRange()

DateToJulian()

DateYMD()

Day()

Day$()

Decade()

Dow()

EDMonth()

ExtractDate()

ExtractTime()

Hour()

JulianToDate()

LocDate$()

LocDateTime()

LocTime$()

Minute()

Month()

Month$()

Now()

Quarter()

ScriptDate()

Second()

Time$()

Today()

Woy()

Year()

Year$()

String functions

Alias$()

Asc()

Atrim$()

Barcode()

Barcode$()

BasedStr$()

Capitalize$()

Case$()

Chr$()

ChrSubst$()

Contains()

DateDiff$()

Empty()

EndsWith()

GetIniString$()

GetRegistryString$()

GS1Text$()

HTMLToPlainText$()

Hyperlink$()

IBAN$()

IsNullOrEmpty()

LangCase$()

Left$()

Len()

LoadFile$()

Locale$()

Localelnfo$()

LocCurr$()

LocCurrL$()

LocDate$()

LocDateTime()

LocNumber$()

LocTime$()

LocVal()

Lower$()

Ltrim$()

Mid$()

Ord()

PageBreak$()

PlainTextToHTML$()

ProjectParameter$()

RegExMatch$()

RegExSubst$()

Rep$()

ReplaceChr$()

ReplaceRegEx$()

Replace$tr$()

RGBStr$()

Right$()

RTFtoPlainText$()

Rtrim$()

Script$()

StartsWith()

StrPos()

StrRPos()

StrSubst$()

TextWidth()

ToFrac$()

Token$()

ToRTF$()

ToString$()

Upper$()

URLDecode$()

URLEncode$()

UTF8Encode$()

Val()

WildcardMatch()

Project and print-dependent functions

ApplicationPath$()

ChangeType()

Continued()

CurrentDataLinelndex()

CurrentLinelndex()

CurrentLineTypelndex()

LastPage()

LibraryPath$()

Page()

Page$()

Previous()

PreviousUsed()

PrintPassCount()

PrintPasslndex()

ProjectPath$()

TotalPages$()

Various functions

AskString$()

AskStringChoice$()

Cond()

Evaluate()

Exists()

FirstHeaderThisTable()

GetValue()

GetVar()

If()

IsNull()

LastFooterThisTable()

Null()

NullSafe()

Page$()

RemainingTableSpace()

SetVar()

TableWidth()

TotalPages$()

Aggregate functions

Avg()

Count()

CountIf()

Distinct()

GeometricAvg()

Join$()

Maximum()

Median()

Minimum()

Mode()

NthLargest()

NthLargestIndex()

NthValue()

Precalc()

StdDeviation()

Sum()

Total()

Variance()

Barcode functions

Barcode()

Barcode$()

BarcodeType$()

CheckMod10()

GS1Text$()

Conversion functions

BasedStr$()

Century()

Chr$()

Cstr$()

Date()

Date$()

DateDiff()

DateDiff$()

DateToJulian()

DateYMD()

Day()

Day$()

Decade()

DisplayValues$()

Dow()

Dow$()

Fstr$()

Hour()

JulianToDate()

LocVal()

Minute()

Month()

Month$()

Ord()

Quarter()

Roman$()

Second()

Str$()

Time$()

ToFrac$()

ToNumber()

ToString$()

UnitFromSCM()

Val()

Woy()

Year()

Year$()

Binary functions

BasedStr$()

BinaryAND()

BinaryNOT()

BinaryOR()

BinarySHL()

BinarySHR()

BinaryXOR()

Image functions

BMPMapToGray()

BMPRotate()

CountryFlag()

Drawing()

Drawing$()

DrawingFromBase64()

DrawingHeightSCM()

DrawingMapToGray()

DrawingRotate()

DrawingWidthSCM()

Color functions

ChangeLightness()

CMYK()

HeatmapColor()

HSL()

RainbowColor()

RGB()

Logical functions

DateInRange()

Empty()

EndsWith()

Even()

IsNullOrEmpty()

NumInRange()

Odd()

ScriptBool()

StartsWith()

WildcardMatch()

Currency functions

IBAN$()

LocCurr$()

LocCurrL$()

Native aggregate functions

NativeAvg()

NativeCount()

NativeMax()

NativeMin()

NativeStdDevSamp()

NativeSum()

NativeVarSamp()

Script functions

Script$()

ScriptBool()

ScriptDate()

ScriptVal()