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.

FormulaCell numeric format?

Thread ID:

Created:

Updated:

Platform:

Replies:

5965 Jul 26,2003 03:26 AM Jul 26,2003 04:35 AM Windows Forms 1
loading
Tags: GridControl
Nick Pasko
Asked On July 26, 2003 03:26 AM

Can I set up the Forn\mulaCell numeric format? Or, can I use integer divide somehow? Oh, and the full list of formulas and expressions allowed would be appreciated ;)

Administrator [Syncfusion]
Replied On July 26, 2003 04:35 AM

To format a formulacell, you set the style's Format property. this.gridControl1.ColStyles[3].Format = "0"; this.gridControl1.ColStyles[3].CellType = "FormulaCell"; There is no integer diveide provided currently. You could add your own function to do such a calcultation, or youcould probably come up with a way of using the provide Round function to do it. As far as a list of provided functions, you can see them in this sample, Syncfusion\Essential Suite\Grid\Samples\Quick Start\FormulaGrid, along with sample usage. In the help, you can see them listed in the methods of the FormulaEngine class (if you remove the Compute prefix, you will get the name used to identify function in formulas). ms-help://Syncfusion.EssentialSuite/Syncfusion.EssentialSuite/Syncfusion.Grid~Syncfusion.Windows.Forms.Grid.GridFormulaEngine_members.html

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.

;