Posted 8 September 2017, 2:19 pm EST
I have defined celltype as numbercelltype and assign the following property to my number cell type.
ncell.NegativeFormat = FarPoint.Win.Spread.CellType.NegativeFormat.Parentheses
I am populating this cell with some database values with calcuation
spdata.sheet.cells[0,0].text = value1 + value2;
Value1 and Value2 both are comming from database and both are negative numbers but it is display in cell as positive number without Parentheses.
If I us the following code
spdata.sheet.cells[0,0].text = value1 ; It is giving me correct out put with Parentheses.
Why this happens.