This article explains how to do advance calculations in Excel macro using the GoEdit app. It will help to edit the attachment on the fly and save your time.
It will help to edit the data in the attachment without impacting your Excel formula.
Instructions
Follow the below instructions:
- Log in as Confluence Admin.
- Click
> Manage apps > Find new apps to install the GoEdit app.
- Go to space and create a page with attachments.
- Click on the edit link.
- Add the macro Excel for Confluence and mention the Name of attachment. Click on Save button.
- Edit directly option will show above the attachment details as shown in the below screenshot.
- Click on Edit directly to edit the data. Below option will pop up on your screen, click on Open GoEdit to proceed with editing and click on install button.
The first time when you edit attachment using GoEdit, it will ask you to install it on your computer.
- This will open the excel sheet, here you can make the changes and save the excel.
Before editing:
After editing:
- The below screen will pop-up, click on Save Attachments.
- The data got edited now for user3.
- Refer to the below examples:
a. Editing the data will also update the calculation made in the excel sheet.
Before editing:
Edited the below data:
After editing:
