Spreadsheet fields need to be enabled by an Instance admin, as described here: Enable Rich Text Editor or Spreadsheet Widgets
The spreadsheet supports some basic Excel functionalities, such as mathematical formulas (e.g. =SUM(A1+A2)).
It is possible to import an openBIS Object into the spreadsheet, with the import button, on the spreadsheet itself:
Please note that if the Object is updated in openBIS, it will NOT be updated in the spreadsheet.