Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Excel like formula feature #6

Open
salimtirit opened this issue Jul 19, 2022 · 3 comments
Open

Excel like formula feature #6

salimtirit opened this issue Jul 19, 2022 · 3 comments
Labels
enhancement New feature or request

Comments

@salimtirit
Copy link

I am trying to use formulas in the sheet. To do this I used to-text prop then executed the input if it starts with = symbol. Now I want to show the formula when the cell is double clicked (in the edit mode). Is there a way to do this?

@cscan
Copy link
Owner

cscan commented Aug 1, 2022

No simple way to do this. I suggest you may try to toggle the visibility of 2 columns and add the onChange event to make necessary changes. Anyway, I will consider to add the focus or double-click event in the future.

@salimtirit
Copy link
Author

salimtirit commented Aug 3, 2022

I gave up on this idea and went with another solution. Here is what I did:
I used another json to keep the formulas and listened the cell-focus event. I found the corresponding formula (if there is one) when the cell-focus event occurs then showed it in an input field above the actual table. This also makes it possible to edit the formula. If it is changed I execute it and write the outcome back to the data.
Thank you for considering adding new events I think it will be better.

@cscan
Copy link
Owner

cscan commented Aug 6, 2022

Yes, you may also use get set variable in javascript. Will follow up about adding events

@cscan cscan added the enhancement New feature or request label Aug 6, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

2 participants