Overview
Qron Calc Macro lets you embed MS-Excel formulas into standard Confluence tables. Add a macro with a SUM function to your existing table and you can skip the calculator—your table gains spreadsheet-like calculation power.
You can use Excel-style formulas, such as SUM(A1:E2), AVERAGE(A1:E2), and more.
KEY FEATURES
Section titled “KEY FEATURES”- Excel-style formulas evaluated against ordinary Confluence tables
- Results update as you edit referenced cells or formulas, including in live docs
- Write each formula on a view of your table in the Formula Settings dialog
- Format specifications similar to Excel
- Sheet reference between tables on the same page
Two macros
Section titled “Two macros”The app provides two macros, and both can be used on the same page:
| Macro | Choose it when |
|---|---|
| Calc Macro Pro | You are building a new page. It is the current macro: values are kept in sync when the page is updated, it can refer to other tables and other macros’ results, and calculated values are rendered in PDF exports. |
| Calc Macro Classic | You are maintaining a page that already uses it. |
See Pro and Classic for the full comparison, and Examples for worked examples.