This article explains how to do advance calculations in Excel macro using the GoEdit app.
...
Follow the below instructions:
- Log in Login 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 page edit link.
- Add the macro Excel for Confluence and mention the Name of attachment. Click on then click 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 click Open GoEdit to proceed with editing and click on install buttonInstall.
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 click Save AttachmentsAttachment.
- The data got edited now for user3.
- Refer to the below example where editing the data will also update the calculation made in the excel sheet.
Before editing:
Edited the below data:
After editing:
...