oblivion change appearance without losing stats

Has anyone ran into this issue, or do any Excel experts know what could cause this from a technical point of view? This only occurs when copying between Excel files, not between Worksheets within an Excel document. One interesting thing is if I go and manually change the fill color of one of those cells in Excel, then copy and paste that, the color I manually set is copied over perfectly while the Infragistics generated cells are dithered. That dark grey header even becomes completely white. Now, every Fill color is either pure red (#FF0000), pure green (#00FF00), pure blue (#0000FF) or yellow (#FFFF00). However, if my manager selects all the cells in Excel, copies the data to the clipboard, then pastes those cells into another Excel file, all the colors are converted into some weird 3bit palette: This works great and the report comes out looking fine: FillPatternForegroundColor = Color.FromArgb(127, 127, 127) Some cells, we add a fill color like so: .FillPattern = FillPatternStyle.Solid

We use the Infragistics NetAdvantage Excel control to create an Excel report on the fly.

At the risk of having this question downvoted into oblivion or closed as 'Too Localized', I figured I would post about this issue since my boss complains constantly about it and it has me scratching my head.

Oblivion change appearance without losing stats