CalcBase and AI-Hub — a spreadsheet that writes plain HTML, and one AI hub for every Nextcloud app

Hello everyone,

I have published two new apps on the App Store: CalcBase, a spreadsheet, and AI-Hub, a hub that connects Nextcloud apps to AI.

CalcBase — a spreadsheet that writes plain HTML

CalcBase grew out of the spreadsheet part I wrote while developing EditBase — the tables in EditBase that calculate — and has become an app of its own.

Every workbook is saved in your Files as a single self-contained .html file. Each sheet is an HTML table, with the values, formulas, number formats and styles written into the page itself, so a workbook opens and reads correctly in any browser, even without CalcBase. Open it in CalcBase and it is a live spreadsheet again.

  • Formulas are written as in LibreOffice Calc, with about 500 functions. Where Calc and Excel differ, Calc is followed; the engine’s test suite (3,563 checks, many of them LibreOffice’s own answers) passes.
  • Import and export of CSV, ODS and XLSX, and import from RegiBase, FormulaBase, EditBase, NetBase, Tables, Contacts, Calendar, a web page or a Markdown file.
  • The same screen as EditBase, light and dark themes, English and Japanese.
  • An AI assistant (through AI-Hub) that explains and writes formulas and changes cells when asked; every change can be undone.
  • It is made for tables kept by hand, not for bulk data: by default a book holds up to 100,000 cells (30,000 rows a sheet, 24 MB a file). The limit can be raised in the settings, at your own risk.
  • Not there yet: charts, pivot tables, conditional formatting, data validation, array formulas, macros, and several people editing one workbook at once.

A sheet with formulas
Bringing in sheets from the other apps

AI-Hub — one AI hub for Nextcloud apps

AI-Hub is the AI engine of Talk-Bot, split out into an app of its own. It is not only for my apps: it gives any Nextcloud app a hub to AI. An app registers a “scenario” — what the assistant is, what it may do, and what shape its answers take — and sends the user’s words; AI-Hub chooses the engine, runs the conversation and hands back an answer the app can act on. The key, the model and the limits are set once, in one place, for every app on the server.

  • Engines: Claude and Gemini through their APIs, any OpenAI-compatible endpoint (OpenRouter, Mistral, Groq, OpenAI, or your own Ollama, vLLM or LM Studio), and the Claude Code or Gemini command line where it is installed on the server.
  • An engine, a model and an additional prompt for each app; images with a question; conversations kept for the length of a login, which can be saved to Files or summed up.
  • It is also a provider for Nextcloud’s own Task Processing API, so Nextcloud Assistant and other apps can use the connected models without knowing AI-Hub exists.
  • The specification is public. The README documents the PHP API, the OCS REST API and the Task Processing route, with examples, so anyone can connect their own app to AI-Hub freely, with no change to AI-Hub itself. It is AGPL-3.0.

For this reason, AI-Hub is required to use the AI assistant in Talk-Bot and in the Base series (EditBase, CalcBase, RegiBase, FormulaBase and NetBase). The Base apps themselves work without it; only the assistant needs it.

Choosing the AI engine
An AI and a model for each app

Please help them grow

The Base series and AI-Hub are all still young apps. Your bug reports and your comments on what is wrong or missing are what help them grow most, so please tell me about anything you find. A reply to this post is just as welcome as an issue on each app’s GitHub.

My apps

  • AI-Hub — one AI hub for every app on your Nextcloud. App Store · GitHub
  • CalcBase — a spreadsheet whose workbooks are plain HTML files, with LibreOffice Calc formulas. App Store · GitHub
  • EditBase — a word processor whose documents are plain HTML files; what you see is what prints. App Store · GitHub
  • RegiBase — your passwords and records, the way you want them, with secret fields encrypted in your browser. App Store · GitHub
  • FormulaBase — the calculator that remembers your formulas, with more than 5,500 templates. App Store · GitHub
  • NetBase — every device on your network, and its own settings page, from anywhere through Nextcloud. App Store · GitHub
  • Talk-Bot — an AI assistant in Nextcloud Talk, through AI-Hub. App Store · GitHub

Interesting concept, especially the idea of keeping the HTML output simple and portable rather than depending on a complex format. A shared AI hub across Nextcloud apps could also be useful if it avoids each app having to implement the same functionality separately. I’d be interested to see how permissions and data privacy would be handled between different apps.

@shanewatsonlatest Thank you!

With EditBase and CalcBase, I aimed for something simple and lightweight that needs nothing but Nextcloud and the apps themselves. I kept the output to HTML so that it works anywhere, on any device, and out of respect for what HTML was made for. And above all, isn’t it fun that the output is just HTML? HTML, CSS and JavaScript will keep evolving, and the apps only have to keep up with them. When you send a document to someone, it is almost always a PDF, so nobody is left stuck. I concluded that saving as HTML makes sense in every way.

Privacy between apps is something I designed carefully in each app. RegiBase, where security matters most, is protected by the user’s master key. AI-Hub basically runs in a sandbox, and I took care that it never goes beyond its permissions.