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.
Syncfusion Feedback

Implementing fill right/down

Thread ID:





48865 Sep 5,2006 02:12 PM Sep 7,2006 04:45 PM Windows Forms 2
Tags: GridControl
Administrator [Syncfusion]
Asked On September 5, 2006 02:12 PM


I need to implement fill right/down functionality similar to Excel. I know how to do the basic fill using gridmodel.ChangeCells. What I don''t know is how to adjust any formulas that are part of the fill. I guess you could just simulate a paste over and over but I''m wondering if there is an easier and more efficient way.


Administrator [Syncfusion]
Replied On September 6, 2006 03:15 AM

Hi Amit,

There are properties that you set to tell the GridFormulaEngine to do the work required to update referecnes as you insert/delete rows/columns or copy/paste formulas. Try setting these properties:

this.gridControl1.TableStyle.CellType = "FormulaCell";

this.engine = ((GridFormulaCellModel)gridControl1.Model.CellModels["FormulaCell"]).Engine;
engine.FormulaCopyFlags |= GridFormulaCopyFlags.InsDelRangeReferencesUpdated;
engine.FormulaCopyFlags |= GridFormulaCopyFlags.ClipBoardReferencesAdjusted;

Please let me know if you need more information.


Administrator [Syncfusion]
Replied On September 7, 2006 04:45 PM

I know about the gridformula copy flags. They don''t take effect when using ChangeCells. That''s why I was saying that the only way I can see to adjust formulas is to simulate a paste over the whole range you want to fill. This would be very slow and I was wondering if there is a more efficient, syncfusion recommended way.



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.

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