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-comffice: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
some schema definition so that the pivot table component knows how to
display the data. The schema used is:
<PivotTable xmlns="urn:schemas-microsoft-comffice: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