excelR icon indicating copy to clipboard operation
excelR copied to clipboard

Published 20 hours ago • verified publisher icon Swechhya

changing cell content

Open pi-at-git opened this issue 3 years ago • 2 comments

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 avatar Jan 23 '22 15:01 pi-at-git

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.

pi-at-git avatar Jan 24 '22 05:01 pi-at-git

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

Swechhya avatar Jan 24 '22 12:01 Swechhya