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

Grid FormulaCell: position of A1 cell

Thread ID:





44573 May 26,2006 08:13 PM UTC May 27,2006 09:25 AM UTC WinForms 1
Tags: GridControl
Jean-Francois Girouard
Asked On May 26, 2006 08:13 PM UTC

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 09:25 AM UTC

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.



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

or the page will be automatically redirected to 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