Posted 8 September 2017, 12:43 pm EST
Hope sombody can help. I have a spread which has been databound.
I have a cell which contains an empty string in the underlying table (data type is string). I have put a formula in the cell is FSpread (.NET windows version). I cant seem to format the cell in any way. I have tried using a GeneralCellType and setting the celltype of the cell to this type.
I have also tried
stringsom = tempval.ToString("%##,##.##");
UnderlyingTable[rownum][colnum] = som;
spread.Sheets.Cells[rownum, colnum].Value = som;
spread.Sheets.Cells[rownum, colnum].Text = som;
Any ideas, I know that if I convert the underlying datatable column to be of a type double, the cell will accept the formatting, but I am trying to get away from this.