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

FormulaCell numeric format?

Thread ID:





5965 Jul 26,2003 07:26 AM UTC Jul 26,2003 08:35 AM UTC WinForms 1
Tags: GridControl
Nick Pasko
Asked On July 26, 2003 07:26 AM UTC

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

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


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