Labii Documentation
HomeFree SignupFree DemoContact Us
  • Getting Started
    • Introduction
    • Quick Start
  • User Guide
    • Interface
      • Side Menu
      • Views
    • Add Record
      • Add a project
      • Add a blank record
      • Add records in bulk
      • Add a record from a template
      • Add record(s) from file(s)
      • Add a template
    • Record List View
      • Table List View
      • Project List View
      • Row List View
      • ❗Import Records
      • Export Records
      • Bulk Operations
        • Bulk Edit Columns
        • Bulk Edit Sections
        • Bulk Print Detail
        • Bulk Print Labels
        • Bulk Print Barcodes
        • Bulk Print QR Codes
        • Bulk Download
        • Use Selected to Add Blank Record
        • Use Selected to Bulk Add Records
    • Record Detail View
      • Columns
      • Sections
      • Notes
      • Signers
      • Versions
      • Activities
      • Visitors
      • Permissions
      • Section
      • Actions
        • Sign
        • Print
        • Share
    • Navbar
      • Search
        • Global search
        • Search at list view
        • Search query
      • Scan
    • Side Menu
      • Dashboard
      • Calendar
      • Notifications
      • Reload Organization
      • Switch Organization
      • Change Data Center
    • Accounts
      • Authentication
      • Setup an account
      • Create an account
      • My Profile
    • AI Integration
      • Prompt box
      • Prompt template
      • ProtocolGPT
      • AI in Widgets
      • Use cases
  • Admin Guide
    • Organization
    • Backups
    • Personnel
    • Certifications
    • Teams
    • Projects
      • Members
    • Applications
    • Tables
      • Columns
      • Sections
      • Filters
    • Workflows
    • Widgets
    • Subscriptions
    • Credits
    • Invoices
    • Single Sign On
      • Google G Suite
      • Okta
      • OneLogin
      • Microsoft Azure
    • API Keys
  • Widgets
    • Overview
    • Column Widgets
      • Form
        • Text inputs
          • Text
          • MultilineText
          • RichText
          • Number
          • RangeUnit
          • Email
          • Phone
          • Secret
          • Link
          • Address
        • Boolean
          • Checkbox
          • Switch
        • DateTime
          • Date
          • Time
          • DateTime
          • Appointment
          • TimeStamp
          • Timezone
        • Dropdown
          • Select
          • MultiSelect
          • ForeignKey
          • ForeignKeys
          • Member
          • Members
        • File
          • Files
          • Image
          • File Path
          • File Size
          • File Antivirus Status
      • Barcode
        • Barcode
        • QR Code
      • Calculation
        • Formula
        • Numbering
        • RowCount
        • Consumption
      • Integration
        • API
          • API
        • Dropdown
          • API ForeignKey
          • API ForeignKeys
      • Column
        • Record Citation
        • Column Citation
        • Column Data
        • Column Addition
      • Regulation
        • Signature
          • Signature
          • Open Signature
          • Signature Status
      • ❗Chemistry
      • ❗PubMed
      • ❗Device
      • ❗Integration
      • Advanced
        • Subtitle
        • Rating
        • Nested Fields
        • Storage
        • Storage Coordinates
    • Section Widgets
      • Office
        • Text
          • Plain Text
          • CKEditor Classic
          • CKEditor Balloon
          • CKEditor Document
          • CKEditor Restricted
          • CKEditor Classic Controlled
          • Code Editor
        • ❗Table
        • File
          • Files
          • File Preview
        • Google Drive
        • Drawing
        • G Suite
        • Microsoft Office
      • Data Display
        • Columns
          • Columns
          • Metadata
        • Sections
          • Section Display By Record
          • Section Display By ForeignKey
        • Record List
          • Record List
          • Record List by Column
          • Record List by ForeignKey
          • Record List by Query
      • ✅Regulation
        • Signers
        • ✅Audit Trail
          • ✅Activities
          • Versions
          • Visitors
      • Process Management
        • Flowchart
        • Steps
      • Diagram
        • Mermaid
        • Gantt Chart
        • Stage Flowchart
        • Relation Flowchart
      • Reference Manager
      • Biology
        • Molecular Biology Suite
          • Plasmid Editor
          • Open Vector Editor
        • Microplate
          • 6-Well Plate
          • 12-Well Plate
          • 24-Well Plate
          • 48-Well Plate
          • 96-Well Plate
          • 384-Well Plate
          • Flexible Well Plate
        • Sample Aliquoting
        • Assay
          • ELISA Standard Curve
          • ELISA Qualitative
          • Dose Response Curve
        • Protein
          • MolStar
          • RCSB Saguaro
        • Bioinformatics
          • QUiCKR Analysis
          • CRISPResso2
      • Chemistry
        • Chemical Formats
        • Chemical Drawing
        • Chemical Analysis
        • Chemical Reaction
      • Combination
        • Clinical Genomicist Workstation
      • Productivity
        • ✅Calendars
          • Calendar
          • Scheduling
        • Automation
          • Workflows
        • Ungrouped
          • Storage Map
        • Table of Contents
        • Communication
          • Email Template
          • Notifications
          • Comments
        • Barcode
        • ToDo
        • Timer
      • Report
        • Record Summary
          • Record Summary
        • Data Driven Charts
          • Chart By Category X
          • Chart By Numeric X
        • Custom Input Charts
          • Data Visualizer
    • Dashboard Widgets
      • Labii
      • Shortcut
        • Applications
        • Links
        • Filters
      • Productivity
        • Office
        • Flowchart
        • Section
        • Project Management
          • ✅Tasks
        • Summary
      • ✅Reports
        • Record Summary
          • Record Summary By Date
          • Record Summary By Tables
          • Record Summary By Projects
          • Record Summary By Users
        • Data Driven Charts
          • Chart By Category X
          • Chart By Numeric X
        • Matrix
          • Record Count By Filter
        • Audit
          • Storage Audit
      • Integration
        • Quickbooks
          • Quickbooks Customers
          • Quickbooks Accounts
          • Quickbooks Items
          • Quickbooks Invoices
  • API
    • Concepts
      • How to get token from Labii ELN & LIMS
      • How can I load Labii data from API into DataFrame
    • Methods
      • Authentication
      • Notification
      • Organization
      • Personnel
      • Team
      • Organization Widget
      • Statement
      • Backup
      • Project
      • Member
      • Table
      • Column
      • Filter
      • Row
      • Cell
      • Section
      • Activity
      • Version
      • Visitor
      • Workflow
      • Step
      • Widget
    • Variables
    • SDK
      • API Client (python)
      • API Client (javascript)
      • SDK (python)
      • SDK (javascript)
      • Examples
  • Applications
    • Electronic Lab Notebook
      • ELN for Research and Development
      • ELN for Production
      • ELN for ELISA Data Analysis
      • ELN for Dose Response Curve
    • Process Management
      • ❗Report creating process in diagnosis testing
      • ❗Email follow up process in CRM
      • ❗Management of the purchasing, approval, and ordering processes.
    • Sample Management
      • Sample Receiving
      • Track sample consumption
      • Aliquots Management
    • Equipment Management
      • ❗Equipment Scheduling
      • ❗Equipment Maintenance
    • Inventory Management
      • Barcode System
      • Stock Checkin and Checkout
      • Storage Management
      • ❗Purchase Management
    • Laboratory Information Management System
      • LIMS for Sample Testing
      • LIMS for NGS
    • Customer Relationship Management (CRM)
      • Quickbooks Integration
    • Document Management
    • Chemical Registration
    • Mouse Colony Management
    • Diagnostic Testing
    • Diabetes Tracker
    • Project Management
      • Task Management
      • How to manage research goals
    • Reference Management
    • Training Management
  • Support
    • Overview
    • Documentation
    • YouTube
    • Videos
    • Tickets
    • Chat with us
    • Schedule a meeting
    • Take a survey
    • Resources
    • Download
    • Blogs
    • FAQ
    • Other
      • Guidelines for Preparing Documents on Research Needs for Labii Configuration
Powered by GitBook
On this page
  • Overview
  • Widget comparison
  • Data import
  • SpreadJS Table
  • Features
  • XSpreadsheet
  • Features
  • ej2-Spreadsheet
  • Features
  • jExcel
  • Luckysheet
  • Features
  • HandsonTable
  • Features
  • Formula support
  1. Widgets
  2. Section Widgets
  3. Office

Table

View, edit, create spreadsheet

PreviousCode EditorNextFile

Last updated 4 months ago

Overview

provides a list of widgets to provide Excel-like functions to Electronic Lab Notebook. Please choose a widget that meets your needs. SpreadJS Table is recommended because it has all features of other widgets.

Category
Widget
Type
Description

Table

Section

True Excel-like spreadsheet

Table

Section

Excel-like spreadsheet with sheets

Table

Section

Excel-like spreadsheet with ribbon

Table

Section

Simple table editor

Table

Section

Simple table editor, deprecated

Table

Luckysheet

Section

Online spreadsheet like excel

Widget comparison

Feature
SpreadJS Table
XSpreadsheet
ej2-Spreadsheet
jExcel
HandsonTable

Copy & Paste

Yes

Yes

Yes

Yes

Yes

Copy & Paste from external

Yes

No

No

Yes

Yes

Ribbon

Yes

Yes

Yes

No

No

Formula

Yes

Yes

Yes

Yes

Yes

Chart

Yes

No

No

No

No

Drag

Yes

Yes

No

Yes

No

Text Format

Yes

Yes

Yes

No

No

Sheets

Yes

Yes

Yes

No

No

Context Menu

Yes

Yes

Yes

Yes

Yes

Data import

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.

SpreadJS Table

Features

  • Open *.xlsx, *.tsv, *.csv to import

  • Download as *.xlsx

  • Print as *.pdf

  • Font

    • Font family

    • Font size

    • Bold

    • Italic

    • Underline

    • Strikethrough

    • Font color

    • Background color

    • Clear Format

  • Align

    • Align left

    • Align center

    • Align right

    • Vertical bottom

    • Vertical center

    • Vertical top

  • Word wrap

  • Borders

    • Borders

    • Border color

    • Border style

  • Merge cells

  • Freeze rows/columns

  • Format

    • Format

    • Decrease decimal places

    • Increase decimal places

  • Chart

XSpreadsheet

Features

  • Undo & Redo

  • Paint format

  • Clear format

  • Format

  • Font

  • Font size

  • Font bold

  • Font italic

  • Underline

  • Strike

  • Text color

  • Fill color

  • Borders

  • Merge cells

  • Align

  • Text wrapping

  • Freeze cell

  • Functions

  • Resize row-height, col-width

  • Copy, Cut, Paste

  • Autofill

  • Insert row, column

  • Delete row, column

  • hide row, column

  • multiple sheets

  • print

  • Data validations

ej2-Spreadsheet

Features

  • Data sources: Bind the spreadsheet component with an array of JavaScript objects or DataManager.

  • Virtualization: Provides the option to load a large amount of data without performance degradation.

  • Selection: Provides the option to select a cell or range of cells.

  • Editing: Provides the options to dynamically edit a cell.

  • Formulas: Provides a built-in calculation library with predefined formulas and named range support.

  • Clipboard: Provides the option to perform clipboard operations.

  • Cell formatting: Provides the option to customize the appearance of cells.

  • Number formatting: Provides the option to format the cell value.

  • Open: Provides the option to open an excel file in a spreadsheet.

  • Save: Provides the option to save spreadsheet data as an excel file.

  • Sorting: Helps you to arrange the data to a particular order in a selected range of cells.

  • Filtering: Helps you to view specific rows in the spreadsheet by hiding the other rows.

  • Undo Redo: Provides the option to perform undo-redo operations in a spreadsheet.

  • Collaborative Editing: Provides the option for real-time changes across multiple users in the Spreadsheet.

  • Hyperlink: Provides the option to navigate the web links or cell reference within the sheet or to other sheets in the spreadsheet.

  • Resize: Allows you to change the row height and column width. Autofit the rows and columns based on their content.

  • Wrap text: Provides the option to display the large content as multiple lines in a single cell.

  • Data validation: Provides the option to validate edited values based on data validation rules defined for a cell or range of cells.

  • Find and Replace: Provides the option to find the data and replace it across all the sheets in the Spreadsheet.

  • Protect sheet: Provides the option to restrict user actions like cell editing, row, and column insertion, deletion, and resizing.

  • Borders: Provides the option to customize cell gridlines such as color and its style for enhanced UI.

  • Show/Hide: Provides the option to show/hide the rows, columns, and sheets.

  • Insert/delete: Provides the option to insert/delete the rows, columns, and sheets.

  • Merge cells: Provides the option to can combine two or more cells located in the same row or column into a single cell.

  • Conditional formatting: Provides the option to format a cell or range of cells based on the conditions applied.

  • Clear: Provides the option to clear the content, formats, and hyperlinks applied to a cell or range of cells in a spreadsheet.

  • Aggregates: Provides the option to check the sum, average, and count for the selected cells or range in the sheet tab.

  • Picture: Allows you to view, insert, and modify a picture in a spreadsheet with customizing options.

  • Multi-line editing: Allows you to insert a line break between paragraphs of the text within a cell in a Spreadsheet.

  • Range selection helper: Helps you to select a range or multiple ranges when editing a formula in a cell.

  • RTL: Provides right-to-left mode which aligns content in the spreadsheet component from right to left.

  • Localization: Provides inherent support to localize the UI.

  • Accessibility: Provides with built-in accessibility support which helps to access all the spreadsheet component features through the keyboard, screen readers, or other assistive technology devices.

jExcel

Luckysheet

Features

  • Formatting: style, conditional formatting, text alignment and rotation, text truncation, overflow, automatic line wrapping, multiple data types, cell segmentation style

  • Cells: drag and drop, fill handle, multiple selection, find and replace, location, merge cells, data verification

  • Row & column: hide, insert, delete rows or columns, freeze, and split text

  • Operation: undo, redo, copy, paste, cut, hot key, format painter, drag and drop selection

  • Formulas & Functions: Built-in, remote and custom formulas

  • Tables: filter, sort

  • Enhanced functions: Pivot tables, charts, comments, cooperative editing, insert picture, matrix calculations, screenshots, copying to other formats, EXCEL import and export, etc.

HandsonTable

Please let us know if you still want to use this widget.

  1. Headers - Adds rows or column headings to the spreadsheet.

  2. Row/Column Resize - Allows manual modification of row or column sizes. The sizing handle appears in the right part of the column header or at the bottom of the row header.

  3. Row/Column Move - Allows manual swapping of rows or columns within the table. The moving handle appears in the left part of the column header or at the top of the row header.

  4. Conditional Formatting - Defines how the specific cells are formatted depending on the content.

  5. Context Menu - Opens a pop-up menu that provides a list of items to choose. Right-click anywhere inside the table to open the context menu.

  6. Filters - Allows the addition of criteria to display only specific rows while hiding others. Available from the dropdown menu in the header.

  7. Dropdown Menu - Allows the creation of a dropdown menu, available in the column headers.

Formula support

Labii ELN & LIMS supports Formulas to process formula expressions defined in the provided data.

Features:

  • Any numbers, negative and positive as float or integer;

  • Arithmetic operations such as: +, -, /, *, %, ^;

  • Logical operations such as: AND(), OR(), NOT(), XOR();

  • Comparison operations such as: =, >, >=, <, <=, <>;

  • All JavaScript Math constants such as: PI(), E(), LN10(), LN2(), LOG10E(), LOG2E(), SQRT1_2(), SQRT2();

  • Error handling: #DIV/0!, #ERROR!, #VALUE!, #REF!, #NAME?, #N/A, #NUM!;

  • String operations such as: & (concatenation eq. =-(2&5) will return -25);

  • Relative and absolute cell references such as: A1, $A1, A$1, $A$1;

  • Build-in variables such as: TRUE, FALSE, NULL;

  • Custom variables;

  • Nested functions;

  • Dynamic updates.

Known limitations:

  • Not working with filtering and column sorting;

  • Not working with trimming rows.

is developed by GrapeCity that Deliver True Excel-Like spreadsheet experiences. This widget enables you to import, modify and export your most complex Excel .xlsx spreadsheets. SpreadJS offers the most complete Excel-like experience, including tables, charts, shapes, sparklines, conditional formatting, filtering, and an extensive library with no Excel dependencies to create the most advanced data visualizations.

is another Excel-like Spreadsheet widget. It supports some basic text formatting and also supports multiple sheets.

The is a user-interactive component to organize and analyze data in tabular format with configuration options for customization. The populated data can be exported as Excel with *.xlsx, *.xls, and *.csv formats.

provides exactly the same layout to the HandsonTable. jExcel has plenty of different input options through its native column types to cover the most common web-based application requirements. It is a complete solution for your tabular data management.

is an online spreadsheet like excel that is powerful, simple to configure, and completely open source.

is a JavaScript data grid component for web applications.

The widget will not be supported because of the licensing issues. The function of HandsonTable is replaced with .

Table Interface of Labii ELN & LIMS

❗
Labii ELN & LIMS
SpreadJS
Xspreadsheet
ej2-Spreadsheet
jExcel
Luckysheet
Handsontable
Features
jExcel
SpreadJS Table
XSpreadsheet
ej2-Spreadsheet
jExcel
HandsonTable