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.
AD
Administrator
Syncfusion Team
November 13, 2008 01:52 PM UTC
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.
JJ
Jisha Joy
Syncfusion Team
November 14, 2008 11:53 AM UTC
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
AD
Administrator
Syncfusion Team
November 14, 2008 01:09 PM UTC
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