We are developing anITIL service cat using a confluence space and have created the detail in an excel spreadsheet - this was imported using the macro.
How do we link from a simple service description entry on a seperate page to a specific cell in the spreadsheet?
There's an add-on for enterprise spreadsheets in Confluence which allows you to create and edit tables online, then copy-paste rows or excerpts to display them on pages.
See the release notes: https://documentation.play-sql.com/display/PUBLIC/Release+Notes+2.3
My suggestion is to use the Anchor macro, create for every cell a unique Anchor Name (related to the content of the cell)
This macro content could be generated by using a script where the default-parameter is the variable. The following example could be inserted between the <td> and </td> tags:
testcel2 = the value of the anchor-name
Your answer is the best fitting solution. The suggestion of JohnnyMac helps slightly, because the anchor-links are not shown while try to link to a page(s) containing the anchors. The https://documentation.play-sql.com/display/PUBLIC/Column+Types+and+Renderers specifies the possibilities with the Play SQL addon.
Thanks, both of you,
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG