How to also export the Layout settings to Microsoft Excel Workbook for BOARD Add-in?
Hi,
I am currently exporting data from my report directly into excel.
I can then connect my Board office add-in to the table and apply selections and everything possible using the office conector.
The problem that I am having is the value formats.
In my report in Board (online) I have parenthesis instead of the minus simbol when values are negative that is being applied using a template, whereas in Excel the values are shown as negatives again using the minus simbol even with the template still applied.
I tried formatting the cells manually, but as soon as I apply a filter or selection or refresh the format changes back.
Is it possible to import the format exactly?
Accepted Answer
-
Hi Marius,
This is a known issue in Board where the negative numbers formatted with Parentheses is not respected when exporting using the Board Add-in functionality. The lab is looking into this (PRB-000021394). Once this is resolved, we will update you.
As a workaround, try editing the format of the block within the excel and see if it respects the parentheses format.
Thanks,
Samson.1
Answers
-
Hi Samson,
I tried that and is sadly did not work.
What we did as a workaraound was to remove the automatic format updates and set it to manual.
We then just changed the excel cell formats.
This is not the best approach but for now it works.
Kind Regards
0
Categories
- All Categories
- 2K Forums
- 1.8K Platform
- 159 Academy
- 324 Resources
- 1 Board Knowledge Base
- 50 Best Practices
- 49 How-To Guides
- 19 Board Advocacy Program
- 191 Blog
- 4 Groups Hub
- 4 About Groups
- New Community Members
- DACH
- Japan
- 4 Community Captains
- 1 About Community Captains
- 2 Meet the Community Captains
- 1 Topics & Thought Starters
- Learn from the Board Captains
- Release Notes
- Academy
- 2 Board Academy
- 8 ILT/VILT Course Catalogue
- 13 e-Learning Course Catalogue
- 4 Academy Forum
- 1.2K Idea Exchange
- 337 Partner Hub
- 94 Support
- 14 FAQ's
- Customer Support Portal
- 54 Support Articles
- BEAP