Are you in the loop? Keep up with the latest by making sure you're subscribed to Community Announcements. Just click Watch and select Articles.

×
Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Celebration

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

'Table Spredsheet Include' Macro

Matt
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!
Nov 08, 2023

Hi,

I was trying to create a table or spreadsheet on a confluence page which pulled / referenced data from an attached excel spreadsheet.

I realized that this could be done in two ways.

1) Attach Spreadsheet to the confluence page and use 'Table Spreadsheet' Macro to view the data as an embedded spreadsheet

2) Attach Spreadsheet to the confluence page and use 'Table Spreadsheet include' Macro to view the data as Table.

The latter was my preferred option but upon trialing it in various instances I realised the 'Table Spreadsheet' include macro only worked when 'Table Spreadsheet' had been previously used and the excefilename.render and excelfilename.tfss had been created.

Surely I should be able to attach a spreadsheet to a page and use 'Table Spreadsheet Include' without having to use 'Table spreadsheet' first?

Thanks

1 answer

2 votes
Marc Koppelaar
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.
Nov 08, 2023

Hi @Matt 

I see you use the app Table Filter and Charts for Confluence.

And according to their documentation the option 2 is the way this is working, as the include needs the Table Spreadsheet Macro.

The Include macro's purpose is to make an excerpt of the spreadsheet on other Confluence pages.

It has the same way of working as the ootb Confluence macro's.

  • Excerpt
  • Excerpt Include

If you are thinking their should or could be another way, I suggest you to reach out to Stiltsoft support and mention your question.

Stiltsoft support
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.
Nov 08, 2023

Hi @Matt ,

Indeed the Table Spreadsheet Include macro was developed to reuse the parts of the Table Spreadhseet macro across your Confluence.

The behavior that was kindly explained by @Marc Koppelaar is correct. 

Like # people like this

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
FREE
PERMISSIONS LEVEL
Site Admin
TAGS
AUG Leaders

Atlassian Community Events