CSS and OWC

[Guest]

i want to use a CSS in order to make all fields have the same font--
basically; i want to use Tahoma 8 instead of the default Arial 10-- on every
pivotList anywhere.

Is it possible to do this via CSS?

Or do i have to do this clientside?

-aaron

 

[Alvin Bruney [MVP]]

you would need client-side script for this or attach a behavior to the
activeX object (basically boils down to scripting anyway)

 

[rweide]

Alvin, you have a new book, right? what's the name of it, is it out yet?

you would need client-side script for this or attach a behavior to the
activeX object (basically boils down to scripting anyway)

--
Regards,
Alvin Bruney
[ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
Got tidbits? Get it here... http://tinyurl.com/27cok

i want to use a CSS in order to make all fields have the same font--
basically; i want to use Tahoma 8 instead of the default Arial 10-- on
every
pivotList anywhere.

Is it possible to do this via CSS?

Or do i have to do this clientside?

-aaron

 

[Guest]

I'm not scared of scripting.

I just want to be able to specify in one place-- that the font should be
tahoma8, instead of arial 10.

it makes a big difference regarding how much information you can display in
one page.

i'd like to be able to write an XSL or CSS or something crazy that says 'if
you live in this pivot table; you should use Tahoma 8'

it's like-- OWC doesn't remember fonts and all that.. i know it's in the
mdx.. but as it is, i am forced to change the XMLDATA by going thru and
looking at each line

<x:CompareOrderedMembersBy>UniqueName</x:CompareOrderedMembersBy>
and when i hit one of these; i need to add these lines (unless they're
already present)

<x:GroupedFormat Style='font-family:Tahoma;font-size:8pt'/>
<x:SubtotalFormat Style='font-family:Tahoma;font-size:8pt'/>

obviously im scripting this the wrong way-- can someone point me in the
right direction?

-aaron

you would need client-side script for this or attach a behavior to the
activeX object (basically boils down to scripting anyway)

--
Regards,
Alvin Bruney
[ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
Got tidbits? Get it here... http://tinyurl.com/27cok

i want to use a CSS in order to make all fields have the same font--
basically; i want to use Tahoma 8 instead of the default Arial 10-- on
every
pivotList anywhere.

Is it possible to do this via CSS?

Or do i have to do this clientside?

-aaron

 

[Alvin Bruney [MVP]]

like i said, i'm not sure there is a correct way because the activex control
is not part of the page maybe somebody else can help you there. i'm fresh
out of ideas

--
Regards,
Alvin Bruney
[ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
Got tidbits? Get it here... http://tinyurl.com/27cok

I'm not scared of scripting.

I just want to be able to specify in one place-- that the font should be
tahoma8, instead of arial 10.

it makes a big difference regarding how much information you can display
in
one page.

i'd like to be able to write an XSL or CSS or something crazy that says
'if
you live in this pivot table; you should use Tahoma 8'

it's like-- OWC doesn't remember fonts and all that.. i know it's in the
mdx.. but as it is, i am forced to change the XMLDATA by going thru and
looking at each line

<x:CompareOrderedMembersBy>UniqueName</x:CompareOrderedMembersBy>
and when i hit one of these; i need to add these lines (unless they're
already present)

<x:GroupedFormat Style='font-family:Tahoma;font-size:8pt'/>
<x:SubtotalFormat Style='font-family:Tahoma;font-size:8pt'/>

obviously im scripting this the wrong way-- can someone point me in the
right direction?

-aaron

you would need client-side script for this or attach a behavior to the
activeX object (basically boils down to scripting anyway)

--
Regards,
Alvin Bruney
[ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
Got tidbits? Get it here... http://tinyurl.com/27cok

i want to use a CSS in order to make all fields have the same font--
basically; i want to use Tahoma 8 instead of the default Arial 10-- on
every
pivotList anywhere.

Is it possible to do this via CSS?

Or do i have to do this clientside?

-aaron

 

[Alvin Bruney [MVP]]

Microsoft OWC black with .NET. have a look at my website for the cover and
details. it's materially complete, just resolving licensing and copywrite
issues at the moment.

--
Regards,
Alvin Bruney
[ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
Got tidbits? Get it here... http://tinyurl.com/27cok

Alvin, you have a new book, right? what's the name of it, is it out yet?

you would need client-side script for this or attach a behavior to the
activeX object (basically boils down to scripting anyway)

--
Regards,
Alvin Bruney
[ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
Got tidbits? Get it here... http://tinyurl.com/27cok

i want to use a CSS in order to make all fields have the same font--
basically; i want to use Tahoma 8 instead of the default Arial 10-- on
every
pivotList anywhere.

Is it possible to do this via CSS?

Or do i have to do this clientside?

-aaron

 

[Rolf N]

Hi.

Maybe this WBScript will do the trick for you:

Dim view
Dim name
Dim size
name = "Tahoma"
size = 8
set view = PivotTable1.ActiveView
view.FieldLabelFont.Name = name
view.FieldLabelFont.Size = size
view.TotalFont.Name = name
view.TotalFont.Size = size
view.HeaderFont.Name = name
view.HeaderFont.Size = size
For Each ttl In view.FieldSets
For Each ttl2 In view.FieldSets(ttl).Fields
view.FieldSets(ttl).Fields(ttl2).DetailFont.Name = name
view.FieldSets(ttl).Fields(ttl2).DetailFont.Size = size
view.FieldSets(ttl).Fields(ttl2).SubtotalFont.Name = name
view.FieldSets(ttl).Fields(ttl2).SubtotalFont.Size = size
view.FieldSets(ttl).Fields(ttl2).GroupedFont.Name = name
view.FieldSets(ttl).Fields(ttl2).GroupedFont.Size = size
view.FieldSets(ttl).Fields(ttl2).SubtotalLabelFont.Name = name
view.FieldSets(ttl).Fields(ttl2).SubtotalLabelFont.Size = size

Next
Next

Regards Rolf

I'm not scared of scripting.

I just want to be able to specify in one place-- that the font should be
tahoma8, instead of arial 10.

it makes a big difference regarding how much information you can display in
one page.

i'd like to be able to write an XSL or CSS or something crazy that says 'if
you live in this pivot table; you should use Tahoma 8'

it's like-- OWC doesn't remember fonts and all that.. i know it's in the
mdx.. but as it is, i am forced to change the XMLDATA by going thru and
looking at each line

<x:CompareOrderedMembersBy>UniqueName</x:CompareOrderedMembersBy>
and when i hit one of these; i need to add these lines (unless they're
already present)

<x:GroupedFormat Style='font-family:Tahoma;font-size:8pt'/>
<x:SubtotalFormat Style='font-family:Tahoma;font-size:8pt'/>

obviously im scripting this the wrong way-- can someone point me in the
right direction?

-aaron

you would need client-side script for this or attach a behavior to the
activeX object (basically boils down to scripting anyway)

--
Regards,
Alvin Bruney
[ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
Got tidbits? Get it here... http://tinyurl.com/27cok

i want to use a CSS in order to make all fields have the same font--
basically; i want to use Tahoma 8 instead of the default Arial 10-- on
every
pivotList anywhere.

Is it possible to do this via CSS?

Or do i have to do this clientside?

-aaron

 

[Guest]

thank you so much

Hi.

Maybe this WBScript will do the trick for you:

Dim view
Dim name
Dim size
name = "Tahoma"
size = 8
set view = PivotTable1.ActiveView
view.FieldLabelFont.Name = name
view.FieldLabelFont.Size = size
view.TotalFont.Name = name
view.TotalFont.Size = size
view.HeaderFont.Name = name
view.HeaderFont.Size = size
For Each ttl In view.FieldSets
For Each ttl2 In view.FieldSets(ttl).Fields
view.FieldSets(ttl).Fields(ttl2).DetailFont.Name = name
view.FieldSets(ttl).Fields(ttl2).DetailFont.Size = size
view.FieldSets(ttl).Fields(ttl2).SubtotalFont.Name = name
view.FieldSets(ttl).Fields(ttl2).SubtotalFont.Size = size
view.FieldSets(ttl).Fields(ttl2).GroupedFont.Name = name
view.FieldSets(ttl).Fields(ttl2).GroupedFont.Size = size
view.FieldSets(ttl).Fields(ttl2).SubtotalLabelFont.Name = name
view.FieldSets(ttl).Fields(ttl2).SubtotalLabelFont.Size = size

Next
Next

Regards Rolf

I'm not scared of scripting.

I just want to be able to specify in one place-- that the font should be
tahoma8, instead of arial 10.

it makes a big difference regarding how much information you can display in
one page.

i'd like to be able to write an XSL or CSS or something crazy that says 'if
you live in this pivot table; you should use Tahoma 8'

it's like-- OWC doesn't remember fonts and all that.. i know it's in the
mdx.. but as it is, i am forced to change the XMLDATA by going thru and
looking at each line

<x:CompareOrderedMembersBy>UniqueName</x:CompareOrderedMembersBy>
and when i hit one of these; i need to add these lines (unless they're
already present)

<x:GroupedFormat Style='font-family:Tahoma;font-size:8pt'/>
<x:SubtotalFormat Style='font-family:Tahoma;font-size:8pt'/>

obviously im scripting this the wrong way-- can someone point me in the
right direction?

-aaron

you would need client-side script for this or attach a behavior to the
activeX object (basically boils down to scripting anyway)

--
Regards,
Alvin Bruney
[ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
Got tidbits? Get it here... http://tinyurl.com/27cok
i want to use a CSS in order to make all fields have the same font--
basically; i want to use Tahoma 8 instead of the default Arial 10-- on
every
pivotList anywhere.

Is it possible to do this via CSS?

Or do i have to do this clientside?

-aaron