AnnexCREATE · Index · Tutorials · AnnexCalc

AnnexCalc – Getting started (Tutorial)

A hands-on walkthrough ("your first hour with AnnexCalc"). Whitepaper format, PDF-ready. Screenshots are captured according to the shot list at the end.

Goal of this tutorial

By the end you will have created a small budget sheet as a .axsheet document: with values, a SUM formula, currency formatting and a title – saved and exported as XLSX.

Step 1: Launch the app and open a sheet

AnnexCalc window after launch with an empty cell grid

Start AnnexCalc from AnnexHub. An empty sheet opens in the three-column layout: sheet info and assets on the left, the cell grid in the middle, the inspector on the right. Open an existing .axsheet via File ▸ Open… (⌘O).

Step 2: Enter values

Cell grid with a few numbers entered

Click a cell and enter a value, for example monthly costs stacked in one column. Confirm the entry with Enter. This fills a small cost list quickly.

Step 3: Write a SUM formula

Cell with the formula =SUM(...) and its result

In the cell below your values write a formula, for example =SUM(B1:B5). AnnexCalc calculates ranges, cell references and the functions SUM, AVG, MIN, MAX – with the German decimal comma. After Enter the cell shows the result.

Step 4: Set the title and extend the sheet

Inspector with the sheet title and the toolbar for extending

Enter the sheet title in the inspector on the right, for example "Budget 2026". Need more room? Extend rows and columns via the toolbar. There is one sheet per document.

Step 5: Assign a currency format

Format menu with the currency format selected

Select a result cell and choose the Currency format in the Format menu or via the format picker in the inspector. The format is display-only: the stored value and the calculation stay unchanged, while print and export carry the formatting.

Step 6: Read the evaluations

Inspector and sidebar with column sum, grand total and formula cells

In the inspector you read the raw value/formula and result of the selected cell as well as the column sum and grand total. The sidebar lists all formula cells – a click jumps to the cell in grid and inspector.

Step 7: Save as .axsheet

Save As dialog for an .axsheet file

Save the sheet with File ▸ Save (⌘S). The first time you choose the location ("Save As…", ⌘⇧S); afterwards ⌘S saves directly. If autosave is enabled in the settings, it additionally saves silently on an interval.

Step 8: Export as XLSX (or print)

Export dialog with the formats CSV, XLSX, ODS and PDF

Via File ▸ Export… or the toolbar button "Export" you choose the format. For handing on to Office take XLSX; for a fixed view take PDF. XLSX/ODS/PDF carry the number formats. Alternatively print directly with File ▸ Print… (⌘P).

Result & next steps

You created a budget sheet with values, a formula, currency formatting and a title, saved it as .axsheet and exported it as XLSX. More on all features, formats and MCP automation is in the manual (docs/manuals/en/AnnexCalc.md) and in the authoritative feature list .

Shot list (for screenshot capture)

File Content Window state Sample data
calc-01.png Launch window, empty cell grid, three columns visible Light theme, window ≥1280×800 pt, sidebar + inspector shown empty sheet
calc-02.png Cell grid with numeric values entered Grid centered, one cell in edit mode 5 cost values in column B
calc-03.png Cell with a formula and its calculated result Result cell selected =SUM(B1:B5)
calc-04.png Inspector with the sheet title, toolbar visible Inspector on the right, title field active title "Budget 2026"
calc-05.png Format menu open, currency with a checkmark Format menu expanded currency format on the result cell
calc-06.png Inspector (column/grand total) and sidebar (formula cells) both columns shown formula cell list with one entry
calc-07.png NSSavePanel when saving as .axsheet Save dialog open file name "Budget 2026.axsheet"
calc-08.png Export dialog (confirmation dialog) with CSV/XLSX/ODS/PDF Export dialog open XLSX selected