I have tested the new ExcelAdd-In for Cube Analysis
with Foodmart2000 and Cube Sales,with free-form report and
structured report.

In the Excel Spreadsheet the measures are not formated
correct:

Unit Sales Store Sales
All Products 266773 ?565.238
Drink 24597 ?48.836
Food 191940 ?409.036
Non-Consumable 50236 ?107.366

But with the MDX-expression created in the ExcelAddIn:

SELECT NON EMPTY{Hierarchize({VisualTotals({Hierarchize
({UNION({[Measures].[Unit Sales]},{[Measures].[Store
Sales]})})},
"***")})} on 0, NON EMPTY{Hierarchize({VisualTotals
({Hierarchize(
{[Product].[All Products],AddCalculatedMembers({[Product].
[All Products].children})})}, "***")})} on 1 from
[Sales] CELL PROPERTIES VALUE,
FORMATTED_VALUE, FONT_NAME, FONT_SIZE,
FONT_FLAGS,FORE_COLOR, BACK_COLOR, FORMAT_STRING

and the MDX Sample Application and also in the Cube
Browser the measures displayed correct:

Unit Sales Store Sales
All Products 266.773,00 ?565.238,13
Drink 24.597,00 ?48.836,21
Food 191.940,00 ?409.035,59
Non-Consumable 50.236,00 ?107.366,33


Display Format from Unit Sales in the Cube = Standard
Display Format from Store Sales in the Cube = Currency

Is this a bug ?????