This article explains how to do advance provides step by step instructions to perform advanced calculations in Excel macro using the GoEdit app. Use GoEdit to
By using the GoEdit app, you can open and edit the spreadsheets that are attached spreadsheets to the confluence pages "in place". That way you do not have to download the file and change it then re-attach it. It will help page. GoEdit enables you to edit spreadsheets 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
...
- Log in as Confluence Admininto your Confluence instance as an administrator.
- Click Navigate to > Manage apps > Find new apps to find and install the GoEdit app.
- Go to the intended space and create a page with attachmentsattachment(s).
- Click on the page edit link to edit the page.
- Add the macro Excel for Confluence and mention , mention the Name of attachment . Click on and click Save button.
- Edit directly option will show above You can find an option: Edit directly above to the attachment details as shown in the below screenshot.:
- Click on
Click Edit directly to edit the data.
Below option willA pop up appears on your screen
, click on. Click Open GoEdit to proceed with editing and click
on install button.
The first time when you edit attachmentInstall
it will askNote If you are using this option for the first time using GoEdit,
you are prompted to install it on your computer.
- This will open the The excel sheet opens, here where you can make the required changes and save the excel.
Before Example - Before editing:
After After editing: - The When prompted by the below screen will pop-up, click on Save Attachments, click Save Attachment.
The data got You can see the data is edited now for user3. as shown below:
Refer to the below example where editing the data will also update You can also find the data is updated as per the calculation made in the excel sheet. :
Example - Before Before editing:
Edited the below dataThe highlighted data is modified:
After After editing:
Info |
---|
Implement the GoEdit app with the Excel for Confluence macro in a staging environment before implementing it in the production. |