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

Values of Excel sheets are not displayed

Hello everybody,

by using the makro for exel, some values of formulas are not displayed, respectivly, it is displayed as a formula mistake. In the excel sheet is everything fine, even the first result is correct:

2022-01-11_16h08_18.png

If someone can help, would be great!

Thanks!

Sasko 

1 answer

1 accepted

Hi @Sasko Moraliev ,

Sometimes the Excel macro won't display very complex formulas - don't know if this is your case though, but I came across such thing several times.

You may browse the Atlassian Marketplace for the apps that recreate Confluence tables from CSV attachments (I think there are even free apps).

Our app that is Table Filter and Charts for Confluence is a paid add-on, but it's a complex plugin that will be able to replace Excel and you won't need to switch between two instances. Please, check our Table Spreadsheet macro - a fully functional Excel spreadsheet with formulas, graphs, pivots, conditional formatting, etc. that you can edit right from the page view mode.

Tue 4-1.png

Besides, our app also provides the Table from CSV macro to recreate tables from CSV attachments/URLs. These recreated tables can be also filtered/aggregated/visualized in Confluence with the help of our other macros.

Hi @Katerina Kovriga _Stiltsoft_ ,

 

thanks for your reply. The formula is the same as in the left field, where the result is displayed correct. And it is not complexe ;-) 

But your second hint was very helpful! I found a free app "Excel Like Tables" and it works in every case very good. Also better to use for tables, than the standard functionality of confluence, which loks really awful when the columns are all schrinkend.

 

Thx an regards

Saško

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
FREE
PERMISSIONS LEVEL
Site Admin
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 ...

984 views 7 42
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