Disable calculate for "FormulaCell" type

[Administrator]

Hello again,

It's possible disable all calculate for cells of type "FormulaCell" or calculate engine? How? It's specified type cell is very like I need, but I need disable all calculations in sheet in my application (not like calculate suspended, is total disabled).

Thanks.

[Administrator]

I have made some tests, one solution is change the celltype for "TextBox", but when use this type, formated values are disabled, is no good for my use.
Other idea for it? I need only disable calculation for "FormulaCell", but without lost other uses for this type (like formated numbers of "FormulaCell").

For example:

CellType: FormulaCell
Value: 1
Cell.Style.Format = "0.0"
Result: 1,0

CellType: TextBox
Value: 1
Cell.Style.Format = "0.0"
Result: 1 (no corret for my use, the correct value would 1,0)

Thanks.

[Jisha Joy]

Hi Rossa,

Please try the following codes and let me know if this helps.

this.gridControl1[2, 2].CellValueType = typeof(Double);
this.gridControl1[2, 2].CellValue = 1;
this.gridControl1[2, 2].Format = "0.0";

Regards,
Jisha

[Administrator]

Hi Jisha,

This code helped me, thanks.

>Hi Rossa,

Please try the following codes and let me know if this helps.

this.gridControl1[2, 2].CellValueType = typeof(Double);
this.gridControl1[2, 2].CellValue = 1;
this.gridControl1[2, 2].Format = "0.0";

Regards,
Jisha