AdaptTable for Mantine

Spreadsheet formulas in Mantine

A formula column is a column nobody wrote code for: type =ROUND(budget * 0.15, 0) and the table computes it per row, sorts it, filters it and exports it like any other column.

The engine covers arithmetic including POWER and SQRT, comparison, string joins, IF, and the aggregate functions a footer needs. A bad reference reports in the cell that caused it rather than blanking the table, and a circular reference reports #CYCLE! instead of recursing.

Formula columns serialize to the URL with everything else, so a derived column travels in the same link as the filters it sits beside.

The formula bar on this page is the host's own chrome, not the table's — the engine hands back column definitions, and Mantine renders the resulting columns exactly like the declared ones.

The code

import { DataTable } from "@adapttable/mantine";
import { buildFormulaColumns } from "@adapttable/react/formula";

const derived = buildFormulaColumns([
  {
    key: "margin",
    header: "Margin",
    formula: "=ROUND(budget * 0.15, 0)",
  },
  {
    key: "tag",
    header: "Tag",
    formula: '=UPPER(team) & " · " & role',
  },
]);

export function People({ rows, columns }) {
  return (
    <DataTable
      data={rows}
      columns={[...columns, ...derived.columns]}
      rowKey={(row) => row.id}
    />
  );
}

Install

pnpm add @adapttable/mantine @adapttable/core @mantine/core @mantine/hooks

The same feature in the other kits

• Spreadsheet formulas in MUI — Material elevation, uppercase actions
• Spreadsheet formulas in Chakra — Soft teal, generous radius
• Spreadsheet formulas in Ant Design — Compact, tinted header, crisp
• Spreadsheet formulas in Radix — Radix Themes, iris accent
• Spreadsheet formulas in Base UI — Unstyled primitives, blue accent
• Spreadsheet formulas in shadcn — Monochrome, ring focus
• Spreadsheet formulas in Tailwind — Unstyled — your own classes

More Mantine features

• Filtering in Mantine — Operators, an AND/OR tree, chips, and find in the same URL.
• Column management in Mantine — Show, hide, reorder, pin and resize — from a menu you did not write.
• Column groups in Mantine — Spanning headers that collapse to a stub, a kept child, or a custom cell.
• Row selection in Mantine — A set of ids that survives paging, with bulk actions over it.
• Rows in Mantine — Pin rows, merge cells, and a 3-dot menu for add and delete.
• Row reordering in Mantine — Flat, grouped and tree moves — keyboard, confirm, host writes.
• Inline cell editing in Mantine — Kit-native editors in the cell; every write goes through your handler.
• Row grouping in Mantine — Drag, keyboard and mobile grouping controls with live aggregation overrides.
• Aggregation in Mantine — Footer totals, pinned summaries, group aggregates — not data rows.
• Nested tables in Mantine — A real table under a row — same engine, own columns, own keys.
• Export and print in Mantine — Browser files or cancellable server jobs — CSV, XLSX and PDF.
• Row and column virtualization in Mantine — 100k rows, 40 columns, virtualized rows and columns, sticky chrome.
• Tree data in Mantine — Nesting, chevrons, URL expansion, and host-owned tree moves.
• Mobile cards in Mantine — Every row becomes a card on phones. Automatically, with the same state.
• Pivot tables in Mantine — Rows down the side, dimensions across the top, subtotals at every level.
• Saved views in Mantine — Name an arrangement, share it as a link, manage the list in place.
• Right-to-left Mantine data table — Arabic strings, a flipped axis, and a popover that opens from the right edge.
• Live updates in Mantine — Rows change while you read them. Sort and selection hold.
• Accessible Mantine data table — Arrow-key focus, a visible ring, forced-colors, and live announcements.
• AI table assistant in Mantine — Native assistant, feature-aware prompts and governed action receipts.

Reference: formulas. More of this kit: AdaptTable for Mantine, or the live demo.