Hi PwC,

Maybe they are hiding rows that have been generated when the sheet is in Expanded format. If the sheet is then collapsed and then re-expanded, the re-generated (previously hidden) rows will loose any formatting that was applied directly to them when in expanded mode. Instead they will inherit the formatting characteristics of the row that they were generated from.

As a general rule you should never apply formatting to generated rows in an expanded sheet. Formatting should be done when the sheet is in collapsed mode. In fact, I believe that the system now prevents some type of editing/formatting operations to expanded sheets.

It sounds to me like you'll have to do some tweaking of the sheet for them to get what they want.

Best wishes, Pete