Hi Patrick,
Thanks for sending me the Sample file.
I tested your .xls file and was able to see the problem with the background colors and have filed a bug report with the development team.
Bug Id:#1067. It will be resolved soon before the next release.
Sorry for the Inconvenience.
Thanks for your interest with Syncfusion Products.
Best Regards,
Seetha
>I need to make a correction as well. The FillBackground color on the EntireRow member is being set to Black as opposed to BlackCustom(the default).
>
>Patrick
>
>>Seetha
>>
>>Attached is the .xls file I am using for testing.
>>
>>Thanks
>>Patrick
>>
>>>Hi Patrick,
>>>
>>>Can you please send me the sample file, so that i could test with the latest build and tell you the solution for this issue.
>>>
>>>Sorry for the Inconvenience.
>>>
>>>Best Regards,
>>>Seetha
>>>
>>>
>>>
>>>>Seetha
>>>>
>>>>Thanks for the quick response, but I''m not sure that IWorksheet.SetDefaultColumnStyle/IWorksheet.SetDefaultRowStyle would apply in my situation. I have an Excel Spreadsheet that was built in Excel with the following properties.
>>>>Rows 1-4 have the default cell properties on the entire row,
>>>>Rows 5-8 have a different background color applied to the entire row,
>>>>Columns C-E have values set in the cells.
>>>>
>>>>I read in the worksheet using IApplication.Workbooks.Opan() and get the list of cells using IApplication.ActiveWorkbook.ActiveSheet.Cells
>>>>which returns a list of cells representing the Range A1:F9 (so far so good). Now while looping through the list of cells I find that only C5:E8 have the background color that was applied to the rows, while A5:B8 have the default background color. I have also checked IRange.EntireRow and the background color appears to be set to the default for A5:B8. Is there somewhere else that I can look in ExcelRW to get row level formatting information on a worksheet.
>>>>
>>>>>Hi Patrick,
>>>>>
>>>>>Regarding the First issue (Number Format), it has been addressed again to the developement team with priority high. It will be resolved soon.
>>>>>Regarding the Second issue (Background styles), there has been added a property IWorksheet.SetDefaultColumnStyle and IWorksheet.SetDefaultRowStyle for default styles in the latest internal version. It will be available in the next release. The next release is on November 21st.
>>>>>
>>>>>Sorry for the Inconvenience.
>>>>>
>>>>>Thanks for your interest with Syncfusion products.
>>>>>
>>>>>Best Regards,
>>>>>Seetha
>>>>>
test10.zip