It would be nice if it was possible to have a grid and have already in a cell the value of 1 and somebody want's to add 4 to it he doesn't have to calculate but could just type 1+4 and the answer (5) would be saved to the grid.
This item is a duplicate of an already existing item. You can find the original item here:
To be blunt, the ability to evaluate expressions and formulas is not something that fits our concept of a data grid. This is something that a spreadsheet type of component would do. A grid does not have a formula expression input like Excel or a spreadsheet do, and its editors are bound to the type of field (e.g., a numeric field will produce a numeric textbox where you can't write text and expressions). A grid's primary goal is to show repeatable data coming from models.
If you want the grid to let the user perform calculations, you can use the cell template to provide the desired calculator and formula expression parsing, and then you can update the model instance that the current row is bound to after you have completed the desired calculation.
I would love to have it really in the grid... so the compleet look and feel of a grid but with adding data to the grid you could use a + or - sign.
I use the grid as an hour writting module and people are writting the amount of time they spend on a project. At the monent they are able to change lines and they have to do the calculation 1+4=5 themself but it would be nice if you could do this in the grid cell self.
The look and feel of a spreadsheet is different and not what i'm searching for
Posted on:09 Jun 2021 08:23
We have another open feature request regarding the Spreadsheet component. This component will expose features that are close to Excel and thus the behavior you are referencing would be handled there.
That being said, I have added your vote for the Spreadsheet component and you can follow the public thread to receive email notifications on status updates. To keep the Feedback Portal tidy I am marking this as a duplicate to the Spreadsheet feature request.