Formula support...

[Toyin]

Hi,

I do like the ease of adding formulas...
much better than Farpoint's Spread control.

Is it possible to freeze the automatic formula recalculation? for instance, I would like to disable recalculation, update the cells of interest and then force a single recalculation of the whole grid. This is especially true if some of the functions I have in place or solvers that require quite a bit of time to recalculate.
changing a single input parameter and watching it recalculate is not ideal.

Also, any tips on displaying a range of values from a calculation? (A matrix as a result for instance) Is there any way we can bleed onto other cells? Can we use a GridInCell control and write to that?

Thanks in advance,
Toy.

[Administrator]

Toy,

There is no way to suspend the calculations currently. We will add such a method, and it should be in our next patch release.

You could easily display comma separated values with no additional work.

To use a gridincell, you would have to derive the GridFromulaCellRenderer/Model and handle the draw to diaply a grid when the cell is not being edited. There are some problems in doing this currently which we will try to work out in the next day or so. When I get it done, I'll post here.

[Toyin]

Sounds great,

What's the possibility of adding this gridincell via a formula to the framwork itself. I see this as equvalent to the formula range support currently within Excel.

For instance a user can call a fucntion called DisplayTable("Products"), and this produces a gridInCell with the columns of the table. The other approach would be to have a drop down where the gridInCell is display.

The possibilities are endless for the user in what s/he can do with this type of feature at runtime. Also for the developer in the types of functions s/he can provide (ie a calculation which returns multiple values, the developer has the freedom to display/format the data how s/he wants within a GridInCell.

What do you think?

Best Regards,
Toy.

[Administrator]

You can probably get a grid to display a calculated matrix in a cell without too much trouble. It may take some non-trivial cleanup work, but attached is a sample that adds a MatrixAddNumber function to the function library and displays its result as a GridInCell.

It does this by deriving GridFormulaCellModel and GridFormulaCellRenderer, and in the Renderer's OnDraw override, it checks to see if the computed value contains \t or \n, and if so, it displays the result in a static grid.

[JT]

Has this issue been resolved? I''m currently using Essential Grid version 2.0.2.0 and would like to suspend the recalculations until the grid has updated some cell values.

There is no way to suspend the calculations currently. We will add such a method, and it should be in our next patch release.

You could easily display comma separated values with no additional work.

To use a gridincell, you would have to derive the GridFromulaCellRenderer/Model and handle the draw to diaply a grid when the cell is not being edited. There are some problems in doing this currently which we will try to work out in the next day or so. When I get it done, I''ll post here.

[Administrator]

The current code base has a engine.CalculatingSuspended property that you can set to suspend cell calculations by setting it to true, then later resetting it to false, and then engine.RecalculateRange to do the calculations that did not get done.