search

jspreadsheet / ce

Jspreadsheet is a lightweight vanilla javascript plugin to create amazing web-based interactive tables and spreadsheets compatible with other spreadsheet software.
https://bossanova.uk/jspreadsheet/v4
MIT License
6.77k stars 828 forks source link

Update cell with another input #1371

Closed kevinirlen closed 3 years ago

kevinirlen commented 3 years ago

Hi

I don't know if this has been asked yet. Basically, I have an input field, when I click on a cell, the content of the cell shows up in the input field. (Similar to google sheet)

But when I try to edit the cell value from this input field, it doesn't work. Somehow the focus stays on the cell itself.

How do I fix this this please ?

GBonnaire commented 3 years ago

maybe i don't understand your problem. If it is a case, can you create a jsfiddle for explain your probleme ?

If you want make a custom editor, you have an example here : https://bossanova.uk/jspreadsheet/v4/examples/column-types

if you want set value of cell with input out of spreadsheet, please use myTable.setValue('A1', 'myValue');

fireclw commented 3 years ago

maybe i don't understand your problem. If it is a case, can you create a jsfiddle for explain your probleme ?

If you want make a custom editor, you have an example here : https://bossanova.uk/jspreadsheet/v4/examples/column-types

if you want set value of cell with input out of spreadsheet, please use myTable.setValue('A1', 'myValue');

I guess I know what his question is and I'm sharing same question:

For example, I'm creating a formula for my sheet, what I want to do is in Cell A1, create formula "=SUM(B1,C33,K3)".

But instead of type in the formula string, can I just type in “=SUM(" -> click on B1 -> String "B1" added to my Cell A1 formula "=SUM(B1," -> click on C33 -> String "C33" Add to formula, etc

Hope it clear the question and looking for your reply and help. Best

GBonnaire commented 3 years ago

like this : https://demo.gbonnaire.fr/jExcel/plugin.formula.php But this plugin it's only for jSpreadsheet Pro

hodeware commented 3 years ago

There is no native implementation for that feature. But, you can implement that using third-party extensions.

kevinirlen commented 3 years ago

There is no native implementation for that feature. But, you can implement that using third-party extensions.

Hmmm, do you have any third party in mind ?

hodeware commented 3 years ago

https://demo.gbonnaire.fr/jExcel/plugin.formula.php

fireclw commented 3 years ago

Thanks!

H. Paul @.***>于2021年6月4日 周五下午2:36写道：

https://demo.gbonnaire.fr/jExcel/plugin.formula.php

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/jspreadsheet/ce/issues/1371#issuecomment-854927759, or unsubscribe https://github.com/notifications/unsubscribe-auth/ABIHGQP6PCZCDQNN4GYKAZDTREMKPANCNFSM44X7KQ5Q .