nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

failure when including MS-Excel file and formular in eConfluence

Hubertus Siegert

I have included an excel file in an eConfluence page. All used formulars are working fine when using these in the source excel file, but when viewing this in eConfluence a #NAME? failure is shown.

The failure is generated when using the FREQUENCY formular.

I am using the German language version of excel, all other formulars are working without any problems.

Any suggestions how to solve this - thanks

Accepted answers

All comments

Shannon S

Hubertus,

Can you show us a screenshot of the problem you're having? Are you using any add-ons to display the Excel file?

Lastly, what version of Confluence are you using?

Shannon

Hubertus Siegert

thanks for looking into this, here you go:

The Formular behind the cell where the number 141 stands in the upper table is (the other cells have comparable formulars)

=SUMME(WENN(HÄUFIGKEIT('PI6'!I6:I1015;'PI6'!I6:I1015)>0;1))

where SUMME=SUM, WENN=IF, HÄUFIGKEIT=FREQUENCY

As I mentioned: when editing the xls-file opening it from eConfluence the file shows the correct value, but after refreshing/saving the content to eConfluence the failure in the cell is shown, and the linked graph based o nthe table does not show any value for this field

Hubertus Siegert

our confluence version in use is

Confluence 6.7.2

Shannon S

Thank you for confirming.

Can you please tell me which macro you're using to display the data? It seems like it's not the standard.

Shannon

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

ms-excel