BoldSignEasily embed eSignatures in your .NET applications. Free sandbox with native SDK available.
GridFormulaEngine engine = ((GridFormulaCellModel)gridControl1.Model.CellModels["FormulaCell"]).Engine;
engine.FormulaCopyFlags |= GridFormulaCopyFlags.InsDelRangeReferencesUpdated;
engine.FormulaCopyFlags |= GridFormulaCopyFlags.ClipBoardReferencesAdjusted;
>2) Following on from the FormulaCellSelection example in the documentation, is there a way to scoll to the bottom of a range using (e.g.) the END key or SHIFT+END to highlight? I tried looping through the cells until I found an empty cell, but it was very very slow!
There is no magic way to do this. You will have to loop through cells. If your grid is holding data in its grid.Data object, you can speed things up by a factor of probably 5-10 times by directly accessing the grid.Data object and not accessing the grid object through the indexer. This avoids events at the grid level.
if(grid.Data[row, col] != null) { GridStyleInfo style = new GridStyleInfo(grid.Data[row, col]); if(style.Text.Length == 0) { // emty cell } }} >3) Array style formulae (i.e. formulae that return an array, rather then a single value). Are these supported? These are not directly supported. Here is an old forum thread that has a sample of si=omething of this nature in it. http://www.syncfusion.com/Support/Forums/message.aspx?MessageID=1995 > >Suggestion: I tried to add a generic formula, but failed. It would be great if within the formula delegate one could find out the string name of the formula that was invoked. It would be possible to add an engine property that held the name of the function being called during the call, but I am not sure how this would work out duing recursive type calls, etc. Likely it would just work, but we would have to investigate this to make sure we would not be cauing a problem.
>GridFormulaEngine engine = ((GridFormulaCellModel)gridControl1.Model.CellModels["FormulaCell"]).Engine;
>engine.FormulaCopyFlags |= GridFormulaCopyFlags.InsDelRangeReferencesUpdated;
>engine.FormulaCopyFlags |= GridFormulaCopyFlags.ClipBoardReferencesAdjusted;
This throws a null reference exception in syncfusion.grid.windows.dll. ("Additional information: Object reference not set to an instance of an object.")
I have looked at
http://www.syncfusion.com/Support/Forums/message.aspx?MessageID=1995
I have not had time to try this out yet, but notice that you say
"It may take some non-trivial cleanup work, but attached>/B> is a sample that adds a MatrixAddNumber function to the function library and displays its result as a GridInCell."
Is this example still available? It''s no longer still attached to the forum.
Thank you
Charlie