Hello,

I'm translating the help text for GETPIVOTDATA to German but have problems with the following paragraph, because I don't know, how it should work.
<quote>
If no constraint for a page field is given, the field's selected value is implicitly used. If a constraint for a page field is given, it must match the field's selected value, or an error is returned.
</quote>

You find the text identically in the spec
http://specs.openoffice.org/calc/compatibility/getpivotdata.odt
in the OASIS-document
http://www.oasis-open.org/committees/download.php/24700/openformula-20070720.odt
and in the help
http://documentation.openoffice.org/source/browse/documentation/helpcontent2/source/text/scalc/01/04060109.xhp

This are my problems:
Where shall the page field be? As data field, or as part of a constraint, or...? If I use it as part of a constraint, then I know no way to use it without an item to constraint it. If I use it as data field, that is technical possible in the first syntax, but it makes no sense to me and I cannot constraint it.

Can someone give me an example, how to use a page field in a GETPIVOTDATA statement?

kind regards
Regina

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to