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.

Formula

Thread ID:

Created:

Updated:

Platform:

Replies:

13715 May 7,2004 06:41 AM May 7,2004 06:48 PM Windows Forms 2
loading
Tags: GridControl
Satish
Asked On May 7, 2004 06:41 AM

Clay, I have specific requirement. The use of references within the same sheet, being that formulas should not use “spreadsheet-styled” cell references (i.e. should not expect A23+B23) but #23+#24 instead. How can this be done? Thanks Satish

Satish
Replied On May 7, 2004 06:44 AM

One more requirement is, How Can I change the font color if current cell has the formula. say user can enter 10 or he will enter =10+20 then the color of the cell should be change. Thanks Satish >Clay, >I have specific requirement. > >The use of references within the same sheet, being that formulas should not use “spreadsheet-styled” cell references (i.e. should not expect A23+B23) but #23+#24 instead. > >How can this be done? > >Thanks >Satish

Administrator [Syncfusion]
Replied On May 7, 2004 06:48 PM

There is no support currently for something like =#23+#24. To conditionally color a formula cell, you can handle PrepareViewStyleInfo. In you handler, you can use code such as if(e.Style.CellType == "FormulaCell" && e.Style.Text.Length > 0 && e.Style.Text[0] == ''='') e.Style.BackColor = Color.LightBlue;

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.

;