Versions Compared

Old Version 17

changes.mady.by.user K A

Saved on

compared with

New Version 18

changes.mady.by.user K A

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Status
subtletrue
colourGreen
titleConfluence
 
Status
subtletrue
colourBlue
titleserver
 

...

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


90 sec demo -

Widget Connector
width800
urlhttps://www.youtube.com/watch?v=hWQCkYUhDOw&t=15s&rel=0
height400

What's New

Latest version is 1.1.2

How to use

It is very simple. 

...

FeaturesOverviews
Sheet reference

Refer cells in other table using the following notation.

Panel

<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

Status
subtletrue
colourBlue
titlenew

Direct edit in page view mode via Action panel.

  1. Select calculated text and click the button in the red box.
  2. Clicking formula make 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 link.

Row/Column tags

Status
subtletrue
colourBlue
titlenew

It shows Sheet/Row/Column tags in inline-editing mode.


Importing Excel sheet

Status
subtletrue
colourYellow
titlebeta

Import your Excel sheet as Confluence standard table on page edit mode.

How to import your Excel sheet into Confluence page


For example, the following sheet which contains formulas

will be imported like this,

Note

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.


 : Use Change cell color

: Don't use 'Heading row' / 'Heading column' 


...

  • IFERROR function don't work correctly when be evaluated with false
    • display error message such as '#DIV/0!'