Office add-in excel, keep format
Hello all,
is there something like @selection for the Excel Office Add In?
And how can I avoid reseting the format of my excel sheet when I refresh?
KR
Annika
Answers
-
Hi,
yes, you can use "@Selection" Function also in the Layout Header, just see Excel Export - Selection , cause here Hendrik Hellwig got a similar question.
Furthermore you can avoud the fornat reseting, if you use hte "manual format" option withn Excel Addin Context Menu (Board Office Add-in for Excel ):
Format
Automatic. With this option the formatting of the Board report is automatically managed by Board. The colors and fonts of the cells are managed by Board: headers, totals, sub-totals, alerts and other format option are inherited by the Layout settings, therefore it is not possible to use Excel functions to change the fonts or colors, cell borders etc. of data as these settings are overwritten every time the report is refreshed.
Manual. When this option is enabled, Board only returns the raw data into the Excel sheet and any cell format option can be performed using the standard Excel functions. The format setting are not overwritten when the Layout is refreshed.
7
