Description: I'm using LibreOffice 7.5.1.2 on a MacBook Air 2019. In Calc I want to insert a timestamp in a cell with key combination Command+Shift+; , but that is doing nothing at all although I found that key combination in a Help Tip (once a day). When I use the Menubar -> Insert -> Time, it works by clicking with mouse or something, but I don't see the key combination at the right of the word Time. Steps to Reproduce: 1.Open a Calc and be sure a cell is selected. 2.Do what is written in Help Tip 42/224: key combination Command+Shift+;. 3. Actual Results: The cell in Calc remains empty. Expected Results: A timestamp should inserted in the selected cell. Reproducible: Always User Profile Reset: No Additional Info: Version: 7.5.1.2 (X86_64) / LibreOffice Community Build ID: fcbaee479e84c6cd81291587d2ee68cba099e129 CPU threads: 4; OS: Mac OS X 13.2.1; UI render: default; VCL: osx Locale: nl-BE (nl_BE.UTF-8); UI: en-US Calc: threaded
What keyboard layout do you use?
I am using a AZERTY keyboard which is the normal used keyboard in Belgium for the Dutch people. It works fully correct.
Thank you, Alexander. That makes your report a duplicate of the older bug 129547. *** This bug has been marked as a duplicate of bug 129547 ***
Excuse me? Resolved? Duplicate of bug 129547 ?! I am talking about LibreOffice on MacBook Air which is an Apple computer with a build-in AZERTY keyboard, in the help Tip I read "Command", not "Ctrl".
My understanding is that it would have the same root cause. I'm happy to set back to unconfirmed until someone else who knows more about keyboard layout detection chimes in. What happens if you use the Date field shortcut, Command + ; ?
Shortcut Command+; to become a Datestamp, is doing nothing either.
Could it be that this is related? https://ask.libreoffice.org/t/ctrl-doesnt-insert-date-into-cell-in-calc-on-dell-xps-13-plus/89139/6 " ibus-setup was using it for inserting emoticons. I deleted it and now LO sees the hotkey and inserts the date into a cell. [...] It appears it defined TWO hotkeys for inserting emoticons, Control-period and Control-semicolon. I have no idea why they would define TWO. I don’t use emoticons so I just deleted the hotkey Control-semicolon in ibus-setup. "
What is this? On an Apple computer it is NOT Ctrl, it is Command according the help tip ! And secondly what is ibus? Never heard of. And I have written: "nothing happens", so I don't see an emoticon appearing either.
(In reply to Eike Rathke from comment #7) > ibus-setup was using it for inserting emoticons. I deleted it and now LO > sees the hotkey and inserts the date into a cell. The insertion of date and/or time stamps in Calc by means of default keyboard shortcuts, for _all_ OSs has been broken since... Having to use [SHIFT] in some layouts was thought as part of the problem (I'd bet it's not enough). I lost track of the dups already. Basically, it works for QUERTY USA layout; maybe by chance in some other case.
Julien Nabet committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/e056c1ce10779b42ae17866913cf4db06b86a491 Related tdf#129547 and tdf#154136: add COLON key It will be available in 7.6.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Setting as confirmed
Julien Nabet committed a patch related to this issue. It has been pushed to "libreoffice-7-5": https://git.libreoffice.org/core/commit/a9f718eaf505148f0ffd0994b8aa5e4e0d1dac11 Related tdf#129547 and tdf#154136: add COLON key It will be available in 7.5.3. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Despite the patch, cmd+shift+; doesn't do anything (or colon for that matter, since the patch notes mention that) Tested with Norwegian keyboard layout where ";" is on the "," key FYI: I tested and it works in Excel In Excel the shortcut for inserting date is ctrl+shift+; Only cmd+; as mentioned in the comment #5 would not work, as cmd+, is the shortcut key for preferences Version: 24.2.0.0.beta1 (AARCH64) / LibreOffice Community Build ID: 5f390384195b7264c6e52add9e90a39790285249 CPU threads: 10; OS: macOS 14.2; UI render: Skia/Metal; VCL: osx Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded