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 | 7 core functions — 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. |
| Recalculation | Calculated when the page is created or updated. The result is stored, so displaying a page does not recalculate. | Calculated on demand, every time the macro is displayed. |
| Display speed | Faster — the stored value is shown as-is. | 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 unless you need a formula it does not support yet. Pro is the macro under active development, and it is the one that exports cleanly to PDF.
Switch to Calc Macro Classic when your formula is outside Pro’s function set. Keep in mind the different cell coordinates: a formula written for Classic has to be shifted by the header rows and columns that Classic skipped when you rewrite it for Pro.
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.