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

WorkBooks...

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.

2 Replies

TO Toyin 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 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...
Loader.
Live Chat Icon For mobile
Up arrow icon