PivotTable OWC: How is a hyperlink field indicated using the office xml schema?

A

Andrew

I have a published pivottable (owc 11). The published version obviously has
some schema definition so that the pivot table component knows how to
display the data. The schema used is:

<PivotTable xmlns="urn:schemas-microsoft-com:eek:ffice:excel">
...
</PivotTable>

Within this there are the following elements describing each field:

<PivotField>
<Name>ActivityDate</Name>
<NumberFormat>General Date</NumberFormat>
<DataType>Date</DataType>
</PivotField>

QUESTION: How does one indicate that the field is a hyperlink?

Using script one would find the field and set the IsHyperlink property to
true.

There is absolutely no mention of hyperlinks in the Office 2003 XML
Reference Schemas; which by the way, are TOTALLY impossible to find using
Microsoft's website. So for those of you who can't find it, here's the link
to the download page:

http://www.microsoft.com/downloads/...52-3547-420A-A412-00A2662442D9&displaylang=en

Thanks, Andrew
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top