I`m having problems with conditional formatting of cells.
The problem is that when u have conditional formatting on cell (for example if value is greater than 5 cell has to be filled in red) and in original document u have value 3 (so cell is not filled in red), after in code u are only changing the value of the cell from 3 to 6 and save document (we dont do any manipulations with document in code, except of changing value of cell and save document) - the value is changed, conditional formatting is present for the cell, but cell is not filled in red. Conditional formatting applies fill in red only after u click on the cell and press “Enter”
I have version of Aspose.Cells 19.9.0
Thank u in advance.