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.

Use formula cell type inside "GridinCell"

Thread ID:

Created:

Updated:

Platform:

Replies:

33238 Aug 16,2005 11:52 AM Aug 17,2005 09:40 AM Windows Forms 4
loading
Tags: GridControl
Najmeh Joze-khajavi
Asked On August 16, 2005 11:52 AM

I have reviewed the sample "GridinCell" and I have the following questions: 1- Is it possible the type of cell in child grid be formulaCell type? 2- If the answer of above question is yes then how I can have access to that formula in parent grid. For example if I have formula "=Cos(Pi(0))" in cell A1 of child grid can I use this in parent grid? For example say ="A1 + sin(pi(0))" in cell E1 of parent grid. How can I refer to A1 in child grid compare to A1 in parent grid? I tried to use the sample code in my application to test the above and I wasn''t successful. My parent grid is part of multisheet grid. So I have already register that as sheet. Is there any conflict?

Administrator [Syncfusion]
Replied On August 16, 2005 12:59 PM

Try registering the GridInCell grid in the same manner as you do the multisheet grids. Then to reference a cell in the GridInCell grid from within the parent grid, you would include the sheet reference as part of the formula. eg. =GridInCellSheet!A1 + Sin(PI(0))

Administrator [Syncfusion]
Replied On August 16, 2005 02:07 PM

This is the way I have registered the GridinCell in load form: //register custom celltype this._SettingsGrid.CellModels.Add("GridinCell", new GridInCellModel(_SettingsGrid.Model)); GridControl protectionGrid; //place the new celltype into each of covered cells using upper-left corner //also set a different grid into the Tag of each cell this._SettingsGrid[20,1].CellType = "GridinCell"; this._SettingsGrid.CoveredRanges.Add(GridRangeInfo.Cells(20, 1, 24, 3)); protectionGrid = new CellEmbeddedGrid(this._SettingsGrid); protectionGrid.BackColor = Color.Red; protectionGrid.RowCount = 10; protectionGrid.ColCount = 3; protectionGrid[1,1].Text = "this is a 10x3 grid"; protectionGrid.ThemesEnabled = true; this._SettingsGrid[2,1].Control = protectionGrid; this._SettingsGrid.Controls.Add(protectionGrid); In run time I don''t see any text (this is a 10x3 grid). I don''t see red backColor. All I see is a rectangle starts from cell (20,1) and ends at cell (24,3) which is correct corner but it is not a grid. By the way I am using Syncfusion 3.0.1.6. I should mention I also defined GridInCellModel, GridInCellRenderer and CellEmbeddedGrid class all from sample.

Administrator [Syncfusion]
Replied On August 16, 2005 02:42 PM

>>this._SettingsGrid[2,1].Control = protectionGrid; Try setting: this._SettingsGrid[20,1].Control = protectionGrid;

Najmeh Joze-khajavi
Replied On August 17, 2005 09:40 AM

Ok. Thanks for finding my mistake.

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.

;