Inspiration
Confluence users often need quick calculations while documenting. Previously, they had to switch to Excel, Google Sheets, or even a physical calculator to crunch numbers and then copy results back into Confluence. This project removes that hassle, allowing them to perform Excel-like calculations directly within Confluence tables—no more manual number crunching or separate tools required.
What it does
This macro lets users write and execute Excel-like functions directly within Confluence tables. It seamlessly adds calculation capabilities to existing tables, enabling immediate numerical analysis and streamlined workflows without leaving the Confluence environment.
How we built it
We initially developed the macro using Atlassian Connect, but to enhance performance and user experience, we adopted Forge. By leveraging Forge storage for data, we’ve achieved faster calculations, better scalability, and a UI that naturally fits Confluence’s latest design standards.
Challenges we ran into
A significant challenge was ensuring the coexistence of both the Connect-based and Forge-based macros while maintaining consistent calculation logic. We also needed to optimize for performance and adapt to Forge’s storage model. Achieving a smooth transition between the old and new architectures was no trivial task.
Accomplishments that we're proud of
- Successfully migrated critical functionality to Forge, resulting in faster, server-side calculations.
- Delivered a modernized, intuitive UI that harmonizes with Confluence’s current look and feel.
- Maintained compatibility, allowing existing Connect-based macros to work alongside the new Forge-based macro, protecting users’ prior investments.
What we learned
We gained deeper insight into the Forge platform’s capabilities, performance optimization techniques, and best practices for integrating data storage. We also learned how crucial a seamless UI/UX experience is for user adoption, reinforcing the value of tight integration within the Confluence ecosystem.
What's next for
We plan to extend the range of supported Excel functions and enable data sharing with other Atlassian apps or external platforms. Our goal is to further solidify Confluence as a robust, all-in-one platform for documentation and decision-making, allowing users to perform sophisticated calculations effortlessly.
Log in or sign up for Devpost to join the conversation.