We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

Disable calculate for "FormulaCell" type

Thread ID:

Created:

Updated:

Platform:

Replies:

77691 Nov 12,2008 02:52 PM Nov 14,2008 08:09 AM Windows Forms 3
loading
Tags: GridControl
Administrator [Syncfusion]
Asked On November 12, 2008 02:52 PM

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 [Syncfusion]
Replied On November 13, 2008 08:52 AM

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 [Syncfusion]
Replied On November 14, 2008 06:53 AM

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 [Syncfusion]
Replied On November 14, 2008 08:09 AM

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




CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.

;