Posted 30 August 2018, 10:45 am EST - Updated 30 September 2022, 5:11 am EST
Hello! I am new with Spread, and I am practicing with the trial version, to implement the UserControl in my business applications.
To explain what I am trying to do, I will give a reference example. Suppose we have a material with some particular composition, which we can take as reference to catalog other similar materials. A base material could be iron, and its properties could be its hardness, its mass, etc. Now, we have a sample of iron, which varies subtly from the base iron, and we want to know these differences through colors in the cells.
The only row that has the grid that I have made, has 7 columns. The first column contains a simple description, from columns 2 to 4 are the properties of the new material, and from column 5 to 7 the properties of the base material.
In the cell corresponding to Prop1 I defined a Formatting Condition, in which, if the value of Prop1 is different from the value of Prop1_Ref, it is painted red. This behavior is analogous to Prop2 with Prop2_Ref, and Prop3 with Prop3_Ref.
Now I finally ask my question: How can I add successive rows that replicate the exact behavior of the example row? Or is the only way to replicate the generated source code?
The rows will be loaded programmatically, I will take objects from my business layer to set the base values (Description and Prop1_Ref, Prop2_Ref, Prop3_Ref).
I attach the solution in WinForms.
Thank you very much!