Do I need standard or Pro ver of grind and other components?

Suite and Optimus Suite 5
#1

Please tell me what I need do do the following:

  1. Create a worksheet which consist of two grids which work together. The two grids are populated with data from the database. One grid can can modify the cells in a column from user inputs. One or more columns can have checkboxes that when clicked, database functions are called to recalculate values for other columns in the grid for that row. Once the new values are calculated, a total row row at the bottom of the grid are recalculated. Also the second grid is updated with the aggregate of columns for related rows. Similar to a master detail. The detail is rolled up and stuffed into the master grid with the master key.

  2. Tabs so that theses pair of worksheets can be opened in thier own tab

  3. database insert update and delete

#2
  1. It can be done with “math calculation” extension. This extension is avaialble in pro version only
  2. Unfortunately this requirement is not clear. Can you please provide more information?
  3. It can be done in standard version
#3

I would like tabs like excel workbooks. Put several grid in one tabbed panel and another panel could hold a couple other grids. The user could then tab between the panels,

How advanced is the math for columns. Can i do if…then and formula stuff like excel?

Can you make changes in the grid without immediate write back to the grid with the processor interface. then can you save when a you click a button. This way you can make a buch of changes until you get things the way you want then all of the changes saved at once without any extra coding?

Thank you

#4

I would like tabs like excel workbooks. Put several grid in one tabbed panel and another panel could hold a couple other grids. The user could then tab between the panels,
You can use “onTab” grid event and control tab navigation between grids.

How advanced is the math for columns. Can i do if…then and formula stuff like excel?
Please check documentation here dhtmlx.com/docs/products/dht … _math.html

Can you make changes in the grid without immediate write back to the grid with the processor interface.
dp.setUpdateMode(“off”)
where dp - instance of DataProcessor
docs.dhtmlx.com/doku.php?id=dhtm … ialization