POC - Test Issue #2
Description
test has an error because the scope demands that a COM controller be invoked, however there is an unlisted filter and as the source cannot be changed this makes its execution impossible. By toggling (in a test scenario) the filter of the first pivot table, the python code returns the hidden filter (the execution relies on a cursor to select the filters hierarchically and thus capture the data, which is the test itself).
in addition, the existence of this filter does not allow the coexistence of the original Federation Unit (whitch the occult filter name is State) and product filters, in the form of their original scope.
returns the following error:
pywintypes.com_error: (-2147352567, 'Exception occurred.', (0, u'Microsoft Excel', u'PivotFields method of PivotTable class failed', u'xlmain11.chm', 0, -2146827284), None).
(-2147352567, 'Ocorreu uma exceção.', (0, 'Microsoft Excel', 'Unable to set the CurrentPage property of the PivotField class', 'xlmain11.chm', 0, -2146827284), None)