Angular-Tabellenkalkulationskomponente | ng-hub-ui-spreadsheet
Bearbeitbare Angular-Tabellenkalkulation mit der Tastatur von Excel, rechteckiger Auswahl, einer Zwischenablage, die mit Excel hin und zurück funktioniert, fixierten Bereichen und verbundenen Zellen. MIT, barrierefrei, ohne Bezahlstufe.
Interaktive Beispiele
Erkunde Live-Beispiele, die zeigen, wie sich die Bibliothek in gängigen Angular-Anwendungsfällen verhält.
Bearbeiten und Zwischenablage
Ein bearbeitbares Blatt
Click a cell and type, or press F2 to edit keeping the value. Enter commits and drops a row, Tab commits and moves right. Drag to select a block, and hold Ctrl (Cmd) while clicking to pick a second one somewhere else.
Kopieren und Einfügen mit Excel
Select a range, copy it, and paste it into Excel. Or the other way round.
Spaltentypen und ein eigener Editor
A click picks a cell; a double click, F2 or simply typing opens it. Open Status for a list, Due for a date and Assignee for a searchable hub-select supplied by this page; Billable takes one click on its box. Start is a time field supplied by this page too: Enter, Tab or clicking away keeps what you typed, Escape gives it up. Hover an empty Due or Assignee cell to see its hint — and the Patch panel row's Due carries one of its own, because that cell is waiting on the cabling rather than on a date format.
Formeln über Alias und über Koordinate
Change a quantity and the totals follow. Open a Total cell to see the formula, and the last row to see a column added up.
Die Zellen einer Spalte selbst zeichnen: Abzeichen und Aktionen
Pick a row and use the actions at the end. Copy the State column into a spreadsheet: what travels is paid, not the badge. The box in the Sent header ticks every order, or clears them all. Rest on the late total, or reach it with the keyboard, to read its note.
Die Kopfzeile einer Spalte selbst zeichnen: ein Bearbeiten-Knopf
Press Edit in the Price header: the column does not start moving.
Eine Control-Bibliothek einmal verdrahten statt ein Template je Spalte
Queue and Severity have no editor of their own. Open one and it is the house select, with its search box.
Form des Blatts
Fixierte Zeilen und Spalten
Scroll sideways and down. The region column and the first row stay put, and the seam is drawn on the last frozen track.
Verbundene Blöcke
The Monday workshop spans two hours, and Wednesday's review spans three. Arrow into one, then try selecting only part of it. Select a rectangle and right-click to put it together, or right-click a block to take it apart.
Zehntausend Zeilen mal fünfzig Spalten, von denen das Dokument einen Bildschirm hält
10,000 rows and 52 columns. Scroll either way: the document holds a screenful at a time, and the first column stays put.
Ausfüllkästchen, und ein Ziehen in einem Schritt zurücknehmen
Select the two codes, then drag the corner square down. Or select a cell and the ones below it and press Ctrl+D (Cmd+D on a Mac) to copy it down. Undo with Ctrl+Z.
Spalten in der Breite ändern und umordnen, und Zeilen umordnen
Drag the right edge of a header to widen it. Hover a row or a column and drag the grip that appears to move it; a header can be dragged by itself too. From the keyboard, Alt+Shift with the up or down arrow moves the row the cursor is on.
Zustand und Struktur
Speicherzustand je Zelle
Edit a price. Anything ending in 9 fails on purpose, so you can see the error state.
Text, den eine Zelle nicht speichern kann, bleibt sichtbar
Type 7x into a Qty or a Price, then click Save or anywhere outside the sheet. The text stays, ringed, and Save waits. Open the cell to correct it, press Escape there to give it up, or right-click its row and delete it.
Zeilen und Spalten hinzufügen und entfernen
Add a column, remove it, add another: the alias never comes back.
Add a line and the cursor is already on it: start typing. Add a note and its field is already open. Copy a few lines from anywhere and paste them on the last one, and the sheet asks for the rows it runs past before it fills them.
Aliases handed out so far
description · col-1Validierung je Zelle mit Signal Forms
Hinaus nach Excel oder CSV — und zurück
Export it, open it in Excel, change a quantity, save it and bring it back.
Was eine Zelle zeigt und öffnet
Eine Spaltengruppe, die sich einfalten lässt
Cost and Margin are one group. Press the small − just above the Cost header to fold them away, and the + that takes its place to bring them back. Right now they are in view.
Eine Zeilengruppe, die sich unter ihrer Überschrift einfaltet
Each heading has its lines under it. Press the − at the leading edge of a heading to fold its lines away, and the + that takes its place to bring them back. Everything is in view.
Eine Zelle, die sagt, wovon sie leer ist
Every discount is empty. Hover one: most say no discount — the column's own hint — but the line under agreement says what it is really empty of, because that cell carries a hint of its own.
Eine Menge mit ihrer Einheit, aus einer Liste gewählt
Press a unit or a % to choose another, or open the list from the cell with Alt+↓. A copied quantity goes out as 2 d; pasting 15 € into a discount changes both parts.
Zellen, die etwas öffnen
Aim at a name with prices behind it and press Enter, or at a price with an arrow and press Alt+Enter (Option+Enter on a Mac).
Eine Zeile an Ort und Stelle geöffnet