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. (Last updated on: June 24, 2019).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback


Thread ID:





1975 Dec 9,2002 05:41 AM UTC Dec 9,2002 10:51 AM UTC WinForms 2
Tags: GridControl
Asked On December 9, 2002 05:41 AM UTC

Hi, I've been playing with your grid tool. Very impressive. Do you have Excel style date calculation where I can type in a date in a cell and simply enter "A1+2" to add 2 days to the date value entered in cell A1? Do you also have date formats defined already thus we can enter Excels date serial number rather than using the MonthControl. This is to enable users to enter data immediatly, without messing around with the calander control. Also do you have an overwite mode? Thus as soon as a user starts to enter data in a cell, the previous content is erased unless the Ecs key is pressed. I'm sure there is an option for this, currently, the default is append mode. In addition, I do like your demo on Excel WorkBooks (within GridPad), however it looks like when I try the "save as..." menu item within GridPad, where a Workbook is selected, only one sheet is saved and not the whole workbook. Thus when loading it back in, I lose the tab navigation bar. What's the possibility of actually having an Excel type WorkBook object within your Grid framework? If possible, cells can refer to other cells on another grid via the FormulaCell type. Just a suggestion... Best Regards, Toyin Akin.

Replied On December 9, 2002 05:54 AM UTC

Okay, I've solved the problem with the overwrite mode and presenting the date as a formatted date. However because the date is actually entered as a string 1/1/2002, you cannot do additions on this. Is it possible for the calculation engine to detect that this is a DateTime variable and to apply the correction addition? Regards, Toy.

Administrator [Syncfusion]
Replied On December 9, 2002 10:51 AM UTC

Toy, Currently the formula support in Essential Grid does not support any date functions or cross sheet references. We will add support for both these features in future releases... It is straight forward to add your own DaysAdd function to the library that will accept a date string and add a number of days to this date, and then return this new date as a string. Attached is a sample project that shows how you can do this. You could actually add a library function to do cross sheet references as well, but that might be a little more involved...


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