Funcitionality Board Add IN

Hello,

I have a question regarding the office add-In for excel. I tried to recreate a report in excel.

In the screen selection, the entities "Kostenträger" and "Sachkonten" are already excluded in BOARD.

However, when I exclude "Kostenträger" via the sheet selection in the add‑in, I’m not able to exclude any additional "Sachkonten" afterwards, the "ausschließen" (exclude) button becomes inactive.
The "Kostenträger" I exclude have no connection to the "Sachkonten" I would like to exclude. The same behavior also occurs when using the "Arbeitsmappen-Selektion" (workbook selection )

So my question is:
Is this behavior intended? If yes, what is the reason behind it and is there any workaround? Or is this more likely a technical issue?

Both the BOARD platform and the Excel add‑in are running on the same version level.

Thank you in advance!

Best regards

Carolin Rudolph

Find more posts tagged with

Selection

Add-In

Accepted answers

Robert Barkaway

Ah okay, sorry, you mean you want to have exclude selections on two different entities in the same tree? Yeah I don't think that's possible by the looks of it in the Office add-in, whether that's something which will change in the future I'm not quite sure.

All comments

Robert Barkaway

Hi Carolin, it looks like you just need to enable "Show Inactive Members" in the bottom left of the selection dialog, that will then allow you to select additional members to exclude, I just checked on 14.4 and it's working fine for me.

c.rudolph

Hi Robert,

thank you for your reply, but unfortunately it didn’t resolve the issue. Whenever we exclude members from entities with hierarchical structures like this:

…it is not possible to exclude additional members. For example, we want to exclude two members from “Sachkonto” and from “Kostenstelle”, but the button remains greyed out. Also, the “Show Inactive Members” button is inactive.

That is strange, because it works in Board itself, and we wanted to partially replicate some reports in Excel.

Kind regards

Carolin

Robert Barkaway

c.rudolph

Alright, thank you!