Functions¶
- Alphabetical
- ABS
- AND
- ARCCOS
- ARCSIN
- ARCTAN
- ARCTAN2
- ARRAY
- ATTRIBUTES
- AVERAGE
- AVERAGEIF
- AVERAGEIFS
- BAR
- BIN2DEC
- BIN2FLOAT
- BIN2HEX
- BIN2OCT
- CALC
- CHAR
- CHOOSE
- CLASSIFYPOINT
- CLEAN
- CODE
- COLOR.CONVERT
- CONCAT
- COPYVALUES
- COS
- CORREL
- COUNT
- COUNTIF
- COUNTIFS
- COUNTER
- DATE
- DATEVALUE
- DAVERAGE
- DAY
- DCOUNT
- DEC2BIN
- DEC2HEX
- DEC2OCT
- DEGREES
- DELETE
- DELETECELLS
- DICTIONARY
- DMAX
- DMIN
- DRAW.BUTTON
- DRAW.CHART
- DRAW.CHARTSTATE
- DRAW.CHECKBOX
- DRAW.ELLIPSE
- DRAW.KNOB
- DRAW.LABEL
- DRAW.LINE
- DRAW.POLYGON
- DRAW.RECTANGLE
- DRAW.SLIDER
- DSUM
- EDGE.DETECT
- EVEN
- EVENTS
- EXECUTE
- EXCEL2JSONTIME
- FEEDINBOX
- FILE.WRITE
- FIND
- FILLLINEARGRADIENT
- FILLPATTERN
- FILLRADIALGRADIENT
- FLOAT2BIN
- FLOAT2HEX
- FONTFORMAT
- FORECAST
- FRAC
- GETCYCLE
- GETCYCLETIME
- GETMACHINESTEP
- GETSTEP
- GOTO
- HEX2BIN
- HEX2DEC
- HEX2FLOAT
- HEX2OCT
- HOUR
- IF
- IFERROR
- INBOX
- INBOXDATA
- INBOXMETADATA
- INDEX
- INDIRECT
- INFLUX.DROP
- INFLUX.SELECT
- INFLUX.SHOW
- INFLUX.STORE
- INT
- ISERR
- ISERROR
- ISEVEN
- ISNA
- ISODD
- JSONTIME2EXCEL
- KAFKA.COMMAND
- KAFKA.PUBLISH
- KAFKA.QUERY
- LEFT
- LEN
- LINEFORMAT
- LOOPCOUNT
- LOOPINDEX
- MAIL.SEND
- MATCH
- MAX
- MAXIFS
- MID
- MIN
- MINIFS
- MINUTE
- MOD
- MONTH
- MONGO.DELETE
- MONGO.QUERY
- MONGO.STORE
- MOVEVALUES
- MQTT.PUBLISH
- MSTOSERIAL
- NA
- NOT
- NOW
- OCT2BIN
- OCT2DEC
- OCT2HEX
- ODD
- OFFSET
- ONCLICK
- ONDOUBLECLICK
- ONMOUSEDOWN
- ONMOUSEUP
- ONVALUECHANGE
- OR
- OUTBOX
- OUTBOXDATA
- PI
- POWER
- PRODUCE
- QRCODE
- RADIANS
- RANDBETWEEN
- RANDID
- READ
- REPLACE
- REPT
- REQUEST
- REQUESTINFO
- RESPOND
- REST.REQUEST
- REST.RESPOND
- RETURN
- RIGHT
- ROUND
- SEARCH
- SECOND
- SELECT
- SERIALTOMS
- SETCYCLETIME
- SETPHASE
- SETVALUE
- SIGN
- SIN
- SPLIT
- SQRT
- STACKADD
- STACKDROP
- STACKFIND
- STACKROTATE
- STACKSORT
- STDEV.S
- SUBSTITUTE
- SUBTREE
- SUM
- SUMIF
- SUMIFS
- SWAPVALUES
- SWITCH
- TAN
- TEXT
- TIME
- TIMEAGGREGATE
- TIMESTORE
- TIMEQUERY
- TIMEVALUE
- TRIGGERSTEP
- TRUNC
- UNICHAR
- UNICODE
- VLOOKUP
- WEEKDAY
- WRITE
- YEAR
- Database
- Date
- Drawing
- ATTRIBUTES
- BAR
- CLASSIFYPOINT
- DRAW.BUTTON
- DRAW.CHART
- DRAW.CHARTSTATE
- DRAW.CHECKBOX
- DRAW.ELLIPSE
- DRAW.KNOB
- DRAW.LABEL
- DRAW.LINE
- DRAW.POLYGON
- DRAW.RECTANGLE
- DRAW.SLIDER
- EVENTS
- FILLLINEARGRADIENT
- FILLPATTERN
- FILLRADIALGRADIENT
- FONTFORMAT
- LINEFORMAT
- ONCLICK
- ONDOUBLECLICK
- ONMOUSEDOWN
- ONMOUSEUP
- ONVALUECHANGE
- QRCODE
- Engineering
- Info
- Logical
- Lookup
- Math
- Stack
- Statistical
- Streamsheet
- ARRAY
- CALC
- COLOR.CONVERT
- COPYVALUES
- COUNTER
- DELETE
- DELETECELLS
- DICTIONARY
- EDGE.DETECT
- EXECUTE
- FEEDINBOX
- FILE.WRITE
- GETCYCLE
- GETCYCLETIME
- GETEXECUTESTEP
- GETMACHINESTEP
- GETSTEP
- GOTO
- INBOX
- INBOXDATA
- INBOXMETADATA
- INFLUX.DROP
- INFLUX.SELECT
- INFLUX.SHOW
- INFLUX.STORE
- JSON
- KAFKA.COMMAND
- KAFKA.PUBLISH
- KAFKA.QUERY
- LOOPCOUNT
- LOOPINDEX
- MAIL.SEND
- MONGO.AGGREGATE
- MONGO.COUNT
- MONGO.DELETE
- MONGO.QUERY
- MONGO.REPLACE
- MONGO.STORE
- MOVEVALUES
- MQTT.PUBLISH
- OPCUA.READ
- OPCUA.RESPOND
- OPCUA.VARIABLES
- OPCUA.WRITE
- OUTBOX
- OUTBOXDATA
- PRODUCE
- READ
- REPEATINDEX
- REQUEST
- REQUESTINFO
- RESPOND
- REST.REQUEST
- REST.RESPOND
- RETURN
- SELECT
- SETCYCLETIME
- SETPHASE
- SETVALUE
- SUBTREE
- SWAPVALUES
- TRIGGERSTEP
- WEBPAGE
- WRITE
- Text
- Timeseries