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.

Grid FormulaCell: position of A1 cell

Thread ID:

Created:

Updated:

Platform:

Replies:

44573 May 26,2006 04:13 PM May 27,2006 05:25 AM Windows Forms 1
loading
Tags: GridControl
Jean-Francois Girouard
Asked On May 26, 2006 04:13 PM

Hi I am trying to setup a data grid with 3 header rows. By doing this, my first data cell is in [3,1], and to reference this cell using a formula, I have to use "A3" (ex: "=A3*2"). Since it is the top-left cell in my grid, I would prefer to use "A1" to reference this cell. Is it possible to do that? Thanks, Jean-Francois

Administrator [Syncfusion]
Replied On May 27, 2006 05:25 AM

There is no property setting that will handle this. One way to get this behavior is to use 2 grids, a headergrid and the main grid. You could have a Panel and docked the headergrid to the top and just let it have the 3 headers and no other rows. Then you could dock-fill the main grid and hiding its header row. You can then handle some event to tie the two grid togerther so scrolling is synced up and column sizes are synced up. Attached is a little sample.

PanelWithTwoGrids.zip

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.

;