CONFLUENCE DATA CENTER

Overview

'Qron Calc Macro' makes you able to embed MS-Excel formulas into standard Confluence Tables.

You can use many types of excel formulas, such as SUM(A1:E2), COUNTIF(A1:E2, ">5"), so on.

90-sec demo -

What's New

The latest version is 1.1.12

Data Center support

Release notes of Qron Calc Macro for Confluence Data Center

How to use

It is straightforward.

You only put 'Qron Calc Macro' on the Confluence standard table, then enter a formula in the macro body.

And also, you can set numeric format, text alignment, and text style optionally.

Given a formula "sum(b1:b5)" and a format for accounting section and emphasized style will be displayed like a following.

Here are Live examples( They run on the cloud version. So there are slight differences with the server version. The server version is more straightforward than the cloud version.)

Functionality

Features	Overviews
Sheet reference	Refer to cells in the other table using the following notation. <Sheet number>!<R1><C1>:<R2><C2> <Sheet number> ← sequential number from the top table which starts from 1 <Rx> ← row number which starts from 1 <Cx> ← column string which starts from A
Inline editing	Direct edit in page view mode via Action panel. Select calculated text and click the button in the red box. Clicking the formula makes you be able to edit it. 3. You will be received a notification that the formula is updated. Then, you can reload the page by clicking 'Reload page'.
Row/Column tags	It shows Sheet/Row/Column tags in inline-editing mode.
Recalculate calc macros	Recalculate all calc macros on a page.
Importing Excel sheet BETA	Import your Excel sheet as a Confluence standard table on-page edit mode. How to import your Excel sheet into Confluence page To use this beta feature, you need to turn on the option in the Settings admin page. For example, the following sheet which contains formulas will be imported like this, 'Excel import' inserts 'Page property macro' for calculating the table under FixedOrigin mode(origin cell is always the top-left cell). If you delete the macro, tables will be calculated under AutoOrigin mode(the origin cell is a top-left cell in the non-header area). 'Importing Excel sheet' cannot be available in the following case; The page using PDF macro The page using 'Inplace Editor for Confluence' Handy Macros for Confluence installed