The spreadsheet element of the ELN offers the basic excel functions together with exclusive advanced options.
To add a spreadsheet element to your experiments and protocols, click on ‘Add spreadsheet’ located at the top of every section:
A video introduction into the top 10 new functions of the spreadhseet (from our open panel session)
The toolbar is divided into tabs. Each tab gathers a variety of tools and Excel-like applications.
1. Home Tab
The Home tab allows you to cut, copy, and paste as well as set cell formatting and conditional formatting. You can also 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 the 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.
2. Insert tab
A wide range of elements insertion is available- tables, charts, and graph possibilities as well as 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 colors, 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:
Add a title (either chart title or axis title)
From the 'Add chart element' menu click on 'More titles option'
Edit the text in the text editor at the opened menu on the right side of the spreadsheet
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 mouse pointer hovers over the hyperlink is available as well.
3. Formulas tab
The spreadsheet element offers a wide range of 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:
Array formulas are not supported in ranges that contain merged cells
The formula cannot be changed in part of the range
Cut and copy applies to the entire range
Columns and rows cannot be inserted or removed from part of the range
Users can view all the formulas in the cells using the Show formulas tab-
4. Data tab
The Data tab allows you to sort, filter, group, validate data, load or save schema, and bind a table using a template.
5. View tab
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.
6. Settings tab
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.
7. General options
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.