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 in Cell

Thread ID:





11496 Mar 8,2004 09:03 PM Mar 9,2004 07:08 AM Windows Forms 4
Tags: GridControl
Asked On March 8, 2004 09:03 PM

Hi there, Please find the document. This is my requirement. Thanks Satish Formula_Editor_4494.zip

Administrator [Syncfusion]
Replied On March 9, 2004 03:11 AM

Without coding more than a line or two, you can put a GridAwareTextBox and a GridControl on a panel and have behavior close to what you described. It will be more Excel like in that as you type into the textbox, you see the characters entered dynamically in the cell below. And you enter an ''='' as the first character to signal that you are typing a formula. Below is a sample link that tries this with minimal work. If you want exactly what you described, then I think you could do it using your own textbox and then setting the cell value in teh OK handler. You could require teh = or not at tis point by adding it automatcically when you push teh value to teh cell in your button handler.

Administrator [Syncfusion]
Replied On March 9, 2004 03:12 AM

Here is the sample. forum11496_1110.zip

Replied On March 9, 2004 05:58 AM

Hi Clay, Excellant code and very fast reply. But I have one more question. What all formula''s this grid supports. Can I make add generic formula to the grid. Thanks Satish >Here is the sample. > >forum11496_1110.zip > >

Administrator [Syncfusion]
Replied On March 9, 2004 07:08 AM

Yes, you can add your own formulas. See this sample. It lists all the formulas we ship as well as shows you how to add your own. Syncfusion\Essential Suite\Grid\Samples\Quick Start\FormulaGrid


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.