Simple Features for next upgrade

Is your feature request related to a problem? Please describe.

No response

Describe the solution you'd like

Hello Nextcloud Tables team,

First of all, thank you for the amazing work on the Tables app — it’s becoming one of the most powerful and flexible tools in the Nextcloud ecosystem. I’d like to suggest a few improvements that would significantly enhance its usability and analytical power, especially for project management, CRM, and internal data tracking use cases.

1️⃣ Add a “Total Row” for Sums and Counts

Request: Allow adding a total row at the bottom of a table that can automatically sum numeric columns and count rows.
Why it helps:

Provides quick overviews without exporting data.

Useful for tracking budgets, quantities, and statistics at a glance.

Reduces the need for external tools (e.g., spreadsheets) for simple summaries.

2️⃣ Column References (Simple Relations Between Columns)

Request: Enable columns to reference values from other columns, possibly across tables (like a simplified relational field).
Why it helps:

Makes it possible to create data connections (e.g., linking a “Company” column to a “Companies” table).

Enables reusing data efficiently without duplication.

Allows building lightweight relational structures directly within Tables.

3️⃣ Formula Columns

Request: Support columns that can hold formulas (e.g., =[ColumnA] + [ColumnB], =[Price]*[Quantity], or conditional logic).
Why it helps:

Enables simple data computation without external scripts.

Makes Tables far more powerful for finance, inventory, or engineering logs.

Greatly increases automation and consistency in data entry.

4️⃣ Thousand Separator for Number Columns

Request: Add an option to show thousand separators (e.g., 12,345 or 12 345) in number columns.
Why it helps:

Improves readability for financial and large numeric data.

Makes tables easier to interpret in dashboards and reports.

5️⃣ Number Formatting with Custom Prefix / Zero-Padding

Request: Allow custom number formatting, such as zero-padded values (004, 010, 100).
Why it helps:

Useful for codes, IDs, and reference numbers that need consistent length.

Improves sorting and presentation in structured tables.

6️⃣ Auto Row Counter

Request: Add a column type or toggle option for an automatic row counter that numbers rows sequentially.
Why it helps:

Simplifies indexing and tracking rows in large datasets.

Makes referencing rows in discussions or reports much easier.

Saves manual effort when sorting or filtering data.

Describe alternatives you've considered

No response

Additional context

No response

No files, tests, or entry points are named. First separate the six requests and inspect the Tables app's existing table and column implementation to determine which parts are already supported; a useful result requires an agreed scope, implementation plan, and acceptance tests for each selected feature.