How to show the "%" simbol in Excel Board Add in once exported from the reports?

Marius Lubbe · 2024-06-12T10:33:15+00:00

There was an error rendering this rich post.

Hi we are currently exportign reports from Board into excel with the "Microsoft Excel Workbook for BOARD Add-in" option selected.

Because this setting does not allow the template to export as well, we cannot see the % signs on spesific rows in the report as we had to add them in using the template functionality.

Is there a workaround for this so that we can see the % sign when viewing these reports in excel?

Kind regards,

Marius

Find more posts tagged with

Reporting

Add-In

Accepted answers

All comments

Willians Santana

Hi @Marius Lubbe ,

I hope you are having a great day!

Thank you for your message! I do appreciate that.

Please could you send the screenshots of the sequence you performed until the moment the issue happens?

Thank you!

Kind Regards,

Willians

Marius Lubbe

Hi @Willians Santana

The steps taken is as follows:

We have a report in Board formatted to look as the below screenshto

Then when I export this using the following selections

The report exports as the below without any proper formatting except for what got applied in the Block Formatting section of the setup.

As you can see, we do not have percentages only values. This means that if I manually change the cell's format in excel to percentage I get something completely wrong. (Sorry for the 0's I had to hide the values due to privacy issues)

Do you have any suggestions to get past or around this issue?

Kind regards,
Marius

Willians Santana

Hi @Marius Lubbe. Thank you for your message and all the details provided! I do appreciate that.

I recommend you open a case with the Board of Product Support for further evaluation of this scenario.

Kind Regards,
Willians