[data grid] Is there capability to have Formula Row, which presents value/text of the selected cell for ease of Row, like Excel/Google Sheet?

[avidear]

Duplicates

• I have searched the existing issues

Latest version

• I have tested the latest version

Current behavior 😯

Is there the capability to have Formula Row, which presents the value/text of the selected cell for ease of Row, like Excel/Google Sheet?

Expected behavior 🤔

Capability like Excel.

Steps to reproduce 🕹

Link to live example:

Steps:
1.
2.
3.
4.

Context 🔦

No response

Your environment 🌎

npx @mui/envinfo

  Don't forget to mention which browser you used.
  Output from `npx @mui/envinfo` goes here.

Order ID 💳 (optional)

No response

[avidear]

Ease of editing

[cherniavskii]

Hey @avidear
No, the Data Grid does not offer formulas during editing.
You can set predefined "formulas" using valueGetter and valueSetter to compute values - see https://mui.com/x/react-data-grid/editing/#value-parser-and-value-setter

[avidear]

I do not need formulas - only something similar to an Excel formula bar, where I can more easily edit Text, Not using any numeric values only text values.
Please let me know if my requirement is clear and if there is an easier/supplemental way of editing text in a cell.

[joserodolfofreitas]

@avidear, if I understand you correctly, you'd like to have a text input above the column headers, that edits the value of whichever cell is on focus. Correct?
I'm curious to understand more about why you would need it; what's the problem you're trying to solve?

If that's your case, perhaps you could implement this feature using the onCellFocusIn (which is currently missing on the API). I believe that with a callback onCellFocus, you can change a custom TextInput to target the row and field given by the event, and update your data directly.

[cherniavskii]

@avidear you can also find our Multiline Editing demo useful https://mui.com/x/react-data-grid/recipes-editing/#multiline-editing

[m4theushw]

I created a demo in #6567 showing how to use the cell selection feature (not released yet) to implement this use case. See https://deploy-preview-6567--material-ui-x.netlify.app/x/react-data-grid/selection/#controlled-cell-selection

[cherniavskii]

@avidear could you check if #6267 (comment) is what you are looking for? Thanks!

[github-actions]

Since the issue is missing key information and has been inactive for 7 days, it has been automatically closed. If you wish to see the issue reopened, please provide the missing information.