Swechhya / excelR

An Interface to 'jExcel.js' Library
https://swechhya.github.io/excelR/
Other
152 stars 19 forks source link

changing cell content #105

Open pi-at-git opened 2 years ago

pi-at-git commented 2 years ago

Hello! I'd like to use your great package for data input. When I select a cell by a single click and start typing a letter or a number everything works as expected. However, starting with characters such as "." (e.g. for .5, leaving out the leading zero for laziness) or "-" (e.g. -5) ">" (e.g. ">5") or "<" (e.g. "<5") nothing happens. I noticed that I have to enter the cell by either double click or pressing F2 after single click if I want enter any of afore mentioned examples. excelR differs here from behavior of LibreOffice Calc or Excel. Bug or feature or am I doing something wrong?

pi-at-git commented 2 years ago

I noticed a browser dependency here: in Chromium 97.0.4692.99/Ubuntu (as well a 95.x under Windows 10), it is possible to start with a "-" when you want to enter data after selection of a cell by a single click, while this does not work in Firefox 96/Ubuntu. Starting with ".", "<", or ">" does not work in Chromium either.

Swechhya commented 2 years ago

@pi-at-git Can you download the latest development version and check if you are still facing this issue?