Other

Other things worth mentioning as well.๐Ÿ˜„

Shortcuts#

Inbox and Outbox Keyboard Shortcuts

KeyCommand
Ctrl CCopy selected cells to clipboard
Ctrl VPaste Data from clipboard
Ctrl XCopy selected elements to clipboard and remove elements after paste
DeleteDelete selected element and its sub elements
F2Edit current element content
Shift TabMove selected item one level down
TabMove selected item one level down

Streamsheet Keyboard Commands

KeyCommand
Arrow DownMove selection one cell down
Arrow LeftMove selection one cell to the left
Arrow RightMove selection one cell to the right
Arrow UpMove selection one cell up
Ctrl +Insert a range of cells or a column/row depending on the selection
Ctrl -Remove a range of cells or a column/row depending on the selection
Ctrl #Switch between data and formula view
Ctrl Arrow DownMove selection to the next or last used cell below
Ctrl Arrow LeftMove selection to the next or last used cell to the left
Ctrl Arrow RightMove selection to the next or last used cell to the right
Ctrl Arrow UpMove selection to the next or last used cell above
Ctrl CCopy selected cells to clipboard
Ctrl VPaste Data from clipboard
Ctrl XCopy selected cells to clipboard and remove cells after paste
Ctrl ScrollZoom in / out
Ctrl JCreate JSON RANGE
Ctrl + alt JDelete JSON RANGE
DeleteDelete selected cells
EnterLeave edit mode and apply changes to cell
EscapeLeave edit mode not applying changes
F2Edit current cell
Shift Arrow DownExtend selection one cell down
Shift Arrow LeftExtend selection one cell to the left
Shift Arrow RightExtend selection one cell to the right
Shift Arrow UpExtend selection one cell Up
Shift ScrollScroll horizontally

Error Codes#

Error CodeDescription
#ARG_NUMMissing arguments
#DISCONNECTEDOne of your Streams is not connected
#DIV0!Division by 0 is not possible
#ERRRequest Error or Parser Error
#FUNC_EXECInternal error
#INVALIDFunction is deprecated
#INVALID_LOOP_PATHThe given loop path in your function is Invalid.
#INVALID_PARAMThe given parameter in your function is Invalid.
#INVALID_PATHThe given path in your function is Invalid.
#NA!Not Available
#NAME?Unknown name
#NO_CONSUMERIf you have a Consumer, refresh it, otherwise create one.
#NO_PRODUCERIf you have a Producer, refresh it, otherwise create one.
#NO_MSGReferenced message does not exist in inbox or outbox
#NO_MSG_DATANo data a message given message path
#NO_STREAMSHEETReferenced sheet does not exist
#NUM!Invalid number
#RANGERange size invalid
#REF!Invalid reference
#VALUE!Invalid value

Hash Algorithms#

Currently Supported Algorithms
blake2b512
blake2s256
id-rsassa-pkcs1-v1_5-with-sha3-224
id-rsassa-pkcs1-v1_5-with-sha3-256
id-rsassa-pkcs1-v1_5-with-sha3-384
id-rsassa-pkcs1-v1_5-with-sha3-512
md4
md4withrsaencryption
md5
md5-sha1
md5withrsaencryption
mdc2
mdc2withrsa
ripemd
ripemd160
ripemd160withrsa
rmd160
rsa-md4
rsa-md5
rsa-mdc2
rsa-ripemd160
rsa-sha1
rsa-sha1-2
rsa-sha224
rsa-sha256
rsa-sha3-224
rsa-sha3-256
rsa-sha3-384
rsa-sha3-512
rsa-sha384
rsa-sha512
rsa-sha512/224
rsa-sha512/256
rsa-sm3
sha1
sha1withrsaencryption
sha224
sha224withrsaencryption
sha256
sha256withrsaencryption
sha3-224
sha3-256
sha3-384
sha3-512
sha384
sha384withrsaencryption
sha512
sha512-224
sha512-224withrsaencryption
sha512-256
sha512-256withrsaencryption
sha512withrsaencryption
shake128
shake256
sm3
sm3withrsaencryption
ssl3-md5
ssl3-sha1
whirlpool