Implementing fill right/down

[Administrator]

Hi,

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.

Thanks.

[Administrator]

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.

Regards,
Haneef

[Administrator]

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.

Thanks.