X-Sheets

Data Editor (Grid View)

← Back to User Manual

4. Data Editor (Grid View)

The Data Editor is the full spreadsheet interface. It is accessible to Admins and Owners via Manage Data in the spreadsheet context menu.

4.1 Grid Layout

The grid displays your data as rows and columns, similar to a traditional spreadsheet:

  • Column headers — Show column names at the top.
  • Row numbers — Displayed on the left.
  • Cells — Editable content at each row/column intersection.
  • Sheet tabs — Tabs at the bottom for switching between sheets.

4.2 Toolbar

Button Action
Undo Reverts the last change. Disabled when there is no undo history.
Redo Re-applies the last undone change. Disabled when there is no redo history.
“Updating…” Status text that appears while data is being synchronized.

4.3 Editing Cells

To edit a cell, double-click (or double-tap on mobile) to enter edit mode. The behavior depends on the column type:

Column Type Edit Behavior Display
Text (String) Inline text input appears in the cell. Left-aligned text
Number Inline numeric input with decimal support. Right-aligned, formatted
Date Date picker dialog opens. Formatted date string
Paragraph Multi-line text editor dialog opens. Single-line preview with ellipsis
Picture Image upload dialog with file picker. Image icon in cell
Document File upload dialog with file picker. Document icon in cell
Reference Selection dialog with searchable list from the linked sheet. Link icon + display label

Read-only cells (primary keys and virtual columns) have a gray background and italic text. They cannot be edited directly.

4.4 Cell Selection

  • Click a cell to select it (highlighted with a colored border).
  • Click a row number to select the entire row.
  • Click a column header to select the entire column.

4.5 Column Management

Right-click a column header to open the column context menu:

  • Add Column Before — Insert a new column to the left.
  • Add Column After — Insert a new column to the right.
  • Edit Column — Open column settings dialog.
  • Move Column Left / Right — Reorder columns.
  • Delete Column — Remove the column (with confirmation).

Column Settings Dialog

When adding or editing a column, you configure:

  • Column Label (required) — The display name.
  • Column Type — One of: Text, Number, Date, Picture, Document, Reference, Paragraph.
  • Mandatory — Checkbox to require a value in this column.

Additional settings by type:

Type Extra Settings
Number Number Format (e.g., #,##0.00)
Paragraph Lines Count (default: 3)
Reference Reference Sheet (which sheet to link to) and Cascade Delete option
Picture / Document Synchronized Offline checkbox (cache files locally)

4.6 Row Operations

  • Add a row — Simply start typing in the empty row at the bottom of the grid. A new row is created automatically.
  • Delete a row — Right-click a row number and select Remove Row (shown in red). A confirmation dialog appears before deletion.

Note: If a row contains reference columns with Cascade Delete enabled, deleting the row will also remove linked records in the referenced sheet.

4.7 Sheet Management

At the bottom of the grid, sheet tabs let you work with multiple sheets:

Adding a Sheet

  1. Tap the + button in the tab bar.
  2. Choose:
    • Create Empty Sheet — Enter a label for the new sheet.
    • Create Sheet from CSV — Opens the CSV import wizard (see Import & Export).

Sheet Tab Context Menu

Right-click a sheet tab to access:

  • Edit Sheet — Change the sheet label and configure which columns appear in reference labels.
  • Load Sample Data (Admin only) — Populate the sheet with sample data.
  • Move Sheet Left / Right — Reorder sheets.
  • Clear All Data — Remove all rows while keeping columns intact (with confirmation).
  • Delete Sheet — Permanently remove the sheet (with confirmation showing which views will also be deleted).

4.8 Virtual Columns

Virtual columns are calculated fields that derive their values from expressions. They appear in the grid as read-only columns with gray italic text.

To add a virtual column:

  1. Open the virtual column settings dialog.
  2. Enter a Column Label.
  3. Use the Expression Builder to create a formula (see Expressions & Formulas).
  4. Choose a Display Type (Text, Number, Date, etc.) to control formatting.

Virtual columns recalculate automatically when the underlying data changes.

4.9 Undo & Redo

The undo/redo system tracks all data changes made in the editor:

  • Cell value changes
  • Row additions and deletions
  • Column additions, deletions, edits, and reordering
  • Virtual column operations
  • Sheet operations (add, delete, reorder, clear)

Use the Undo and Redo buttons in the toolbar to navigate the history.

Next: Forms & Data Entry →