AdaptTable for shadcn-vue

Spreadsheet formulas in shadcn-vue

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 code

<script setup lang="ts">
import { computed } from "vue";
import type { ColumnDef } from "@adapttable/vue";
import { buildFormulaColumns, useFormulaUrlState } from "@adapttable/vue/formula";
import { DataTable } from "@adapttable/shadcn-vue";

const props = defineProps<{
  rows: readonly Person[];
  baseColumns: readonly ColumnDef<Person>[];
}>();

const rowKey = (row: Person) => row.id;
const state = useFormulaUrlState({
  urlKey: "fx",
  defaultFormulas: [
    { key: "margin", header: "Margin", formula: "=ROUND(budget * 0.15, 0)" },
  ],
});
const columns = computed(() => [
  ...props.baseColumns,
  ...buildFormulaColumns<Person>(state.formulas.value).columns,
]);
</script>

<template>
  <DataTable :data="rows" :columns="columns" :row-key="rowKey" />
</template>

Install

pnpm add @adapttable/shadcn-vue @adapttable/vue @adapttable/core reka-ui

The same feature in the other kits

• Spreadsheet formulas in Vue Unstyled — Native elements — your own CSS
• Spreadsheet formulas in Element Plus — Element blue, crisp form controls
• Spreadsheet formulas in Vuetify — Material Design, Vuetify blue
• Spreadsheet formulas in Naive UI — Clean, compact, green accent
• Spreadsheet formulas in Reka UI — Accessible primitives, neutral theme
• Spreadsheet formulas in Nuxt UI — Tailwind-native, Nuxt green
• Spreadsheet formulas in Quasar — Material-flavoured, Quasar blue

More shadcn-vue features

• Filtering in shadcn-vue — Ranges, selects, an AND/OR tree and chips — all in the URL.
• Column management in shadcn-vue — Show, hide, reorder, pin and resize — from a menu you did not write.
• Column groups in shadcn-vue — Spanning headers that collapse to a stub, a kept child, or a custom cell.
• Row selection in shadcn-vue — A set of ids that survives paging, with bulk actions over it.
• Rows in shadcn-vue — Pin rows from a 3-dot menu, and merge a team that runs down the page.
• Row reordering in shadcn-vue — Drag or keyboard moves, announced — the host writes.
• Inline cell editing in shadcn-vue — Native editors in the cell; every write goes through your handler.
• Row grouping in shadcn-vue — Drag, select or keyboard grouping, with totals in the headers.
• Aggregation in shadcn-vue — Footer totals, pinned summaries, group aggregates — not data rows.
• Nested tables in shadcn-vue — A real table under a row — same engine, own columns, own keys.
• CSV export in shadcn-vue — One toolbar button, a CSV of the table as it stands.
• Row and column virtualization in shadcn-vue — 40,000 rows in a scroll box, only the visible ones rendered.
• Tree data in shadcn-vue — Nesting, chevrons, lazy children, and a tree on phones.
• Mobile cards in shadcn-vue — Every row becomes a card on phones. Automatically, with the same state.
• Pivot tables in shadcn-vue — Rows down the side, dimensions across the top, subtotals at every level.
• Saved views in shadcn-vue — Name an arrangement and restore it from the menu.
• Right-to-left shadcn-vue data table — Arabic strings, a flipped axis, and a popover that opens from the right edge.
• Live updates in shadcn-vue — Rows change while you read them. Sort and selection hold.
• Accessible shadcn-vue data table — Arrow-key focus, a visible ring, forced-colors, and live announcements.
• AI table assistant in shadcn-vue — Local sort, questions and approved edits with real table outcomes.

Reference: formulas. More of this kit: AdaptTable for shadcn-vue, or the live demo.