Obsolete
Status Update
No update yet.
Comments
jk...@google.com
Can you confirm that the shortcut you're using is Ctrl, minus, and semicolon - all at once?
Is that a windows-specific shortcut perhaps?
Is that a windows-specific shortcut perhaps?
ko...@gmail.com
The shortcut is "Ctrl" and ";" pressed simultaneously.
It is not windows-specific, it is Google Spreadsheets-specific:
seesupport.google.com/docs/bin/answer.py?hl=en&answer=181110
or Help>Keyboard shortcuts in the interface of a spreadsheet.
And please do not solve this problem by retiring the shortcut:
since clicking on an empty date-formatted cell does not invoke
a pop-up date picker (this is another painful issue), the only
quick way for people to enter a nearly current date is to press
Ctrl-; and then edit the resulting current date by means of the
keyboard or the date picker. If you disable this possibility,
the general public (which is not into scripts) will be angry.
It is not windows-specific, it is Google Spreadsheets-specific:
see
or Help>Keyboard shortcuts in the interface of a spreadsheet.
And please do not solve this problem by retiring the shortcut:
since clicking on an empty date-formatted cell does not invoke
a pop-up date picker (this is another painful issue), the only
quick way for people to enter a nearly current date is to press
Ctrl-; and then edit the resulting current date by means of the
keyboard or the date picker. If you disable this possibility,
the general public (which is not into scripts) will be angry.
ko...@gmail.com
Thank you for the additional information. I've been able to replicate the issue and will raise it internally.
an...@gmail.com
Still experiencing this issue. Any progress made on fixing it?
ek...@google.com
ek...@google.com
th...@gmail.com
An issue older than 10 years. O'Rely?!?
jp...@google.com
To better prioritize work in this issue tracker, I am closing this due to a lack of popularity and because it was created prior to 2018. Feel free to open a new issue and link the old one if it is critical to your particular use case.
Description
1. In Tools>Script editor of a spreadsheet,
write onEdit(){Browser.msgBox("Hi")}.
2. Select a cell
3. Press Ctrl-; (the shortcut to insert the current date)
What is the expected output?
The current date in the cell + the "Hi" message
What do you see instead?
Just the current date in the cell, no message
On which browser & OS?
Chrome 19 Windows 7
Please provide any additional information below.
When typing a date manually or using the date picker,
onEdit is fired as expected. However, if my onEdit
is intended to prevent editors from choosing certain
dates, and editors often use Ctrl-;, it is a problem.