Skip to main content
Version: Streamsheets 2.5

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
DragCreates a READ() function
Drag + altCreates a WRITE() function

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 FOpens search
Ctrl ScrollZoom in / out
Ctrl JCreate JSON RANGE
Ctrl + alt JDelete JSON RANGE
Ctrl Drag ObjectDuplicates an Object
DeleteDelete selected cells
EnterLeave edit mode and apply changes to cell
EscapeLeave edit mode not applying changes
F2Edit current cell
F4Toggle absolut and relativ references
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
Shift Resize ObjectRezises Object, but keeps width to height ratio

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
#RESPONSEInvalid Query Syntax
#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

Known issues​

Performance: The performance of the Eclipse Streamsheets is dependend on the amount, size and speed of the running apps. You can increase the resources assigned to docker and/or install Streamsheets on a faster system to increase the performance. Use the command docker stats to monitor used resources.

Docker will prompt an Error message if:

  • Docker has not set the option "Shared drives" in the docker settings menu to allow access to the used drive in the YML.
  • Docker has no space left on device. Use: docker image prune or docker volumne prune to clear some space, or allow docker more disc space.
  • You donΒ΄t have a valid license. There has to be a valid license in the folder "services/docker-compose/license". (not for the Raspberry Pi)

Streamsheets not reachable in local network:

  • Sometimes firewalls are blocking the network accessibility of the Streamsheets.

Other

  • In combination, the windows power savings mode and docker applications can run into problems. The problems may still occur after reentering normal runtime mode of windows. Restart your device, if you used the power savings mode.

If you find anything unusual or have more questions, let us know in our forum.

Streamsheets Premium License​

If you are the owner of a Streamsheets Premium setup, it is crucial to use the license file within the Streamsheets installer folder. Navigate into:

.\streamsheets\license

and place the license file into the directory. Make sure the file is named license.lic.

If you want to replace a license file overwrite the current license file with the new one. If you want to keep your old license file make sure to make a copy.

Restart your installation afterwards.

Streamsheet Premium Feature​

PremiumPlugin
System APIOpen ID
OPC UA ClientFile Watcher
OPC UA ServerCrypto API functions
App Files
Shared Apps
HTTP Server
Web sockets
PDF Export
JSON Process Function
JSON.TO.XML()
User Management
User Roles
Workspaces
Premium Charts
File Watcher
Protobuf
API functions
CRYPTO.HASH()
CRYPTO.HMAC()
TimescaleDB functions