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?
ADAdministrator Syncfusion Team August 16, 2005 11:59 AM
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))
ADAdministrator Syncfusion Team August 16, 2005 01: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));
//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;
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 220.127.116.11. I should mention I also defined GridInCellModel, GridInCellRenderer and CellEmbeddedGrid class all from sample.
ADAdministrator Syncfusion Team August 16, 2005 01:42 PM