AdaptTable for Angular Aria

Spreadsheet formulas in Angular Aria

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

import { Component, computed, input } from "@angular/core";
import type { ColumnDef } from "@adapttable/angular";
import { buildFormulaColumns, injectFormulaUrlState } from "@adapttable/angular/formula";
import { AdaptDataTable } from "@adapttable/angular-aria";

@Component({
  selector: "app-computed-people",
  imports: [AdaptDataTable],
  template: `
    <adapt-data-table
      [data]="rows()" [columns]="columns()" [rowKey]="rowKey"
    />
  `,
})
export class ComputedPeople {
  readonly rows = input.required<readonly Person[]>();
  readonly baseColumns = input.required<readonly ColumnDef<Person>[]>();
  readonly rowKey = (row: Person) => row.id;
  readonly state = injectFormulaUrlState({
    urlKey: "fx",
    defaultFormulas: [
      { key: "margin", header: "Margin", formula: "=ROUND(budget * 0.15, 0)" },
    ],
  });
  readonly columns = computed(() => [
    ...this.baseColumns(),
    ...buildFormulaColumns<Person>(this.state.formulas()).columns,
  ]);
}

Install

# Follow the kit setup guide for compatible peers
pnpm add @adapttable/angular-aria @adapttable/angular @angular/aria@22.2.1 @angular/cdk@22.2.1 @angular/forms@^22 rxjs@^7.8.2

The same feature in the other kits

• Spreadsheet formulas in Unstyled — Native elements — your own CSS
• Spreadsheet formulas in NG-ZORRO — Ant Design components for Angular
• Spreadsheet formulas in Angular Material — Material surfaces, native controls
• Spreadsheet formulas in ng-bootstrap — Bootstrap styling, Angular overlays
• Spreadsheet formulas in ngx-bootstrap — Bootstrap controls and overlays
• Spreadsheet formulas in Angular CDK — CDK behavior, a neutral theme
• Spreadsheet formulas in Spartan — Sharp borders, subtle elevation
• Spreadsheet formulas in Taiga UI — Soft surfaces, expressive controls

More Angular Aria features

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

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