Posted 3 August 2021, 6:09 am EST - Updated 30 September 2022, 11:41 am EST
In Spread.NET V14 in ASP.NET MVC, when using conditional formatting, the rules don’t seem to evaluate upon cell changes.
We use the following example (between 0-10), based on documentation:
var celRange1 = new CellRange(0, 0, 4, 1);
var between = new BetweenValuesConditionalFormattingRule(false, 0, false, 10, false)
{
BackColor = Color.Bisque
};
spread.Sheets[0].SetConditionalFormatting(new CellRange[] { celRange1 }, between);
When filling in 15, the rule should not apply any color, but still does.
Only if we save and/or reload the sheet, we evaluation is done and the rule color is applied:
Is there any way to let the rule evaluate immediately?
Thanks in advance.
Kind regards
Joni