I know that Syncfusion Grids can handle formulas (e.g. cell operations, sum(), average()...) Is there any VB example that shows how to copy and paste formulas within a Syncfusion Grid?
Thanks
BM
Bharath M
Syncfusion Team
April 21, 2010 05:11 AM UTC
Hi Bill,
Thank you for your interest in Syncfusion products.
Before I proceed to give you a solution, Could you please confirm the Essential Grid, that you are using(ASP.Net, Windows, WPF etc.,).
The information provided would be of great help in resolving the issue.
Regards,
Bharath
BK
Bill Korchinski
April 21, 2010 10:08 PM UTC
It's Windows. What I'm really interested in doing is copy a formula from one cell in a grid & pasting it into another cell. Ideally, I would like the newly-pasted formula to be relative cell references (i.e. so that the new formula refers to a new set of cells with the same relationships as the old formula).
JJ
Jisha Joy
Syncfusion Team
April 23, 2010 11:47 AM UTC
Hi Bill,
To update references in formula cells while handling pasting, please handle the following settings:
GridFormulaEngine engine = ((GridFormulaCellModel)this.gridControl1.CellModels["FormulaCell"]).Engine;
engine.FormulaCopyFlags |= GridFormulaCopyFlags.ClipBoardReferencesAdjusted;
Please let me know if this helps.
Regards,
Jisha
