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. Image for the cookie policy date
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Formula in Cell

Thread ID:





11496 Mar 9,2004 02:03 AM UTC Mar 9,2004 12:08 PM UTC WinForms 4
Tags: GridControl
Asked On March 9, 2004 02:03 AM UTC

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

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

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 08:12 AM UTC

Here is the sample. forum11496_1110.zip

Replied On March 9, 2004 10:58 AM UTC

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 12:08 PM UTC

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.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon 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.Close Icon

Live Chat Icon For mobile
Live Chat Icon