This article explains how to do gives you step by step instructions to perform advance calculations in Excel macro using the GoEdit app.
Using By using GoEdit, you can open and edit the spreadsheets that are attached spreadsheets to confluence pages "in place" that way you do not have to download the file and change it then re-attach it. It will help 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 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 then click Save.
- You can find an option: Edit directly option will show directly above to the attachment details as shown in the below screenshot.:
- Click on Edit directly to edit the data. Below option will A pop up appears on your screen, click . Click Open GoEdit to proceed with editing and click Install.
The first time when you edit attachment
Note: If you are using this option for the first time using GoEdit, it will ask prompts you to install it on your computer.
- This will open the excel sheet, here you . You can make the required changes and save the excel.
Before Example:
Before editing:
After editing:
9. The below screen
...
pops up, click Save Attachment.
- The You can see the data got edited now for user3. as shown in the below example:
- Refer to the below example where editing the data will also update 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:
