The spreadsheet element of the ELN offers basic Excel functions and exclusive advanced options. 

To add a spreadsheet element to your experiments and protocols, click on ‘Add spreadsheet’ located at the top of every section:
​

The toolbar is divided into tabs. Each tab gathers a variety of tools and Excel-like applications.

The Home tab allows you to cut, copy, and paste, as well as set cell formatting and conditional formatting. You can add and format tables, sort, filter, and search.

Number formatting for different number presentations, such as number, date, fraction, or scientific, are available-

Conditional formatting to easily visualize patterns when having a well-populated datasheet-
​

The Format function allows you automatically resize the rows and columns in a worksheet using AutoFit, hide rows and columns, format rows and columns headers and sheet protection options.

There is also an option to protect specific cells within the element or leave some cells editable after protecting the whole element.

The Editing menu includes basic calculation formulas, auto-fill options, Sort & Filter, and Find functions.

The filter sort & function offers Number, Text, Date, Color, and Custom filters based on the data type of the cells.

The filter dialog helps you to filter by item, sort the list of items, hide filtered rows, as well as clear any applied filter condition on a column.

A wide range of elements are available- tables, charts, graphs, illustrations, and hyperlinks.

Charts for data visualization and analysis- select the data for visualization and then select the required chart type.

Chart formatting possibilities are available, such as colours, borders, size, and text formatting as well as chart title and legends addition.

The spreadsheet element offers a wide range of chart elements you can add to your chart, such as chart and axis titles, error bars, gridlines, data labels, legends, and trendlines. The addition of chart elements is available from the chart element addition menu.

How to edit chart and axis titles:

Hyperlink to link a URL address inside your spreadsheet-
Select a cell to insert the hyperlink, define the text presented as the hyperlink and select the required URL or email address to be linked.
Color setting of the hyperlink as well as the color after the link has been accessed, is available.
Screen tip to be presented while the mouse pointer hovers over the hyperlink is available as well.

The spreadsheet element offers various functions and formulas, such as basic arithmetic, financial, and array formulas.

As in Excel, the spreadsheet element offers a formula bar where formulas can be written into a cell, and the cell’s content can be seen.

Functions and formulas can be used in the table in the same way as in Excel. You can see the list of available formulas using the ‘Insert function’ tab.

VLOOKUP, XLOOKUP, and XMATCH functions are also available, you can easily find them in the lookup and reference tab.

Array formulas have the following limitations:

Users can view all the formulas in the cells using the Show formulas tab-

The Data tab allows you to sort, filter, group, validate data, load or save schema, and bind a table using a template.

The View tab allows you to hide or show headers, gridlines, the tab strip, and the new tab option. You can also zoom and freeze rows and columns.

The Settings tab allows you to set options for the sheet or the entire workbook. You can set options for the tab and scroll bars. You can specify the number of columns and rows and frozen rows and columns. You can also set the selection policy.

Export - Save a copy of the spreadsheet to a .XLSX .CSV file or a PDF document.

Adjust the number of rows to view on the page by dragging with your mouse via the arrows icon at the bottom of the spreadsheet.
​

   Add a new sheet but clicking on the + icon 

To see the full documentation from our third party - click here.