nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Table Spreadsheet in Table Transformer macro

Bart Hoegaerts

Hi all,
I would like to use the Table Spreadsheet macro on an input page to allow users to feed in data in the spreadsheet in the page view mode.

After the input is doen by the users, I would like to use the Table excerpt macro to bring the contents of the spreadsheet into the Table transformer macro to merge and join with other tables i have on different pages.

When I do this, the Table transformer is not showing any data.

What can I do to solve this or is there an alternative?
Thanks !

Accepted answers

Katerina Kovriga {Stiltsoft}

Hi @Bart Hoegaerts ,

Maybe I've got the case wrong, but here is how it works for me:

the Table Spreadsheet macro is wrapped into the Table Excerpt macro
the Table Excerpt Include macro that refers to this Table Excerpt macro is wrapped into the Table Transformer macro
as a result, I see the table and the name of the sheet that contains it

Fri 3-1.png

Fri 3-2.png

All comments

Katerina Kovriga {Stiltsoft}

Hi @Bart Hoegaerts ,

Maybe I've got the case wrong, but here is how it works for me:

the Table Spreadsheet macro is wrapped into the Table Excerpt macro
the Table Excerpt Include macro that refers to this Table Excerpt macro is wrapped into the Table Transformer macro
as a result, I see the table and the name of the sheet that contains it

Fri 3-1.png

Fri 3-2.png

Bart Hoegaerts

Hi Katerina,
thanks for your response; unfortunatly this is how I tried it in the first place.

I created A table spreadsheet in aTable excerpt macro

which I then include in the Table transformer with the Table Excerpt Include macro

when I open the Table transformer to preview I only get a few lines and boxes as a result.
no data from the actual spreadsheet.
(did saved and updated the pages at every step to make sure everything is published)

Also in the published view I only see a rectangular box with no content

Should I report this as a bug? as clearly it should be a working feature as it is working in your example.

Thanks !
Bart

Katerina Kovriga {Stiltsoft}

Yes, please, raise a support request - we have the same macro' structure and it should be working fine.

Attach the screenshot of your Table Spreadsheet macro or the macro itself as an attachment (the portal is confidential and our support team will try to recreate exactly your source table and look into the issue).

Bart Hoegaerts

Thanks! I have submitted a support case.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

cloud

confluence-cloud