Posted 21 November 2022, 10:06 am EST
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.