This article gives you step by step instructions to perform advance calculations in Excel macro using the GoEdit app.
By using GoEdit, you can open and edit the spreadsheets that are attached to the confluence page. That way, the spreadsheets can be edited on the fly. You can skip these steps: Download → Edit → Re-attach. Also, it helps to edit the data in the attachment without impacting your Excel formula.
Instructions
- Login as Confluence Admin.
- Click
> Manage apps > Find new apps to install the GoEdit app.
- Go to the respective space and create a page with attachment(s).
- Click on the page edit link.
- Add the macro Excel for Confluence and mention the Name of attachment then click Save.
- You can find an option: Edit directly above to the attachment details as shown in the below screenshot:
- Click on Edit directly to edit the data. A pop up appears on your screen. Click Open GoEdit to proceed with editing and click Install
Note: If you are using this option for the first time using GoEdit, it prompts you to install it on your computer.
- This will open the excel sheet. You can make the required changes and save the excel.
Example:
Before editing:
After editing:
9. The below screen pops up, click Save Attachment.
- You can see the data got edited now for user3 as shown in the below example:
- You can also find the data also got updated as per the calculation made in the excel sheet:
Example:
Before editing:
Edited the below data:
After editing:
First, implement the GoEdit app with HTML for Confluence macro in a staging environment before implementing it in the production.