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: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Use formula cell type inside "GridinCell"

Thread ID:





33238 Aug 16,2005 03:52 PM UTC Aug 17,2005 01:40 PM UTC WinForms 4
Tags: GridControl
Najmeh Joze-khajavi
Asked On August 16, 2005 03:52 PM UTC

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 04:59 PM UTC

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 06:07 PM UTC

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 I should mention I also defined GridInCellModel, GridInCellRenderer and CellEmbeddedGrid class all from sample.

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

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

Najmeh Joze-khajavi
Replied On August 17, 2005 01:40 PM UTC

Ok. Thanks for finding my mistake.


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