"Not equal to" in Spread Designer

Posted by: kukemaster on 8 September 2017, 3:01 pm EST

  • Posted 8 September 2017, 3:01 pm EST


    I want to set the backcolor to Color.Red that value not equal to "" by "Conditioanl Formatting Style" in Spread Designer, but I don't know how to input "" in "Conditional Formatting Style dialog"

    In code:

        FarPoint.CalcEngine.Expression one = new FarPoint.CalcEngine.StringExpression("");
        fpSpread1.ActiveSheet.SetConditionalFormat(1, 0, new FarPoint.Win.Spread.NamedStyle() { BackColor = Color.Red }, FarPoint.Win.Spread.ComparisonOperator.NotEqualTo, one);

    <img src="http://gcdn.grapecity.com/attachment.aspx?attachmentid=4011">

  • Replied 8 September 2017, 3:01 pm EST


    I could not find a way to use the empty string in the Spread designer for the "Not equal to" option for conditional formatting. I would rather suggest you to define a style for the cell, in your case set the BackColor of the cell to Red and later set the Conditional formatting using the IsEmpty option to set the backcolor again to white if the cell is empty and if it is not it uses the default settings i.e the red as the backcolor of the cell.

    Hope it will help you. Please let me know if you have any queries further.


    Manpreet Kaur

Need extra support?

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

Learn More

Forum Channels