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.2
- Excel import (beta feature)
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. |
Importing Excel sheet BETA | Import your Excel sheet as Confluence standard table on page edit mode. For example, the following sheet which contains formulas will be imported like this, For heading cells of imported table, please use 'Change cell color'() instead of 'Heading row' / 'Heading column' because heading cells break coordinate system of calculations. : Don't use 'Heading row' / 'Heading column' |
Supported Formulas
Supported formulas (389 formulas)
Public Issue Tracker
Issue Tracker (and Questions & Answers)
Roadmap
- 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!'