Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Excel file - formulas not working

Edited

Hello all,

so I'm inserting xlsx file to a confluence page and all complicated formulas which I've done are not working. In excel file it looks like this: (there is as well conditional formatting)screen.png

But in confluence page it's not working if formula is complicated)screen1.png

File is edited via Atlassian compaion and it is needed to read that result from cells to avoid update this table every time by hands.

1 answer

Hi @Mik_J ,

We can suggest trying our app - Table Filter and Charts for Confluence, maybe you've already been using it in your company for filtration and data aggregation.

The add-on also provides the Table from CSV macro that supports outputting data from a URL (for example, Google Sheets where you can use your formulas) or an attached file in CSV and TSV formats.

The recreated table looks like a regular Confluence table and can be further filtered, aggregated and visualized. All the changes made to the source spreadsheet or attachment are immediately reflected on the page.

By the way, you may also perform calculations right in Confluence with the help of the Table Transformer macro. And here is an example how to set conditional formatting for Confluence tables with this macro.

Hey @Katerina Kovriga _Stiltsoft_ 

Yes, I've been already using Table Filter and Charts for Confluence. I will make sure 100% if there is a solution for my query and I will return with feedback.

But, why when file is opened via link in preview mode, all is working fine, but when it's added to confluence page it is not?

Maybe it's some kind of a bug - I've checked the Excel macro in our test Cloud instance with simple formulas such as (A2+B2) and a standard predefined color scheme for conditional formatting - it worked for me. But we don't use the Excel macro often especially with complex formulas.

What concerns our app, we are almost ready with the new Spreadsheet macro - it looks like a fully functional Excel sheet right on the Confluence page with all Excel features included. Hope that this macro will help in similar cases.

So, I did some checks with that excel file, as some formulas are working good, Except this one's with formula EXACT, as it's not looping through arrays.

Example:

=SUM(IFERROR(IF(EXACT(
                                        IFS($K$10:$K$504=IF(B5="Not Defined";"";B5); ROW($K$10:$K$504);
                                              ISBLANK($K$10:$K$504)=TRUE; "blankk");
                                         IF(ISBLANK($F$10:$F$504)=FALSE; ROW($F$10:$F$504))
)=TRUE;1;0);0))

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Confluence Cloud

🏠 Say hello to the new Confluence Home!

Hi Atlassian Community, My name is DJ Chung, and I’m a Product Manager on the Confluence Cloud team. Today, I’m excited to share a new and improved version of Home. The new Home helps you ...

41,370 views 28 130
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you