Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Confluence table spreadsheet recalculation

lin min
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
July 20, 2022

I have a wiki page in confluence which include a table spreadsheet macro, I put NOW() in one cell to indicate current date & time, I would like to recalculate this formula every 1 minute to reflect current timestamp, is it doable? 

3 answers

3 votes
Alexey Mikhaylov _Stiltsoft_
Contributor
August 3, 2022

Hello Lin,

Thanks for using our Table Filter and Charts for Confluence app!

Please note it is not possible to implement your use case in Table Spreadsheet. Reloading the page will not also refresh the current date & time.

The spreadsheets are saved as attachments to the Confluence page. Therefore, the data do not refresh live, they stay as entered and saved into the spreadsheet.

Best regards,

Alexey

Katerina Rudkovskaya _Stiltsoft_
Atlassian Partner
December 5, 2022

Hi @lin min,

Here is an update from our team: now the Table Spreadsheet macro recalculates all the dates automatically after you reload the page.

Like # people like this
0 votes
Shardul Juyal_Addteq_
Contributor
August 3, 2022

Hi @lin min 

You can use our Excellentable spreadsheet app. You will be able to use the same formulas as your regular spreadsheet.

However, in the view mode you will have to refresh the page to get the new time.

 

Regards, Shardul 

0 votes
Dominic Lagger
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 25, 2022

Hi @lin min 

I don't think this is possible, you would have to reload the whole page.

Regards, Dominic

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events