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

[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

[Hubertus Siegert]

that´s the standard excel macro

[Shannon S]

Hubertus,

Thank you for clarifying. I'm not able to replicate this myself, but I have the macOS English version of Excel. I tried making a basic spreadsheet using FREQUENCY but all works well so far...

I'll work on this some more and try to replicate and keep you updated.

Shannon

[Hubertus Siegert]

Hi Shannon,

Thanks for looking into this. We are working here with Windows10 and the Germany version of eXcel of Office 2013.

In the meantine I experienced another failue: as the basic data for the HÄUFIGKEIT formular I use data generated by another formular:  I have a text field containing the format xxxxx.yyyy. This field is manipulated by "=VALUE(RIGHT(xxxxx.yyyy)) into that cells, which are than analyzed by the HÄUFIGKEIT=FREQUENCY formular. I just discovered that in the confluence vue the #NAME? error already comes up in the field "=VALUE(RIGHT(xxxxx.yyyy))" (in the German eXcel version: ZAHLENWERT(RECHTS(xxxxx.yyyy)) .The cell format is number, and I can make number operation on the reusult field in the eXcel view, but when converting this into confluence that causes the #NAME? error again. It looks like this finalyl results in the FREUQUENCY/HÄUFIGKEIT error, because if I take the results of the calculation =VALUE(RIGHT(xxxxx.yyyy) and copy that results into a new cells than this new cell values work with the FREQUENCY formular and show that also in confluence.

Summarizing that: it looks like not all (or: at least the RIGHT and/or VALUE formular is not correct reperesented in confluence - as I mentioned: in the original eXcel file everything works as designed.

Or do you see any mistake here? Thanks

Hubertus

[Shannon S]

Thank you, Hubertus,

Actually, I'm not very familiar with Excel, so looking at your formula I'm not able to determine any issues at a glance.

I think that we should go ahead and take this to a support ticket. This way you can send us your log files and a problematic Excel file so we can test with it.

It doesn't have to be the exact Excel file that you're working with if it's private. You could create another one and share it on the support ticket once you confirm that the issue occurs with it as well. In addition to that, can you share a copy of your Support Zip there? You can download it right after you replicate the error in case there's anything on the Confluence side that's happening in the background.

You can upload this information directly to the support ticket you received in your email, or by going to transfer.atlassian.io.

Once the issue is resolved, please feel free to provide the solution to this thread in case other users have the same issue.

Regards,

Shannon