Melvers 1-Nov-12 12:44 1-Nov-12 12:44 I am creating an Excel spreadsheet for Office 2010. Driver Creative Ct2518 Win7 on this page. Note, I am using the SAX method as the amount of data will be very large (when I get this working at all). I am having a problem will Fill objects. Corel Knockout V1.5.

I have defined two: fills = new Fills(); // FillID 0. Fill = new Fill(); fill.PatternFill = new PatternFill(); fill.PatternFill.PatternType = PatternValues.None; fills.Append(fill); // FillID 1. Fill = new Fill(); fill.PatternFill = new PatternFill(); fill.PatternFill.PatternType = PatternValues.Solid; fill.PatternFill.ForegroundColor = TranslateForeground(SD.Color.Green); fill.PatternFill.BackgroundColor = TranslateBackground(SD.Color.Magenta); fills.Append(fill); fills.Count = (UInt32) fills.ChildElements.Count; However, I don't get this kind of fill.

When I use a FillId of 1 on any of the CellFormats all I get is a black and white grid pattern. I can change PatternType of to any value, including None, and I will still get a black and white grid pattern. Any thoughts or ideas? All the FontIds and NumberFormatIds work as expected, but the FillId will not result in the correct fill style in the Excel spreadsheet. The Excel file opens without error.

Summary: Explore the architecture and advantages of using the Open XML Format SDK 2.0 (CTP)http://msdn.microsoft. Arihant Iit Buzzword. com/en-us/library/bb448854(office.14).aspx. Summary: Explore the architecture and advantages of using the Open XML Format SDK 2.0 (CTP). Additionally, see in-depth scenarios of how to assemble and manipulate.

Its just that the cells are not filled correctly. When I save the Excel file as an XML file, all of the fill specifications ( node) look like this, regardless of the specification I have coded: