Conditional formatting not evaluating after cell change

Conditional formatting not evaluating after cell change

Posted by: joni.dewinter on 3 August 2021, 6:09 am EST

• 

  joni.dewinter

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  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

• 

  avinash.pathak

  

  • Post Options:
  • Link
    Copy

  Posted 4 August 2021, 3:29 am EST

  Hi Joni,

  For this, You may need to use the Update method inside the EditStopped event. Please refer to the following code snippet and let us know if you face any issues.

  '
     <script>
          window.onload = function () {
              var spread1 = document.getElementById("<%=FpSpread1.ClientID %>");
              spread1.addEventListener("EditStopped", () => {
                  spread1.Update()
              })
          }
      </script>
  
  

  API References:

  EditStopped: https://www.grapecity.com/spreadnet/docs/v14/online-asp/CSSR-onEditStopped.html

  Update method: https://www.grapecity.com/spreadnet/docs/v14/online-asp/CSSR-Update.html

  Regards
  
  Avinash

• 

  joni.dewinter

  • Post Options:
  • Link
    Copy

  Posted 4 August 2021, 11:45 am EST

  Hello Avinash

  The proposed solution seems to be a viable workaround for us, thanks.
  
  Is there any chance though that it will work in the future without this extra callback?

  Kind regards
  
  Joni

• 

  avinash.pathak

  

  • Post Options:
  • Link
    Copy

  Posted 5 August 2021, 4:49 am EST

  Hi Joni,

  This is by design changing the cell on the client-side will not be updated and evaluated until we call to save or call the update method.

  since this is the design calling the update method would be recommended for this functionality. Please let me know if you face any issues while using the suggested approach.

  Regards
  
  Avinash

• 

  joni.dewinter

  • Post Options:
  • Link
    Copy

  Posted 5 August 2021, 5:03 am EST

  Hello Avinash

  Thanks for the clarification, this topic can be closed as it’s working as designed then.

  Kind regards
  
  Joni