We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on : November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

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

Thread ID:

Created:

Updated:

Platform:

Replies:

109662 Jun 26,2013 01:27 PM UTC Jul 2,2013 07:24 AM UTC WPF 1
loading
Tags: XlsIO
Giovanni Albani
Asked On June 26, 2013 01:27 PM UTC

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 [Syncfusion]
Replied On July 2, 2013 07:24 AM UTC

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

CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

;