Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

2.4.292 SxIvd

Office

The SxIvd record specifies an array of SxIvdRw or SxIvdCol.

An array of SxIvdRw specifies all items for the row axis of the PivotTable view. An array of SxIvdCol specifies all items on column axis of the PivotTable view.

Two or fewer records of this type appear in the file depending on the values of the cDimRw and cDimCol fields of the SxView record of the PivotTable view.

If the cDimRw and cDimCol fields of the SxView record are both greater than zero, then two records of this type appear in the file for the PivotTable view. The first record is an array of SxIvdRw and the second record is an array of SxIvdCol.

If the value of the cDimRw field of the SxView record is greater than zero and the value of the cDimCol field of the SxView record is equal to zero, then only one record of this type appears in the file for the PivotTable view and it is an array of SxIvdRw.

If the value of the cDimCol field of the SxView record is greater than zero and the value of the cDimRw field of the SxView record is equal to zero, then only one record of this type appears in the file for the PivotTable view and it is an array of SxIvdCol.


0

1

2

3

4

5

6

7

8

9
1
0

1

2

3

4

5

6

7

8

9
2
0

1

2

3

4

5

6

7

8

9
3
0

1

rgSxivd (variable)

...

rgSxivd (variable): An array of SxIvdRw or SxIvdCol items.

If this is an array of SxIvdRw, the count of elements in the array MUST equal the value of the cDimRw field of the SxView record.

If this is an array of SxIvdCol, the count of elements in the array MUST equal the value of the cDimCol field of the SxView record.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.