I have a pivottable, say i have Month and Week fields on Column. Have other fields on Row and the Data fields (say Cost and Profit) on Row as well.
When i collapse the Month column (say JAN), so that the Weeks within JAN get collapsed and I see subtotal values.
Now, i set the style of Cost@JAN cell (by getting the range and doing range.Style = "my_custom_style")
Now, when i expand the JAN field (showdetails or click on the "+" button), I see that the child items (cells corresponding to Cost@Weeks under JAN) inherited the style from parent.
Is it expected ?
I am doing it through code in my excel addin (office 2013)
I tried creating a dummy pivottable and setting the style manually,
Link to sample excel -
collapse column "mon1", click on first data cell "5", select a style from "Styles" group in the Home tab, then expand "mon1". All child cells get styled
I am trying out since 2 days on this bug so wanted to check if its some settings exposed that am missing or is expected behavior ?
Would be great if someone can help me on this.
1 hour 38 minutes ago
update with sample excel