When opening with XlsIO a file created with Excel, white cells appear as black.

[Giovanni Albani]

Dear Syncfusion support,

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.

Best regards,

Giovanni

[Johnson Monohar M]

Hi Giovanni,

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.

Please let us know if you need any clarification.

Thanks,
Johnson