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

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

  • 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

  • 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

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels