Discrepancy with Excel for conditional format and the "no color" background

Discrepancy with Excel for conditional format and the "no color" background

Posted by: pdoxakis on 21 November 2022, 10:06 am EST

• 

  pdoxakis

  • Post Options:
  • Link
    Copy

  Posted 21 November 2022, 10:06 am EST

  Hi,

  I found one discrepancy between the spreadjs designer and Excel.

  When using conditional format and specifying the “No Color” option for the background color in the format cells dialog, it does not have the same behavior. In Spreadjs, it will show the cell’s background. In Excel, it will use a white background.

  Is it a bug or I can activate an option to behave like Excel ?

  In attachment, the Excel file to reproduce the issue. Simply change the B2 cell to true or false.
  
  When B2 is set to “TRUE”, the background should be in white.

  I tested with https://www.grapecity.com/spreadjs/designer/index.html to have the latest version.

  Thanks!

  Test_ConditionalFormat.zip

• 

  ankit.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 22 November 2022, 4:45 pm EST

  Hello Philip,

  We appreciate you providing us with the Excel file. I can also verify a change in behavior between Microsoft Excel and the most recent version of SpreadJS, V15.2.5. The internal tracking id for this is SJS-15879, and I have given it to the development team for review. When I receive an update from the development team, I’ll let you know.

  Regards,

  Ankit

• 

  ankit.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 28 December 2022, 10:09 pm EST

  Hi Philip,

  The issue has been fixed in the latest version of SpreadJS V16.0.0. Please upgrade to the latest version of SpreadJS. You may download the SpreadJS V16.0.0 using the following link: http://cdn.grapecity.com/spreadjs/16.0.0/Files/SpreadJS.Release.16.0.0.zip

  Regards,

  Ankit