Hello,

I am just checking about the progress of this issue. Let me know If you need our further assistance on this  matter?

Thank you for using Infragistics Components.

Hi Rowan,

There's no way to globally ignore certain parts of the appearance like you are doing here. I can't see how this code could ever have worked, as that constant has always been a constant and was never a property as far as I can see.

The BeginExport event gives you a layout you can modify in e.Layout. This is a clone of the grid's on-screen DisplayLayout, so you can modify it however you like, but again, there's no way to simply ignore the BackColor or ForeColor on every element. You would have to set or reset the same appearances that are applied to the on-screen grid and leave out the ones you don't want on an individual basis.

It seems you are right.

Explain please how exactly I can ignore properties from AppearancePropFlags using event BeginExport and property e.Layout. I also tried event InitializeColumn:

var data = new AppearanceData();
var flags = ~AppearancePropFlags.TextHAlign;
e.Column.CellAppearance.MergeData(ref data, ref flags);
e.Column.CellAppearance = new Appearance(ref data);

It is strange, e.Column.CellAppearance.TextHAlign is set to value Default

but anyway properties don't ignored in excel file.

Thank you,

Roman