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.

Relative formula cell references

Thread ID:

Created:

Updated:

Platform:

Replies:

30577 Jun 20,2005 02:43 PM Jun 20,2005 05:04 PM Windows Forms 2
loading
Tags: GridControl
Administrator [Syncfusion]
Asked On June 20, 2005 02:43 PM

Hi, This may seem like a basic question but I can’t get it to work and I can’t find an answer in the forums. ‘I create a cell at E4 grid(4,5).CellValue = 123 ‘I create a formula at E3 which references that cell grid(3,5).CellType = “FormulaCell” grid(3,5).Text = “=Sum(E4)” ‘When I do this grid.Model.Rows.InsertRange(3, 1) I get a circular reference error because cell E3 is now E4. How do I put in a relative cell reference in E3’s formula so that inserting/deleting rows will adjust the cell reference accordingly. Thanks

Administrator [Syncfusion]
Replied On June 20, 2005 04:03 PM

Try setting these flags to see if this makes things work better. dim engine As GridFormulaEngine = CType(this.gridControl1.CellModels("FormulaCell"), GridFormulaCellModel).Engine; engine.FormulaCopyFlags = engine.FormulaCopyFlags Or GridFormulaCopyFlags.InsDelRangeReferencesUpdated engine.FormulaCopyFlags = engine.FormulaCopyFlags OR GridFormulaCopyFlags.ClipBoardReferencesAdjusted

Administrator [Syncfusion]
Replied On June 20, 2005 05:04 PM

Thanks! That did the trick!

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.

;