Labii ELN & LIMS use Table widget to provide Excel like functions to Electronic Lab Notebook.
The view interface and edit interface are identical except value can be changed at the Edit mode.
Labii ELN & LIMS supports Formulas to process formula expressions defined in the provided data.
Any numbers, negative and positive as float or integer;
Arithmetic operations such as:
Logical operations such as:
Comparison operations such as:
String operations such as:
& (concatenation eq.
=-(2&5) will return
Relative and absolute cell references such as:
Build-in variables such as:
Not working with filtering and column sorting;
Not working with trimming rows.
The table widget supports data import *.xlsx, *.tsv, *.csv. Simply drag and drop a file to the widget and the content of the file will be loaded into the table.