Dear all,


I tried to use the extended formatting properties of calculated
members in MS AS SP 3a trough Office Web Components (OWC Version 10)
pivot tables in MSIE6 Internet Browser.


So far I just managed to use and(!) see

* format string (#,#.00)
* forecoler (3000)
* backcolor (65000)

by using

* MYPT.ActiveView.UseProviderFormatting=true;
(for using/displaying the format sting and)
* MYPT.ActiveView.DisplayCellColor=true;
(for using/displaying the colors in OWC in the Web Browser.)


My questions are:

1.) Are there also special attributes like these to set to true if i
want to also use

* fontname ("Arial")
* fontsize (20)
* fontflags (1)

in OWC and the Browser?

The cube browser in MS Analysis Manager displays all the settings
correctly and without any error: I see a 20pt big, bold, red figure in
Arial type face on a yellow background which is formatted to two
decials. Perfect!

Is OWC capable of the same thing???

2.) What is is coding for the fontflags?



Thanks for any hint you can provid!!!


Cheers,
Felix

HI Felix,

- The PivotTable component does not support other format properties
that can be set on the server, such as FontName, FontSize, and
FontFlags.

I suggest that you check this article and the refernces in it for the
possibities you have.

INFO: Using Analysis Server Format Properties with the Office XP WGID:228
ID: 318122.KB.EN-US
http://support.microsoft.com/default...b;en-us;318122

HTH,
Bas

"This posting is provided "AS IS" with no warranties, and confers no
rights."