CONFLUENCE SERVER
Overview
'Qron Calc Macro' makes you be able to embed MS-Excel formulas into standard Confluence Tables.
You can use many type of excel formulas, such as SUM(A1:E2), COUNTIF(A1:E2, ">5"), so on.
90 sec demo -
What's New
Latest version is 1.1.1
- Inline Edit
- Display Row/Column tags while inline-editing
How to use
It is very simple.
You only put 'Qron Calc Macro' on Confluence standard table, then enter a formula in macro body.
and also you can set numeric format, text alignment, text style optionaly.
Given a formula "sum(b1:b5)" and a format for accounting section and emphasized style will be displayed like a following.
Here is Live examples(
They run on cloud version. So there are slight differences with server version. The server version is simpler than cloud version.)
Functionality
| Features | Overviews |
|---|---|
| Sheet reference | Refer cells in other table using the following notation. <Sheet number>!<R1><C1>:<R2><C2> <Sheet number> ← sequential number from top table which start from 1 <Rx> ← row number which start from 1 <Cx> ← column string which start from A
|
Inline editing NEW | Direct edit in page view mode via Action panel.
3. You will be received a notification that the formula is updated. then, you can reload the page by clicking reload link. |
Row/Column tags NEW | It shows Sheet/Row/Column tags in inline-editing mode.
|
Supported Formulas
Supported formulas (389 formulas)
Public Issue Tracker
Issue Tracker (and Questions & Answers)
Roadmap
- Importing Excel sheet COMING SOON
- Refer field values of Jira issues
Limitations
- IFERROR function don't work correctly when be evaluated with false
- display error message such as '#DIV/0!'