Pro and Classic
Qron Calc Macro ships two macros. They look the same on the page and share the same Formula Settings dialog, but they differ in how they calculate.
Comparison
Section titled “Comparison”| Item | Calc Macro Pro | Calc Macro Classic |
|---|---|---|
| Available formulas | Approximately 390 functions — the same set as Classic. See Supported Formulas | Approximately 390 functions |
| Cell coordinates | The header is included. The top-left cell of the table is A1. | The header is excluded. The first cell below the header is A1. |
| References | Can refer to other tables on the page and to the results of other macros. | Only the macro’s own table. Cells that hold other macros cannot be referenced. |
| Recalculation | Calculated when the page is created or updated, and the result is stored. If the page has changed since then, the value is recalculated when the page is displayed. | Calculated on demand, every time the macro is displayed. |
| While editing | The result updates as you change referenced cells or the formula, including in live docs. | Same |
| Display speed | Faster — the stored value is shown as-is while the page is unchanged. | Slower on large tables, because every view recalculates. |
| PDF export | The calculated value is rendered in the exported PDF, matching the surrounding text. | The calculated value is rendered, but its font does not match the rest of the page. |
| Number format | Same options for both macros — see Number format | Same |
The Formula Settings dialog shows which macro you are editing in its title, for example Formula Settings (Pro) or Formula Settings (Classic).
Which one should I use?
Section titled “Which one should I use?”Use Calc Macro Pro for new pages. Pro is the macro under active development: it supports the same functions as Classic, can refer to other tables and to other macros’ results, and exports cleanly to PDF.
Keep Calc Macro Classic on pages that already use it. When you rewrite a Classic formula for Pro, keep in mind the different cell coordinates: shift each reference by the header rows and columns that Classic skipped.
Migrated macros
Section titled “Migrated macros”Macros created with the previous version of the app become Calc Macro Classic macros. That preserves the original behaviour — the same formulas, the same header-excluded coordinates, and the same on-demand calculation — so migrated pages display the values they displayed before.
If you want a migrated macro to gain the Pro behaviour, replace it with a Calc Macro Pro macro and adjust the cell references for the header-included coordinate system.