When I open an Excel file with XlsIO and I read the "FillBackgroundRGB" property of a cell that is supposed to have a white background, I get a black background.
STEPS TO REPRODUCE:
1) Create a new Excel document with Excel 2010
2) Change the background of a cell to White
3) Save the document as XLSX
4) Open the document with XlsIO for WinRT
5) Programmatically read the "CellStyle" of the cell that is supposed to have a white background
EXPECTED RESULT : the CellStyle of the cell should have a White FillBackground/FillBackgroundRGB
ACTUAL RESULT : the CellStyle of the cell has a Black FillBackground/FillBackgroundRGB
Can you please tell me if there is any workaround to programmatically know in XlsIO if a cell has a white or black background? In fact, because of the behavior described above, I cannot programmatically distinguish between a black cell and a white cell (because they both appear as black).
Thank you in advance for your help.
By the way, XlsIO is a great component. Thanks a lot for having created it. You guys are amazing.
JMJohnson Monohar M Syncfusion Team July 2, 2013 07:24 AM UTC
Thank you for using Syncfusion products.
We are able to reproduce the issue "WHITE background color of a cell returns BLACK color in WinRT platform" and confirmed this as a defect. We have logged a defect report for the same. The fix for the issue will be avalilable in our next product release at the end of August.