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

Relative formula cell references

Thread ID:





30577 Jun 20,2005 06:43 PM UTC Jun 20,2005 09:04 PM UTC WinForms 2
Tags: GridControl
Administrator [Syncfusion]
Asked On June 20, 2005 06:43 PM UTC

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 08:03 PM UTC

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

Thanks! That did the trick!


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